public DataTable getNam() { DataTable dt = new DataTable(); cmd.CommandText = "SELECT year(ngayban) as ngayban from HOADONBAN group by year(ngayban)"; //cmd = new SqlCommand(cmd.CommandText, con.Connection); //SqlDataAdapter da = new SqlDataAdapter(cmd); //da.Fill(dt); //da.Dispose(); cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.OpenConn(); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); con.CloseConn(); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); con.CloseConn(); } return(dt); }
private void BindData() { cmd.CommandText = "select * from Master.Customers"; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; conn.OpenConn(); sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); dvitem = dt.DefaultView; grvitem.DataSource = dvitem; grvitem.DataBind(); Session["TaskTable"] = dt; }
private void BindData() { cmd.CommandText = "SELECT * FROM [order].[Order]"; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; conn.OpenConn(); sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); dvitem = dt.DefaultView; grvitem.DataSource = dvitem; grvitem.DataBind(); Session["TaskTable"] = dt; }
public void tdl() { int x = 1; string[] a = new string[99]; cmd.CommandText = "select orderdate from [order].[Order] where orderid = " + Session["idorder"]; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; conn.OpenConn(); sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); Label2.Text = "time: " + dt.Rows[0][0].ToString(); Label1.Text = "orderid: " + Session["idorder"]; cmd.CommandText = "SELECT [ItemId],[Price],[Quantity],[Discount],[Total]FROM [order].[OrderDetails] where orderid =" + Session["idorder"]; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; conn.OpenConn(); sda = new SqlDataAdapter(cmd); DataTable dt2 = new DataTable(); sda.Fill(dt2); foreach (DataRow row in dt2.Rows) { cmd.CommandText = "SELECT [ItemName]FROM [Master].[Item] where itemid =" + row[0].ToString(); cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; conn.OpenConn(); sda = new SqlDataAdapter(cmd); DataTable dt3 = new DataTable(); sda.Fill(dt3); tenmon = dt3.Rows[0][0].ToString(); a[x] = "id iteam= " + row[0].ToString() + " name item= " + tenmon + " price= " + row[1].ToString() + " quantyti= " + row[2].ToString() + " dicount= " + row[3].ToString() + " total= " + row[4].ToString() + "\n"; x++; } string message = String.Join(" ", a); TextBox1.Text = message; }
public bool GetID(string name, string pw) //lấy tên đăng nhập { DataTable dt = new DataTable(); cmd.CommandText = "select UN from loginn where UN = '" + name + "' and PW = '" + pw + "'"; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; try { conn.OpenConn(); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); if (dt.Rows.Count > 0) { return(true); } } catch (Exception ex) { string mex = ex.Message; } return(false); }
public void tdl() { int[] z = new int[99]; int[] x = new int[99]; int[] y = new int[99]; string[] a = new string[99]; int t = 1; cmd.CommandText = "select itemid from [Master].[Item]"; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; conn.OpenConn(); sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); foreach (DataRow row in dt.Rows) { z[t] = Convert.ToInt32(row[0]); t++; } for (int i = 1; i <= t; i++) { cmd.CommandText = "SELECT [Quantity],[Total]FROM [order].[OrderDetails] where ItemId= " + z[i].ToString(); cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; conn.OpenConn(); sda = new SqlDataAdapter(cmd); DataTable dt2 = new DataTable(); sda.Fill(dt2); x[z[i]] = 0; y[z[i]] = 0; foreach (DataRow row in dt2.Rows) { int p = Convert.ToInt32(row[0]); int q = Convert.ToInt32(row[1]); x[z[i]] = x[z[i]] + p; y[z[i]] = y[z[i]] + q; } } for (int i = 1; i < t; i++) { for (int j = i + 1; j <= t; j++) { if (x[z[i]] < x[z[j]]) { int c; c = z[i]; z[i] = z[j]; z[j] = c; } } } for (int i = 1; i <= t; i++) { cmd.CommandText = "select itemname, ItemPirce from [Master].[Item] where itemid=" + z[i].ToString(); cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; conn.OpenConn(); sda = new SqlDataAdapter(cmd); DataTable dt3 = new DataTable(); sda.Fill(dt3); foreach (DataRow row in dt3.Rows) { a[i] = "itemID= " + z[i].ToString() + " ItemName= " + row[0].ToString() + " price= " + row[1].ToString() + " tổng số lượng bán ra= " + x[z[i]].ToString() + " tổng doanh thu= " + y[z[i]].ToString() + "\n"; } } string message = String.Join(" ", a); TextBox1.Text = message; }