Styjun

Does two puncture wounds mean venomous snake?

Acceptable to cut steak before searing?

Could one become a successful researcher by writing some really good papers while being outside academia?

Infeasibility in mathematical optimization models

sed delete all the words before a match

Drawing complex inscribed and circumscribed polygons in TikZ

What is a raycast?

How many different ways are there to checkmate in the early game?

How do we avoid CI-driven development...?

Optimal way to extract "positive part" of a multivariate polynomial

Team goes to lunch frequently, I do intermittent fasting but still want to socialize

Max Order of an Isogeny Class of Rational Elliptic Curves is 8?

Why are Gatwick's runways too close together?

Ordering a word list

The pronunciation of "protester"

Plausibility of Ice Eaters in the Arctic

How does The Fools Guild make its money?

As a 16 year old, how can I keep my money safe from my mother?

Am I overreacting to my team leader's unethical requests?

Why aren’t emergency services using callsigns?

Why doesn't the "ch" pronunciation rule occur for words such as "durch" and "manchmal"?

Ex-contractor published company source code and secrets online

Looking for a new job because of relocation - is it okay to tell the real reason?

Y2K... in 2019?

Import data from database and textfile to a datagridview

Programmatically choose the class to be instantiateProblem in saving image to database from picturebox. VB.Net 2008. Framework 3.5WPF import multiple txt filesHow to load the state of checkboxlist in database asp.net?Find duplicats and display in new datagridview using LinqDisplaying data from .txt file in separate rows in DataGridViewWant to delete DataGridView column with Access database columnHow to filter datagridview columnHow to 'Group By' values in a column in DataGridView in Vb.NetDisplay Data in DatagridView with condition

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

i want to import data from txt file and database to a datagridview like this
first and second columns from txtfile third from database fourth from txt file is simple as that
i can import from txtfile and i can import from database myproblem
how to mix them in datagridview
i need just any idea how it work
or how i import a data to just 2 first columns after that i make query to third column after i return to txtfile and complete fill the datagridview from txt file
its like all datagridview from txtfile but in middle i want to add a new columns for database query

 Dim ouvrir As New OpenFileDialog
 If ouvrir.ShowDialog = DialogResult.OK Then
 Dim sr As New StreamReader(ouvrir.FileName)
 Dim cmd As New SqlCommand("select * from EntetedemandeI", cn)
 Dim da As SqlDataReader = cmd.ExecuteReader
 While Not sr.EndOfStream
 DataGridView1.Rows.Add(sr.ReadLine.Split(CChar(vbTab)))
 End While
 While da.Read
 DataGridView1.Rows.Add(da("Numero"))
 End While
 End If

vb.net

share|improve this question

edited Mar 28 at 16:11

Mary

5,11322 gold badges1111 silver badges2222 bronze badges

asked Mar 27 at 7:41

Mahjoubi houssemMahjoubi houssem

833 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I offered advice on how to do this elsewhere and you basically ignored it. The question is even less appropriate here because SO requires you to have a specific problem, which means you need to show what you've already tried. If you haven't tried anything then you don't have a specific problem but, rather, a need to research.
  
  – jmcilhinney
  Mar 27 at 8:00
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Long code snippets are virtually unreadable in comments, especially unformatted. Please do some reading to learn how this site works, then edit your question to an acceptable standard. Start with this, this and this at a minimum.
  
  – jmcilhinney
  Mar 27 at 23:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm not quite sure how but my previous comment does not contain what I intended. What I meant to say was that long code snippets are all but unreadable in comments, especially when unformatted. You should follow the three links I provided to learn a bit about how this site works and there's more in the Help Center besides, including information about formatting.
  
  – jmcilhinney
  Mar 28 at 7:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OK, that's weird. My second comment looked corrupted so I posted my third comment but, as I submitted, I noticed that my second comment looked OK again. Not sure what's up with that.
  
  – jmcilhinney
  Mar 28 at 7:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Note that I wasn't suggesting that you should format your code snippet in a comment but rather not post it in a comment at all. Edit your question to include all the relevant information that it should have included to begin with.
  
  – jmcilhinney
  Mar 28 at 7:35
  

  
  
  
  

 | 
show 1 more comment

0

i want to import data from txt file and database to a datagridview like this
first and second columns from txtfile third from database fourth from txt file is simple as that
i can import from txtfile and i can import from database myproblem
how to mix them in datagridview
i need just any idea how it work
or how i import a data to just 2 first columns after that i make query to third column after i return to txtfile and complete fill the datagridview from txt file
its like all datagridview from txtfile but in middle i want to add a new columns for database query

 Dim ouvrir As New OpenFileDialog
 If ouvrir.ShowDialog = DialogResult.OK Then
 Dim sr As New StreamReader(ouvrir.FileName)
 Dim cmd As New SqlCommand("select * from EntetedemandeI", cn)
 Dim da As SqlDataReader = cmd.ExecuteReader
 While Not sr.EndOfStream
 DataGridView1.Rows.Add(sr.ReadLine.Split(CChar(vbTab)))
 End While
 While da.Read
 DataGridView1.Rows.Add(da("Numero"))
 End While
 End If

