I Want to Show QR Code In Place Of LOT Column i.e Lot1,Lot2,Lot3 etc,Which is Coming from Stored Prosedure.
My Code Aspx Page----
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterIQMS.master" EnableEventValidation="false" AutoEventWireup="true" CodeFile="SamplePrepration.aspx.cs" Inherits="Reports_SamplePrepration" %> <%@ Register Src="~/Web Controls/CustomPager.ascx" TagName="PagingControl" TagPrefix="uc1" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <div class="row"> <div class="col-sm-4"> Work Order No <asp:TextBox ID="txtWorkOrderNo" runat="server" OnTextChanged="txtWorkOrderNo_TextChanged" AutoPostBack="true"></asp:TextBox> <asp:HiddenField ID="HiddenField1" runat="server" /> <cc1:AutoCompleteExtender ServiceMethod="SearchWO" MinimumPrefixLength="1" EnableCaching="false" CompletionSetCount="10" TargetControlID="txtWorkOrderNo" ID="AutoCompleteExtender1" runat="server" FirstRowSelected="false" CompletionListCssClass="completionList" CompletionListItemCssClass="listItem" CompletionListHighlightedItemCssClass="itemHighlighted"> </cc1:AutoCompleteExtender> </div> <div class="col-sm-1"> <asp:LinkButton ID="btnInspectionCodeTagging" runat="server" Width="150" class="btn btn-info btn-xs btn-block" OnClick="btnInspectionCodeTagging_Click"><i class="fa-floppy-o"></i> Job Code Tagging</asp:LinkButton> </div> </div> <asp:Panel ID="pnlContents" runat="server"> <div style="overflow: scroll;" onscroll="OnScrollDiv(this)" id="DivMainContent"> <asp:GridView ID="grdSamplePrep" runat="server" CssClass="table-grid" OnRowDataBound="grdSamplePrep_RowDataBound" OnSelectedIndexChanged="grdSamplePrep_SelectedIndexChanged1"> </asp:GridView> </div> </asp:Panel> <div class="row"> <div class="col-sm-8"> <asp:HiddenField ID="hidPageNo" runat="server" Value="1" /> <uc1:PagingControl ID="gvPager" Visible="false" FirstString="<< First" LastString=" Last >>" NextString="Next >" PrevString="< Prev" TotalNumberPaging="10" OnPaging_Click="gvPager_Paging_Click" runat="server" /> </div> </div> </asp:Content>
Cs Page
using QRCoder; using System; using System.Collections.Generic; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.IO; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Reports_SamplePrepration : System.Web.UI.Page { SqlConnection con; int PageNum = 1; String strConn = ConfigurationManager.ConnectionStrings["ConOrms"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // ShowData(1); } } protected void grdSamplePrep_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { } } protected void ShowData(int PageNum) { int TotalRecord = 0; DataTable dt = new DataTable(); int WOID = Convert.ToInt32(ViewState["WoidForBindData"]); DataSet dsSmplPrep = new DataSet(); //WR_TRF.GetTRFReport(BranchID, FromDate, ToDate, Convert.ToInt16(SessionManager.Instance.RoleId),txtTRFno.Text.Trim()); DataTable dtSmplPrep = new DataTable(); try { using (SqlConnection con = new SqlConnection(strConn)) { using (SqlCommand cmd = new SqlCommand("VVS_SAMPLE_PREPARARION", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@WOID", SqlDbType.Int).Value = WOID; //cmd.Parameters.Add("@PageSize", SqlDbType.Int).Value = 10; cmd.CommandTimeout = 999999; SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(dtSmplPrep); } } } catch (Exception ex) { } /// DataTable distinctParameter = new DataTable(); // DataView viewSampleLlst = new DataView(dtSmplPrep); if (dtSmplPrep.Rows.Count > 0) { // distinctParameter = viewSampleLlst.ToTable(true, "TotalCount"); // TotalRecord = Convert.ToInt16(distinctParameter.Rows[0]["TotalCount"]); dtSmplPrep.Columns.Remove("WOID"); dtSmplPrep.Columns.Remove("TestingParamId"); grdSamplePrep.DataSource = dtSmplPrep; grdSamplePrep.DataBind(); //gvPager.Visible = (dtSmplPrep.DefaultView.Count > 0); //gvPager.PageSize = 10; //gvPager.TotalRecord = TotalRecord; //gvPager.CurrentPage = PageNum; //hidPageNo.Value = PageNum.ToString(); //gvPager.DataLoad(); //ScriptManager.RegisterStartupScript(Page, this.GetType(), "Key", "<script>MakeStaticHeader('" + grdQrCodeResult.ClientID + "', 300, 750 , 41 ,true); </script>", false); } else { //gvPager.Visible = false; grdSamplePrep.DataSource = null; grdSamplePrep.DataBind(); } } protected void gvPager_Paging_Click(object sender, CommandEventArgs e) { } #region AutoComplete Work order No [System.Web.Script.Services.ScriptMethod()] [System.Web.Services.WebMethod] public static List<string> SearchWO(string prefixText, int count) { List<string> customers = new List<string>(); string Item = string.Empty; try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConOrms"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetWoIdBySearchText"; cmd.Parameters.Add("@SearchText", SqlDbType.NVarChar).Value = prefixText; cmd.Connection = con; con.Open(); using (SqlDataReader sdr = cmd.ExecuteReader()) { while (sdr.Read()) { Item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(sdr["JobOrderNo"].ToString(), sdr["WOID"].ToString()); customers.Add(Item); } } con.Close(); } } } catch (Exception ex) { } return customers; } #endregion protected void txtWorkOrderNo_TextChanged(object sender, EventArgs e) { int Woid = 0; //string WONO= txtTextingWO.Text; //GetEditWorkOrder(GetWorkOrderID(WONO)); if (txtWorkOrderNo.Text != string.Empty) { try { string[] FindValue = txtWorkOrderNo.Text.Trim().Split(';'); if (FindValue.Length > 1) { Woid = Convert.ToInt32(FindValue[1].ToString()); ViewState["WoidForBindData"] = Woid; } txtWorkOrderNo.Text = FindValue[0].ToString(); } catch (Exception ex) { } } } protected void btnInspectionCodeTagging_Click(object sender, EventArgs e) { ShowData(1); } protected void grdSamplePrep_SelectedIndexChanged1(object sender, EventArgs e) { } }
My Screen