c# selectOrsearch
public void selectOrsearch() { dt.Clear(); cmd = new SqlCommand("selectOrsearch_material", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@searchtxt", SqlDbType.NVarChar).Value = searchtxt.Text; da = new SqlDataAdapter(cmd); da.Fill(dt); this.metroGrid1.DataSource = dt; }