Refresh data from database

Question

Hello, Is there a way to refresh the data of a form after insertion? At insert the database fills some fields automatically for the user and i want the user to view them automatically after the insertion of the record. Thank you.

Dealy · Answer

Kirtan thanks again for all the help. After a little research in the subject I decided to use output variable in the Stored Procedure in order to avoid the reselection. Below i give the code snippet for stored procedure and C#, using Northwind as a database. Stored procedure: CREATE PROCEDURE INSERT_ORDERS (@CustomerID nchar(5), @Freight money, @OrdersID nvarchar(10) output) AS INSERT Orders (CustomerID,Freight) VALUES(@CustomerID,@Freight) SELECT @OrdersID=@@IDENTITY GO C# code: private void saveToolStripButton_Click(object sender, EventArgs e) { string connectionString = @"Server=locServ; Initial Catalog=Northwind; Integrated Security=True"; using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand("INSERT_ORDERS", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@OrdersID", SqlDbType.Int); command.Parameters["@OrdersID"].Direction = ParameterDirection.Output; command.Parameters.Add("@CustomerID", SqlDbType.VarChar).Value = custID_txt.Text; command.Parameters.Add("@Freight", SqlDbType.Money).Value = freight_txt.Text; conn.Open(); int rows = command.ExecuteNonQuery(); orderID_txt.Text = ((int)command.Parameters["@OrdersID"].Value).ToString(); conn.Close(); } }

Kirtan Patel · Answer

yes, this will make but there is no other option . because you have updated/Inserted record in database you have to reconnect to server to get latest data to dataGridView. think that insertion operations are not performed as frequently as deletion and Updation done !! so its considerable. in case of Filter you should not use this type of strategy you can directly filter data from already filled data set :) dont forget to mark " do you like answer please it will give me some credits :)

Dealy · Answer

Won't this make the application slower? Because it should reconnect and retrieve data again.

Kirtan Patel · Answer

Hi Friend , you should make function to Show Data into DataGridView like ------------------------------------------------------------------------------------------- public void ShowData() { // Coding for Showing Data In DataGridView } now when you press Insert Button say Button1 then Code Would be like below public void Button1_Click (Object Sender , EventArgs e) { //Code for Inserting Details into database //Below Show Data Function Will Automatically Refresh The DataGridView ShowData(); } ---------------------------------------------------------------------------------------------------------- dont forget to mark " Do you like answer " please it will give me some credits :)

Refresh data from database

Answers (4)