vb.net

share|improve this question

edited Mar 28 at 16:11

Mary

5,11322 gold badges1111 silver badges2222 bronze badges

asked Mar 27 at 7:41

Mahjoubi houssemMahjoubi houssem

833 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I offered advice on how to do this elsewhere and you basically ignored it. The question is even less appropriate here because SO requires you to have a specific problem, which means you need to show what you've already tried. If you haven't tried anything then you don't have a specific problem but, rather, a need to research.
  
  – jmcilhinney
  Mar 27 at 8:00
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Long code snippets are virtually unreadable in comments, especially unformatted. Please do some reading to learn how this site works, then edit your question to an acceptable standard. Start with this, this and this at a minimum.
  
  – jmcilhinney
  Mar 27 at 23:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm not quite sure how but my previous comment does not contain what I intended. What I meant to say was that long code snippets are all but unreadable in comments, especially when unformatted. You should follow the three links I provided to learn a bit about how this site works and there's more in the Help Center besides, including information about formatting.
  
  – jmcilhinney
  Mar 28 at 7:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OK, that's weird. My second comment looked corrupted so I posted my third comment but, as I submitted, I noticed that my second comment looked OK again. Not sure what's up with that.
  
  – jmcilhinney
  Mar 28 at 7:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Note that I wasn't suggesting that you should format your code snippet in a comment but rather not post it in a comment at all. Edit your question to include all the relevant information that it should have included to begin with.
  
  – jmcilhinney
  Mar 28 at 7:35
  

  
  
  
  

 | 
show 1 more comment

i want to import data from txt file and database to a datagridview like this
first and second columns from txtfile third from database fourth from txt file is simple as that
i can import from txtfile and i can import from database myproblem
how to mix them in datagridview
i need just any idea how it work
or how i import a data to just 2 first columns after that i make query to third column after i return to txtfile and complete fill the datagridview from txt file
its like all datagridview from txtfile but in middle i want to add a new columns for database query

 Dim ouvrir As New OpenFileDialog
 If ouvrir.ShowDialog = DialogResult.OK Then
 Dim sr As New StreamReader(ouvrir.FileName)
 Dim cmd As New SqlCommand("select * from EntetedemandeI", cn)
 Dim da As SqlDataReader = cmd.ExecuteReader
 While Not sr.EndOfStream
 DataGridView1.Rows.Add(sr.ReadLine.Split(CChar(vbTab)))
 End While
 While da.Read
 DataGridView1.Rows.Add(da("Numero"))
 End While
 End If

vb.net

share|improve this question

edited Mar 28 at 16:11

Mary

5,11322 gold badges1111 silver badges2222 bronze badges

asked Mar 27 at 7:41

Mahjoubi houssemMahjoubi houssem

833 bronze badges

 Dim ouvrir As New OpenFileDialog
 If ouvrir.ShowDialog = DialogResult.OK Then
 Dim sr As New StreamReader(ouvrir.FileName)
 Dim cmd As New SqlCommand("select * from EntetedemandeI", cn)
 Dim da As SqlDataReader = cmd.ExecuteReader
 While Not sr.EndOfStream
 DataGridView1.Rows.Add(sr.ReadLine.Split(CChar(vbTab)))
 End While
 While da.Read
 DataGridView1.Rows.Add(da("Numero"))
 End While
 End If

share|improve this question

edited Mar 28 at 16:11

Mary

5,11322 gold badges1111 silver badges2222 bronze badges

asked Mar 27 at 7:41

Mahjoubi houssemMahjoubi houssem

833 bronze badges

share|improve this question

edited Mar 28 at 16:11

Mary

5,11322 gold badges1111 silver badges2222 bronze badges

asked Mar 27 at 7:41

Mahjoubi houssemMahjoubi houssem

833 bronze badges

edited Mar 28 at 16:11

Mary

5,11322 gold badges1111 silver badges2222 bronze badges

edited Mar 28 at 16:11

Mary

5,11322 gold badges1111 silver badges2222 bronze badges

asked Mar 27 at 7:41

Mahjoubi houssemMahjoubi houssem

833 bronze badges

asked Mar 27 at 7:41

Mahjoubi houssemMahjoubi houssem

833 bronze badges