string conString;// = @"Data Source = DESKTOP-TSV4T6E\MSSQL2014; Initial Catalog=Sample;User id=log1;Password=1";
protected void Page_Load(object sender, EventArgs e)
{
conString = WebClass.getConnectionStringByName("sqlSConString");
if (!Page.IsPostBack)
{
#region Đọc dữ liệu và đưa lên danh sách dropdownlist
//ddlTheLoai.Items.Clear();
ListItem item0 = new ListItem();
item0.Value = "-1";
item0.Text = "Chọn thể loại";
ddlTheLoai.Items.Add(item0);
SqlConnection sqlcon = new SqlConnection();
SqlCommand sqlcom2 = new SqlCommand();
try
{
sqlcon.ConnectionString = conString;
sqlcon.Open();
if (sqlcon.State == System.Data.ConnectionState.Open)
{
sqlcom2.Connection = sqlcon;
sqlcom2.CommandType = System.Data.CommandType.Text;
sqlcom2.CommandText = "SELECT maTheLoai, tenTheLoai FROM TheLoai";
SqlDataReader sqlreader = sqlcom2.ExecuteReader();
if (sqlreader.HasRows)
{
while (sqlreader.Read())
{
ListItem item = new ListItem();
item.Value = sqlreader.GetInt32(0).ToString(); //ma the loai
item.Text = sqlreader.GetSqlString(1).ToString(); //ten the loai
ddlTheLoai.Items.Add(item);
}
}
}
}
catch (Exception exc)
{
lThongBao.Text = String.Format("Lỗi: {0}. Chi tiết: {1}", exc.Message, exc.StackTrace);
}
finally
{
sqlcon.Close();
sqlcom2.Dispose();
}
#endregion
//đưa dữ liệu lên lưới dữ liệu gridview
//BindDataToGridView(-1);
}
}
string conString; //= @"Data Source = DESKTOP-TSV4T6E\MSSQL2014; Initial Catalog=Sample;User id=log1;Password=1";
protected void Page_Load(object sender, EventArgs e)
{
conString = WebClass.getConnectionStringByName("sqlSConString");
//Response.Write("conString: "+conString+"<br />");
if (!Page.IsPostBack)
{
#region Đọc dữ liệu và đưa lên danh sách dropdownlist
//ddlTheLoai.Items.Clear();
ListItem item0 = new ListItem();
item0.Value = "-1";
item0.Text = "Chọn thể loại";
ddlTheLoai.Items.Add(item0);
//Doan ma nay se duoc thay the bang doan ma duoi - tuong duong
/*SqlConnection sqlcon = new SqlConnection();
* SqlCommand sqlcom2 = new SqlCommand();
* try
* {
* sqlcon.ConnectionString = conString;
* sqlcon.Open();
* if (sqlcon.State == System.Data.ConnectionState.Open)
* {
* sqlcom2.Connection = sqlcon;
* sqlcom2.CommandType = System.Data.CommandType.Text;
* sqlcom2.CommandText = "SELECT maTheLoai, tenTheLoai FROM TheLoai";
* SqlDataReader sqlreader = sqlcom2.ExecuteReader();
*
*
* if (sqlreader.HasRows)
* {
* while (sqlreader.Read())
* {
* ListItem item = new ListItem();
* item.Value = sqlreader.GetInt32(0).ToString(); //ma the loai
* item.Text = sqlreader.GetSqlString(1).ToString();//ten the loai
* ddlTheLoai.Items.Add(item);
* }
* }
* }
* }
* catch (Exception exc)
* {
* lThongBao.Text = String.Format("Lỗi: {0}. Chi tiết: {1}", exc.Message, exc.StackTrace);
* }
* finally
* {
* sqlcon.Close();
* sqlcom2.Dispose();
* }
*/
try
{
CommonCode.DataClasses.DataTool dataTool = new CommonCode.DataClasses.DataTool();
string sql = "SELECT maTheLoai, tenTheLoai FROM TheLoai";
SqlDataReader sqlreader = dataTool.execReader(conString, sql, null);
if (sqlreader != null && sqlreader.HasRows)
{
while (sqlreader.Read())
{
ListItem item = new ListItem();
item.Value = sqlreader.GetInt32(0).ToString(); //ma the loai
item.Text = sqlreader.GetSqlString(1).ToString(); //ten the loai
ddlTheLoai.Items.Add(item);
}
}
}
catch (Exception exc)
{
Response.Write(String.Format("Lỗi: {0}. Chi tiết: {1}", exc.Message, exc.StackTrace));
}
finally
{
}
#endregion
//đưa dữ liệu lên lưới dữ liệu gridview
BindDataToGridView(-1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
conString = WebClass.getConnectionStringByName("sqlSConString");
}