display insert query data in datagridview?

Question

i have form with some textboxes and a button to insert data into database and below the form i have datagridview in to insert data from the form to the database and automatically display inserted datafrom datagridview ... i want to textbox textchange event for display data in datagridview not button click event?

Iftikar Hussain · Answer

Hi, You can write query on textchange event private void textBox1_TextChanged(object sender, EventArgs e) { string searchData = textBox1.Text; DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(@"Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUser;Password=MyPaswword")) { if (conn.State == ConnectionState.Closed) conn.Open(); string sql = "Select * from YourTable where Year>=@Year"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Year", searchData); SqlDataAdapter dap = new SqlDataAdapter(cmd); dap.Fill(dt); if (conn.State == ConnectionState.Open) conn.Close(); conn.Dispose(); } } Regards, Iftikar

Prasenjit Dey · Answer

Yes. You can do this. For that follow that code private void txtBox1_TextChanged(object sender, EventArgs e) { int searchData = Convert.ToInt32(textBox1.Text); DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(@"Data Source=SqlServer;Initial Catalog=TestDb;Persist Security Info=True;User ID=TestUser;Password=TestPassword")) { if (conn.State == ConnectionState.Closed || conn.State == ConnectionState.Broken) conn.Open(); string sql = "Select * from YourTable where Year like '%@searchData %' "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@searchData ", searchData); SqlDataAdapter adp = new SqlDataAdapter(cmd); adp .Fill(dt); if (conn.State == ConnectionState.Open) conn.Close(); conn.Dispose(); } }

honar abubakr · Answer

thank you for all answers

Sunny Sharma · Answer

Hi honar, Yes, you can do this. Please share your aspx page.

honar abubakr · Answer

ok i try to explain the idea more i have windows form with four textboxes txt1,txt2,txt3,txt4 and a button bt1 my form is for insertind data from textboxes into database,i use bt1 click event to insert data into database. and under the form i have datagridview ... i want to use txt3 textchange event to display data in my database table in datagridview. for ex/ in txt3 i have year i want to say in textbox textchange display data in datagridview when txt3.text = any year? is my question clear or not?

Prasenjit Dey · Answer

At first provide some code you had tried. Otherwise it is very difficult to answer of your question. You want to insert data in textbox textchange event, which is a bad idea. May be you want to do scenario like when you enter all your data into textbox then the event will fire. In that case you can use textbox leave event. Please let me know your response

display insert query data in datagridview?

Answers (6)