c# selectOrsearch

 avatar
unknown
assembly_x86
3 years ago
397 B
1
Indexable
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;
        }