Need query for findin next field from sql

[cheruvannoor]

i want sample code for getting next field from sql.i had one query,but problem with that is suppose i had 5 entries,if i had deleted the 4th entrythen it wont move next from field '3'

My sample code is given below
query = "select * from branch where brbranchid= " & Txtkey.Text & " +1"

thanks and regards
cheruvannoor

 

[nakracreative]

if you want to get all the field names from your table then you can use the properties and methods of dataset object.

objdataset.tables("<tablename>").rows(0).item(<increment this value by 1>)

and you will get the names of your fieldnames.

 

[cheruvannoor]

update command

i want to update a table using sql query after deleting a field

 

[nakracreative]

in that case .net provides us the parameters collection object and you must avail of it as its a very easy to use object.

be more clear with the updation that you want, so that i can post you the excat code.

 

[cheruvannoor]

i am using buttons(first,next,previous and last) for displaying fields from sql
suppose i had deleted a particular field,then the table is not updating.Bcoz of that if i had deleted the 3rd field,by using
'next'button i cant move to 5th field.what can i do for that

 

[kulrom]

after you delete get clear data and fill again ... that's simpliest solution i beleive

Regards

 

[cheruvannoor]

hello sir
i am new to vb.net.how can i do that

thanks and regards
cheruvannoor

 

[kulrom]

i can't help you untill i haven't seen your project ... btw, are you using dataset or datareader to retrieve the data?

Regards

 

[cheruvannoor]

i want to update my table after deletion
my sample code is given below



Private Sub Butndelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Butndelete.Click

If Txtkey.Text = "" Then
MsgBox("No Records To Be Deleted", vbExclamation, "System Validation")

Exit Sub
Else
If MsgBox("Are You Sure You Want To Delete This Record?", vbYesNo + vbQuestion, "Delete Confirmation") = 6 Then

Try

query1 = "delete from branch where brBranchId = " & Txtkey.Text & ""

myconn.CommandText = query1
myconn.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.ToString)
End Try



MsgBox("RECORD Deleted", 64, "SYSTEM MESSAGE")

End If
End If

 

[cheruvannoor]

gmode in vb.net

how do we use
'cmdOK.Tag = "add",gMode = 1,lmode = 1'(this is in vb)
in VB.NET
thanks and regarsds
Cheruvannoor