query

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Dec 2008
Posts: 39
Reputation: arunasingh is an unknown quantity at this point 
Solved Threads: 0
arunasingh arunasingh is offline Offline
Light Poster

query

 
0
  #1
Apr 28th, 2009
sir i am developing application in windows so i want that when i serach data that data then that data is dislpayed indatagridview when i am doing that thecvdata is displayed but there is one blank row created in gridview below that row:means that suppose in first row of gridview tge serach data is there and below that an emnpty row is created .so how i block to create an empty row
i do search in keydown event
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 63
Reputation: 4advanced is an unknown quantity at this point 
Solved Threads: 10
4advanced 4advanced is offline Offline
Junior Poster in Training

Re: query

 
0
  #2
Apr 28th, 2009
If you don't want the blank row to be shown you have to set the 'enable adding' property in the designtime to be false.
Reply With Quote Quick reply to this message  
Join Date: Dec 2008
Posts: 39
Reputation: arunasingh is an unknown quantity at this point 
Solved Threads: 0
arunasingh arunasingh is offline Offline
Light Poster

Re: query

 
0
  #3
Apr 28th, 2009
if i set enable adding to false it gives error index out of range
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 63
Reputation: 4advanced is an unknown quantity at this point 
Solved Threads: 10
4advanced 4advanced is offline Offline
Junior Poster in Training

Re: query

 
0
  #4
Apr 28th, 2009
At which point it generates that error? If the index is out of range you're trying to get a non existing row in the collection of rows......

Could you show some code?

Regards
Reply With Quote Quick reply to this message  
Join Date: Dec 2008
Posts: 39
Reputation: arunasingh is an unknown quantity at this point 
Solved Threads: 0
arunasingh arunasingh is offline Offline
Light Poster

Re: query

 
0
  #5
Apr 29th, 2009
con = New OleDbConnection(constr) adpt = New OleDbDataAdapter("select * from drs_entry_list where drsno='" + DrsnoToolStripTextBox.Text + "' order by srno", con)
ds = New DataSet
adpt.Fill(ds)
If ds.Tables(0).Rows.Count - 1 >= 0 Then
For j As Integer = 0 To ds.Table0).Rows.Count - 1
Dim org As String = ds.Tables(0).Rows(j).Item(4) DataGridView1.Rows(DataGridView1.Rows(j).Cells(0).rowindex).Cells(5).Value = org.ToString
Dim AWBNO As Integer = ds.Tables(0).Rows(j).Item(1)
DataGridView1.Rows(DataGridView1.Rows(j).Cells(1).RowIndex).Cells(1).Value = AWBNO.ToString

Next
End If
End If


in this when i search through drsno the in datagridview it gives error :Index was out of range : i need that row is fetched and below it no empty row is created and when i press enter in any cell of datagridview a bove row ios copied as second row in datagridview
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 63
Reputation: 4advanced is an unknown quantity at this point 
Solved Threads: 10
4advanced 4advanced is offline Offline
Junior Poster in Training

Re: query

 
0
  #6
Apr 29th, 2009
First, it's better to organize your code and make it readable

con = New OleDbConnection(constr) 
adpt = New OleDbDataAdapter("select * from drs_entry_list where drsno='" + DrsnoToolStripTextBox.Text + "' order by srno", con)
ds = New DataSet
adpt.Fill(ds)

Dim MyTable as DataTable = ds.Tables(0)

If MyTable.Rows.Count - 1 >= 0 Then

etc etc etc.

Second, if no records has been found, the code If MyTable .Rows.Count - 1 >= 0 will raise an error because "Rows.Count = 0" and it cannot be decreased -1

Check if Rows.Count > 0
Last edited by 4advanced; Apr 29th, 2009 at 4:31 am.
Reply With Quote Quick reply to this message  
Join Date: Dec 2008
Posts: 39
Reputation: arunasingh is an unknown quantity at this point 
Solved Threads: 0
arunasingh arunasingh is offline Offline
Light Poster

Re: query

 
0
  #7
Apr 29th, 2009
thanku for thias it is working , next i want to set focus from one cell to another of datagridview on pressing enter in datagridview cell
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC