update datagrid variables which is which

d2005

Active member
Joined
Aug 31, 2005
Messages
37
Location
ireland
Programming Experience
Beginner
trying to put in update cod for a datagrid


the lines im mstuck on are below.

VB.NET:
 Dim r As dscompmsg.0 
 
r = dsCompMsg.0.FindByCategoryID(key)
 
' Updates the dataset table.
 
r.msg_1 = msg_1
 
r.msg_2 = msg_2

but im wondering which variables are needed.

VB.NET:
 Private dsCompMsg As New DataSet 
 
Private daCompMsg As New SqlDataAdapter
 
oSQLConn.ConnectionString = "Data Source=(local);" & _
 
"Initial Catalog=TaT;" & _
 
"Integrated Security=SSPI"
 
oSQLConn.Open()
 
DataGrid1.DataSource = dsCompMsg.Tables(0)
 
DataGrid1.DataBind()
 
oSQLConn.Close()

what should my few lines of code look like
 
Top Bottom