Refresh a Datagrid

[PRPhx]

I'm working on a windows form project. I have a datagrid thast is populated from an SQL Server based data adapter. I have several text boxes and check boxes the user enter info/checks the boxes. Hitting add adds the info to the table, no problem.

The question is: Ince the data is entered into the table, how do I refresh the datagrid to reflect the new row???? I've tried datagrid1.refresh, tried using a binding manager, etc. Nothing seems to work. What am I doing wrong? Should I re-execute my stored procedure to re-populate my datagrid? What amI doing wrong?

 

[jebenson]

How are you adding the data to the table?


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[chmohan]

If you are using dataset in the ui then its easy isnt it?
Why does it clear in teh first place when he adds it ? Shouldnt it still be there on UI?

 

[PRPhx]

I am using an line SQL Insert command to add data to the tables. Picks up values from text boxes and check boxes, does some checking then I execute the SQL with ExecuteNonQuery(, after I have added the parameters.

He is my code:

Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim x As Boolean = False 'Used to set bit values if a check box is NOT checked.

Try
If objConn.State = ConnectionState.Closed Then
objConn.Open()
End If
SprocCommand.Connection = objConn
SprocCommand.CommandText = "INSERT INTO keyfile (pass,user_id,name,Sys_admin,view_sec) VALUES(@pass,@user_id,@name,@Sys_Admin,@view_sec)"

'Add the parameters as placeholders in the sql in the commandtext property
SprocCommand.Parameters.Add("@pass", txtNewPass.Text.ToUpper)
SprocCommand.Parameters.Add("@User_id", txtUserID.Text.ToUpper)
SprocCommand.Parameters.Add("@Name", txtName.Text.ToUpper)
If CheckBox1.Checked = True Then
SprocCommand.Parameters.Add("@Sys_Admin", CheckBox1.Checked)
Else
SprocCommand.Parameters.Add("@Sys_Admin", x)
End If

If CheckBox5.Checked = True Then
SprocCommand.Parameters.Add("@view_sec", CheckBox5.Checked)
Else
SprocCommand.Parameters.Add("@@view_sec", x)
End If

'execute the sql command object to insert the new data
SprocCommand.ExecuteNonQuery()

Catch ex As OleDb.OleDbException
'MessageBox.Show("An error occurred while entering the new user.")
MessageBox.Show(ex.ToString)
End Try

'close the db connection
objConn.Close()

txtUserID.Text = ""
txtName.Text = ""
txtPass1.Text = ""
txtNewPass.Text = ""
CheckBox1.Checked = False
CheckBox5.Checked = False

End Sub

 

[jebenson]

If you use ExecuteNonQuery to insert the data then you will have to requery the DB to get th new data to show up in your DataTable and DataGrid. To avoid this, you should add the new data to the DataTable (in a new row) then call the DataAdapter's Update method.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson