Refresh data from database

Dealy

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dealy17y ago

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 Patel17y ago

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 :)
0
Dealy17y ago
Won't this make the application slower? Because it should reconnect and retrieve data again.
0
Kirtan Patel17y ago
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 :)
0