protected void BindOrderDetails() { dt = cls.ReturnDataTable("Select_InvoiceWiseOrderDetailsFromID", new SqlParameter("@InvoiceId", invoiceid), new SqlParameter("@InvoiceDispatchID", invoicedispatchid)); rptOrder.DataSource = dt; rptOrder.DataBind(); if (dt.Rows.Count > 0) { drpStatus.SelectedValue = dt.Rows[0]["OrderStatus"].ToString(); orderno = dt.Rows[0]["OrderId"].ToString(); lblInvoiceNo.Text = dt.Rows[0]["InvoiceNumber"].ToString(); txtDate.Text = cls.FormatDate_US_Ind(dt.Rows[0]["InvoiceDate"].ToString()); txtTrackingNo.Text = dt.Rows[0]["TrackingNumber"].ToString(); txtOtherDetails.Text = dt.Rows[0]["OtherDetails"].ToString(); drpCourier.SelectedValue = dt.Rows[0]["URL"].ToString(); invno = dt.Rows[0]["InvoiceNo"].ToString(); lblInvoiceNoMail.Text = "TSM_Invoice_" + orderno + "-" + invno; } }