alonemm
پنج شنبه 17 تیر 1389, 18:01 عصر
باسلام:
اشكال كد زير چيه كه اطلاعات رو نمايش نميده؟
SqlConnection conObj = new SqlConnection();
conObj.ConnectionString = "Data Source=SERVER\\SQLEXPRESS;Initial Catalog=db;Integrated Security=True";
string commandText = "select * from tb";
SqlCommand cmdObj = new SqlCommand(commandText , conObj);
conObj.Open();
SqlDataReader dr = cmdObj.ExecuteReader();
while (dr.Read())
{
label1.Text += dr["name"].ToString();
label1.Text += "." + dr["family"].ToString() + "-";
}
dataGridView1.DataSource = dr.Read();
conObj.Close();
اشكال كد زير چيه كه اطلاعات رو نمايش نميده؟
SqlConnection conObj = new SqlConnection();
conObj.ConnectionString = "Data Source=SERVER\\SQLEXPRESS;Initial Catalog=db;Integrated Security=True";
string commandText = "select * from tb";
SqlCommand cmdObj = new SqlCommand(commandText , conObj);
conObj.Open();
SqlDataReader dr = cmdObj.ExecuteReader();
while (dr.Read())
{
label1.Text += dr["name"].ToString();
label1.Text += "." + dr["family"].ToString() + "-";
}
dataGridView1.DataSource = dr.Read();
conObj.Close();