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" %>
Work Order No
Job Code Tagging
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", "", 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 SearchWO(string prefixText, int count)
{
List customers = new List();
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

Sandeep KumarPosted Jan 5, 2023, 1:21 PM
Can anyone help me?
Sandeep KumarPosted Jan 4, 2023, 9:55 AM
pls anyone help me