display insert query data in datagridview?

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();
            }
}

thank you for all answers

Hi honar,

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

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?