below is the code I'm using to populate a datagridview using a SP.
I want to be able to update my table once I press an update button.
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "NAME"
cmd.Parameters.Add("@DOC", SqlDbType.VarChar).Value = Me.l8.Text.ToString
con.Open()
sda.Fill(dt)
dg1.DataSource = dt
I can't figure out how to update the grid.
any help would be appreciated.
Thanks
I want to be able to update my table once I press an update button.
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "NAME"
cmd.Parameters.Add("@DOC", SqlDbType.VarChar).Value = Me.l8.Text.ToString
con.Open()
sda.Fill(dt)
dg1.DataSource = dt
I can't figure out how to update the grid.
any help would be appreciated.
Thanks