public partial class Form1 : Form
{
SqlConnection con;
SqlCommand com;
DataSet ds;
SqlDataAdapter da;
public Form1()
{
InitializeComponent();
con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=DB;Integrated Security=True");
com = new SqlCommand("select * From Table", con);
ds = new DataSet();
da = new SqlDataAdapter(com);
con.Open();
da.Fill(ds, "Table");
con.Close();
dataGridView1.DataSource = ds.Tables[0];
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
ds.Tables[0].DefaultView.RowFilter = "f_Name =" + textBox1.Text;
}
}