using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Data.SqlClient; using System.IO; using System.Text; public partial class DomHost_PreviewQO : System.Web.UI.Page { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString); static string QONO; string SO; DataTable dt; protected void Page_Load(object sender, EventArgs e) { //QONO = Session["Cd"].ToString(); QONO = Request.QueryString["ID"]; //if (Con.State == ConnectionState.Closed) //{ // Con.Open(); //} // string str1 = "select Id,ClientName,Address from tbl_ClientMaster where Id='" + SO + "'"; //SqlCommand cm = new SqlCommand(str1, Con); //SqlDataReader dr = cm.ExecuteReader(CommandBehavior.CloseConnection); //while (dr.Read()) //{ // lblClientNm.Text = dr[1].ToString(); // lblAddress.Text = dr[2].ToString(); //} //dr.Close(); if (Con.State == ConnectionState.Closed) { Con.Open(); } string city = "select QOID,Convert(varchar(20),Date,103) as Date,SrNO,Total,NetTotal,CSTcalc,Rsinword,ClientName,Address,PaymentTerms,DeliveryMode from MstQuotation where QOID='" + QONO + "'"; SqlCommand cmdcity = new SqlCommand(city, Con); SqlDataReader drcity = cmdcity.ExecuteReader(CommandBehavior.CloseConnection); while (drcity.Read()) { lblinvoiceno.Text = drcity[0].ToString(); lbldates.Text = drcity[1].ToString(); lblsrno.Text = drcity[2].ToString(); lbltotal.Text = drcity[3].ToString(); lblgrandtotal.Text = drcity[4].ToString(); lblst.Text = drcity[5].ToString(); lblRsWord.Text = drcity[6].ToString(); lblClientNm.Text = drcity[7].ToString(); lblAddress.Text = drcity[8].ToString(); lblpaymnttrms.Text = drcity[9].ToString(); lblPaymentMode.Text = drcity[10].ToString(); } Con.Close(); bindGridView(); } //BINDING GRIDVIEW// public void bindGridView() { if (Con.State == ConnectionState.Closed) { Con.Open(); } string strIn = "select Description,Remarks,Unit,Quantity+' '+ Unit as Quantity,RatePer,Amount from Quotation where ID='" + QONO + "'"; SqlDataAdapter da = new SqlDataAdapter(strIn, Con); DataSet dsgv = new DataSet(); da.Fill(dsgv, "updateso"); dt = (DataTable)dsgv.Tables[0]; ViewState["CurrentTable"] = dt; DataRow dr1 = null; if (dt.Rows.Count < 6) { for (int s = dt.Rows.Count; s < 6; s++) { dr1 = dt.NewRow(); dt.Rows.Add(dr1); } } Gridview1.DataSource = dt; Gridview1.DataBind(); if (Con.State == ConnectionState.Open) { Con.Close(); } } protected void Button1_Click1(object sender, EventArgs e) { Button1.Visible = false; Response.Write(""); } }