C# code

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