вот мой код всей формы поиска но он не рабочий
private void Dead(string SetiP)
{
SqlConnectionStringBuilder bldr = new SqlConnectionStringBuilder();
bldr.DataSource = @".\SQLExpress";
bldr.IntegratedSecurity = true;
bldr.AttachDBFilename = @"C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Kursach.mdf";
using (SqlConnection cn = new SqlConnection(bldr.ConnectionString))
{
//try
//{
cn.Open();
string query = "Select * From Seti Where " + SetiP;
SqlCommand command = new SqlCommand(query, cn);
SqlDataReader reader1 = command.ExecuteReader();
List<string[]> data2 = new List<string[]>();
while (reader1.Read())
{
data2.Add(new string[2]);
data2[data2.Count - 1][0] = reader1[0].ToString();
data2[data2.Count - 1][1] = reader1[1].ToString();
}
reader1.Close();
cn.Close();
foreach (string[] s in data2)
dataGridView1.Rows.Add(s);
//}
//catch (SqlException ex)
//{
// MessageBox.Show(ex.Message);
//}
}
}
private void button1_Click(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
if (radioButton1.Checked == true)
{
Dead("topologiyaseti = '" + textBox1.Text + "'");
}
}