datagridview values

Question

hai i have a form with a several textboxes and datagridview. when i enter the name of the student the names are displayed in the datagridview. but i have a problem that the values in datagridview are doubled each time enter the textboxes. plz help. i use this code . private void textBox14_TextChanged( object sender EventArgs e) { namegrid.Visible = true ; cmd.CommandText = select staffname from staff where staffname like ' + textBox14.Text + %' ; da.SelectCommand = cmd; da.Fill(ds item ); DataTable dt = ds.Tables[ item ]; namegrid.DataSource = dt; }

Soft Corner · Answer

Hi Shyja as suthish told  You need to reset or clear the Gridview every time. is rgt  apply this in your code i have 1 sample code for you : private void textBox1_TextChanged(object sender EventArgs e) { namegrid.DataSource = null; if (textBox1.Text != ) { namegrid.Visible = true; //Replace Your Connection String SqlConnection cnn = new SqlConnection(Data Source=.\SQLEXPRESS;Initial Catalog=MyDb;Integrated Security=true); //Replace your query here SqlDataAdapter da = new SqlDataAdapter(select studentname from schoolinfo where studentid like ' + textBox1.Text + %' cnn); DataSet ds = new DataSet(); //place table name da.Fill(ds schoolinfo); namegrid.DataSource = ds.Tables[schoolinfo]; } } Hope this will help you ..

Shyja Abraham · Answer

not resolved this problem

Suthish Nair · Answer

resolved?

Suthish Nair · Answer

Secondly always use Parametrized Queries. Parameterized Query and SQL Injection Attacks You need to reset or clear the Gridview every time.

Suthish Nair · Answer

Shyja Is this a duplicate post? I remember replying same thread couple of days ago. Edit your existing thread only instead of creating new ones.

Ketul Rathod · Answer

U can Write in Any button click Event........ Or U Can True the autopostback properties of TextBoxe......... private void Button_Clicked( object sender EventArgs e) { namegrid.Visible = true ; cmd.CommandText = select staffname from staff where staffname like ' + textBox14.Text + %' ; da.SelectCommand = cmd; da.Fill(ds item ); DataTable dt = ds.Tables[ item ]; namegrid.DataSource = dt; }