protected void LoadOrderSummary(string orderNum) { cnDryClean.Open(); string sql = "select c.ClothName, c.ClothCleaningPrice FROM Cloth c " + "INNER JOIN Orders o ON c.ClothId = o.ClothId WHERE OrderNum = @orderNum"; using (SqlCommand cmd = new SqlCommand(sql, cnDryClean)) { cmd.Parameters.Add("@orderNum", SqlDbType.VarChar); cmd.Parameters["@orderNum"].Value = orderNum; SqlDataReader dr = cmd.ExecuteReader(); ordersTable.Load(dr); dr.Close(); } cnDryClean.Close(); OrdersGrid.DataSource = ordersTable; OrdersGrid.DataBind(); }
protected void dataBind() { OrdersGrid.DataSource = (DataTable)Session["SqlDataSource"]; OrdersGrid.DataBind(); }
protected void OrdersGrid_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e) { OrdersGrid.DataBind(); }
protected void SearchOrders_Click(object sender, EventArgs e) { String timeperiod = RadioButtonList1.SelectedValue.ToString(); String status = RadioButtonList3.SelectedValue.ToString(); String sql = ""; String sql2 = ""; conn = new MySqlConnection(GetConnectionString()); if (timeperiod.Equals("By Day")) { String temp = DropDownList3.SelectedValue.ToString(); sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where DATE_FORMAT(Date_Time,'%d-%M-%Y') like '" + temp + "'"; } if (timeperiod.Equals("By Week")) { String temp = DropDownList1.SelectedValue.ToString(); sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where WEEK(Date_Time) = " + temp + ""; } if (timeperiod.Equals("By Month")) { String temp = DropDownList2.SelectedValue.ToString(); sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where MONTHNAME(Date_Time) = '" + temp + "'"; } if (timeperiod.Equals("By Quarter")) { String temp = DropDownList4.SelectedValue.ToString(); sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where QUARTER(Date_Time) = " + temp + ""; } if (timeperiod.Equals("Custom Date")) { String date1 = TextBox5.Text; String date2 = TextBox6.Text; sql = "Select Order_ID,Amount,Quantity,Date_Time,Order_Received from Order_Detail_Store where DATE(Date_Time) BETWEEN '" + date1 + "' AND '" + date2 + "'"; } if (status.Equals("") || status.Equals("All")) { sql2 = ""; } if (status.Equals("Received")) { sql2 = " and Order_Received='Completed'"; } if (status.Equals("Pending")) { sql2 = " and Order_Received='Pending'"; } Response.Write(sql + sql2); try { conn.Open(); MySqlCommand comm = new MySqlCommand(sql + sql2, conn); MySqlDataReader dr1 = comm.ExecuteReader(); OrdersGrid.DataSource = dr1; OrdersGrid.DataBind(); dr1.Close(); } catch (Exception ex) { Response.Write(ex.Message); } finally { conn.Close(); } }