hosseine_haji
سه شنبه 17 آبان 1390, 21:02 عصر
سلام من این کد رو تو سی شارپ مینویسم و برای جستجو یک فیلد جواب میگیرم ولی تو asp.net جواب نمیده چه تغییری بدم؟
//1:
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\SS.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlDataAdapter adapt = new SqlDataAdapter();
adapt.SelectCommand = new SqlCommand();
adapt.SelectCommand.Connection = con;
adapt.SelectCommand.CommandText =string .Format( "select * from stu where id='{0}'",Int32.Parse(textBox7.Text));
DataTable dt = new DataTable();
adapt.Fill(dt);
con.Close();
dataGridView1.DataSource = dt;
//1:
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\SS.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlDataAdapter adapt = new SqlDataAdapter();
adapt.SelectCommand = new SqlCommand();
adapt.SelectCommand.Connection = con;
adapt.SelectCommand.CommandText =string .Format( "select * from stu where id='{0}'",Int32.Parse(textBox7.Text));
DataTable dt = new DataTable();
adapt.Fill(dt);
con.Close();
dataGridView1.DataSource = dt;