01.string mysqlcon = "Server=localhost;User Id=root; Password=root; Database=atpservicemotion; Pooling=false";
02. using (MySqlConnection cn = new MySqlConnection(mysqlcon))
03. {
04. MySqlDataAdapter adp = new MySqlDataAdapter("SELECT Email,namegroup FROM listgroup WHERE Email = '" + strUser + "'", cn);
05. DataTable dt = new DataTable();
06. adp.Fill(dt);
07. if (dt.Rows.Count > 0)
08. {
09. DropDownList1.DataSource = dt;
10. DropDownList1.DataTextField = "namegroup";
11. DropDownList1.DataValueField = "Email";
12. DropDownList1.DataBind();
13. }
14. }
