Beispiel #1
0
        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);

                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);
            }
        }
Beispiel #2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     conString = WebClass.getConnectionStringByName("sqlSConString");
 }