Comments by Member 3931350 (Top 2 by date)

here is my complete code please just have a look on it and suggest me the changes,

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class RetPlaceOrderNew2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string OrdType = "";
if (Session["OrderType"].ToString() != null)
OrdType = Session["OrderType"].ToString();

if (OrdType == "New")
{
txtOrderdt.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");

ddlWholeSaler.DataSource = Commanclass.returnData("Select CompanyName,RegId from RegstrationDet where Category='WholeSale'");
ddlWholeSaler.DataTextField = "CompanyName";
ddlWholeSaler.DataValueField = "RegId";
ddlWholeSaler.DataBind();

ddlWholeSaler.Items.Add("--Select WholeSaler--");
ddlWholeSaler.Items[ddlWholeSaler.Items.Count - 1].Value = "";
ddlWholeSaler.SelectedIndex = ddlWholeSaler.Items.Count - 1;

}
else
{
DataTable dt = new DataTable();
txtID.Text = Session["OrdId"].ToString();
txtOrderdt.Text = Session["OrdDate"].ToString();
dt = Commanclass.returnData("Select CompanyName,RegId from RegstrationDet where Category='WholeSale' and companyname='" + Session["OrdWhName"].ToString() + "'");
ddlWholeSaler.DataSource = dt;
ddlWholeSaler.DataTextField = "CompanyName";
ddlWholeSaler.DataValueField = "RegId";
ddlWholeSaler.DataBind();

ddlWholeSaler.Items.Add("--Select WholeSaler--");
ddlWholeSaler.Items[ddlWholeSaler.Items.Count - 1].Value = "";
ddlWholeSaler.SelectedIndex = ddlWholeSaler.Items.Count - 1;
Panel2.Visible = true;
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
FillWhOrderGrid(txtOrderdt.Text, Convert.ToInt32(dr[1].ToString()));
}
}
}
}
private void FillWhOrderGrid(string ordDate, int Whname)
{
SqlDataAdapter sqlDa;
SqlConnection SqlCon = DAL.GetConnectionString();
DataSet ds;
string sql = "";
try
{
//String.Format("{0:yyyy-MMM-dd}", DateTime.Now.Date)
sql = "SELECT RetailerOrder.OrderId, RetailerOrder.OrderDate, RetailerOrder.WhProdCode, RetailerOrder.Product, RetailerOrder.Packsize, RetailerOrder.Qty,RegstrationDet.CompanyName,Rate,Amount FROM RetailerOrder INNER JOIN RegstrationDet ON RetailerOrder.wholeSalerId = RegstrationDet.RegId where OrderDate='" + Convert.ToDateTime(ordDate).ToString("yyyy-MM-dd HH:mm:ss") + "' and RetailerId='" + Convert.ToString(Session["regid"]) + "' and wholesalerid=" + Whname + "";
Gridview1.DataSource = Commanclass.returnData(sql);
Gridview1.DataBind();

//dgOrder.DataSource = Commanclass.returnData(sql);
//dgOrder.DataBind();

sqlDa = new SqlDataAdapter(sql, SqlCon);
ds = new DataSet();
sqlDa.Fill(ds, "Suppliers");
//dgOrder.DataSource = ds.Tables["Suppliers"];
//dgOrder.DataBind();
}
catch (Exception er) { throw er; }
}
private void FillGrid(string ordDate)
{
SqlConnection SqlCon = DAL.GetConnectionString();
string sql = "";
try
{

//String.Format("{0:yyyy-MMM-dd}", DateTime.Now.Date)
sql = "SELECT RetailerOrder.OrderId, RetailerOrder.OrderDate, RegstrationDet.CompanyName, RetailerOrder.Product, RetailerOrder.Packsize, RetailerOrder.Qty,whProdCode,Rate,Amount FROM RetailerOrder INNER JOIN RegstrationDet ON RetailerOrder.wholeSalerId = RegstrationDet.RegId where OrderDate='" + Convert.ToDateTime(ordDate).ToString("yyyy-MM-dd HH:mm:ss") + "' and RetailerId=" + Convert.ToString(Session["regid"]) + " order by Product";
Gridview1.DataSource = Commanclass.returnData(sql);
Gridview1.DataBind();
//for (int i = 0; i < Gridview1.Rows[0].Cells.Count; i++)
//{
// Gridview1.Rows[0].Cells[i].Width = Unit.Pixel(200);
//}

}
catch (Exception er) { throw er; }
}
protected void ddlWholeSaler_SelectedIndexChanged(object sender, EventArgs e)
{
lblMsg.Text = "";
try
{

LoadProductPacksize();

string msg = Convert.ToString(Commanclass.returnData("select TextMessage from dbo.Message where RegId =" + ddlWholeSaler.SelectedValue + " and Approved=1").Rows[0]["TextMessage"]);
lblMsg.Text = "Message Fro