leontry89
چهارشنبه 18 تیر 1393, 12:36 عصر
دوستان مشکل این کد ساده چیست:
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["G"].ConnectionString); SqlCommand cmd;
con.Open();
cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
string str = "Select * from IndexNews";
SqlDataReader reader1 = new SqlCommand(str, con).ExecuteReader();
while (reader1.Read())
{
lblAjaxNews.Text = Convert.ToString(reader1["News"]);
lblDateTimeAjaxNews.Text = Convert.ToString(reader1["DateTime"]);
}
cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT TOP 5 * FROM Events ORDER BY ID DESC";
cmd.Connection = con;
if (con.State != ConnectionState.Open)
{
con.Open();
}
Repeater1.DataSource = cmd.ExecuteReader();
Repeater1.DataBind();
con.Close();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["G"].ConnectionString); SqlCommand cmd;
con.Open();
cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
string str = "Select * from IndexNews";
SqlDataReader reader1 = new SqlCommand(str, con).ExecuteReader();
while (reader1.Read())
{
lblAjaxNews.Text = Convert.ToString(reader1["News"]);
lblDateTimeAjaxNews.Text = Convert.ToString(reader1["DateTime"]);
}
cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT TOP 5 * FROM Events ORDER BY ID DESC";
cmd.Connection = con;
if (con.State != ConnectionState.Open)
{
con.Open();
}
Repeater1.DataSource = cmd.ExecuteReader();
Repeater1.DataBind();
con.Close();