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.

if i set enable adding to false it gives error index out of range

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

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

First, it's better to organize your code and make it readable


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

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