This tutorial will teach you how to make the Search Records using C#.net step by step.
if you enter the Account id on the textbox relavent matching record will be displayed on the datagridview.
Establish the database connection
1 | SqlConnection con = new SqlConnection("server=.;database=Bank; integrated security=true;"); |
Paste the code inside the find button
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | SqlDataAdapter sh_adapter9; DataSet sh_dataset19; DataTable sh_table9; sh_adapter9 = new SqlDataAdapter("select * from account where accountno=@p1", con); sh_adapter9.SelectCommand.Parameters.Add(new SqlParameter("@p1", SqlDbType.Char, 20)); sh_adapter9.SelectCommand.Parameters["@p1"].Value = T_11.Text; sh_dataset19 = new DataSet(); sh_dataset19.Tables.GetEnumerator(); sh_adapter9.Fill(sh_dataset19, "f"); sh_table9 = sh_dataset19.Tables["f"]; if (sh_table9.Rows.Count == 0) { MessageBox.Show("Record Not Found"); } dataGridView1.DataSource = sh_dataset19; dataGridView1.DataMember = "f"; } } |
I have attached the video tutorial below it will help you to do this step by step.