plz help me its urgent

Question

I am creating a windows app. in which I have a taken a button and a datagrid view that connect to sql table I have a text box I want if I enter a id in the text box and click the button then all the matching records should come in that datagrid view ?

Niradhip Chakraborty · Answer

OleDbConnection con = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\db1.mdb); con.Open(); string strsql = select * from Usertable where usr_int_id =+textbox1.text+; OleDbCommand aCommand = new OleDbCommand(strsql aConnection); OleDbDataAdapter da = new OleDbDataAdapter(aCommand); ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds; con.Close(); // So the concept is we are passing the textbox ivalue to sql select statement to filter the exact record we want to show in datagrid view.

Atul sharma · Answer

thanks nikhil

plz help me its urgent,,,,,,,,,,