با سلام مجدد
راه اول :
SqlConnection cnn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\Database1.mdf;Integrated Security=True;User Instance=True");
SqlDataAdapter da;
DataTable dt = new DataTable();
da = new SqlDataAdapter("select * from list where name like '" + textBox1.Text + "%'", cnn);
da.Fill(dt);
MessageBox.Show(dt.Rows.Count);
راه دوم :
SqlConnection cnn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\Database1.mdf;Integrated Security=True;User Instance=True");
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "select count(*) from list where name like '" + textBox1.Text + "%'";
object cnt = cmd.ExecuteScalar();
if (cnt != null)
{
//کد ساخت آرایه
}
else MessageBox.Show("No Record");
موفق باشی
بایت بایت