I have solved.
Gridview bind using jQuery:
function OnSuccess(response) {
var xmlDoc = $.parseXML(response.d);
var xml = $(xmlDoc);
var customers = xml.find("Table");
var row = $("[id*=gvCustomers] tr:last-child").clone(true);
$("[id*=gvCustomers] tr").not($("[id*=gvCustomers] tr:first-child")).remove();
$.each(customers, function () {
var customer = $(this);
//$("td", row).eq(0).html($(this).find("TDC_NO").text());
$("td", row).eq(0).find("a").text($(this).find("TDC_NO").text());
$("td", row).eq(0).find("a").attr("href","Uncoated_Wire.aspx?Id=" + $(this).find("TDC_NO").text()).attr('target','_blank');
$("td", row).eq(1).html($(this).find("REVISION").text());
$("td", row).eq(2).html($(this).find("REVISION_DATE").text());
$("td", row).eq(3).html($(this).find("P_GROUP").text());
$("[id*=gvCustomers]").append(row);
row = $("[id*=gvCustomers] tr:last-child").clone(true);
});
}
In Uncoated_Wire.aspx replace default dynamic table with label
<asp:Label id="lblStdSize_Toler" runat="server" Text=""></asp:Label>
<form id="form1" runat="server">
<div>
<b style="margin-left: 550px; font-size: xx-large">market Division</b><br />
<table style="margin-left: 1000px; width: 15%">
<tr>
<td style="font-size: large">
<b>Product_ID</b>
</td>
<td>
<label id='Revision_Date'>
</label>
</td>
</tr>
<tr>
<td style="font-size: large">
<b>TDC No.</b>
</td>
<td>
<label runat="server" id='Tdc_No'>
</label>
</td>
</tr>
<tr>
<td style="font-size: large">
<b>Revision</b>
</td>
<td>
<label id='Revision' for='0'>
0</label>
</td>
</tr>
</table>
<table style="width: 90%; margin-left: 70px;">
<tr style="font-size: large; background-color: yellow;">
<td colspan="2">
<b>Wire Dimensions</b>
</td>
</tr>
<tr>
<td style="font-size: large">
<b>Standard Sizes & Tolerances</b>
</td>
<td>
<asp:Label id="lblStdSize_Toler" runat="server" Text=""></asp:Label>
</td>
</tr>
</table>
</form>
in Uncoated_Wire.aspx.cs store querystring on page load pass it on query. and bind the tables
protected void Page_Load(object sender, EventArgs e)
{
string connectionString = ConfigurationManager.ConnectionStrings["conndbprodnew"].ConnectionString;
StdSize_Toler();
}
void StdSize_Toler()
{
string TDC_NO_VAL = Request.QueryString["Id"];
string connStr = ConfigurationManager.ConnectionStrings["conndbprodnew"].ToString();
OracleConnection objconn = new OracleConnection(connStr);
string prop_name, tdc_property = "", qry = "";
lblStdSize_Toler.Text = "<table ><thead><tr><th>Size Range Min(mm)</th><th>Size Range Max (mm)</th><th>Tolerance min</th><th>Tolerance, max</th></tr></thead>";
try
{
qry = "Select pdid,tdc_property,revision from tdc_product1 p inner join Prop_detail pd on p.TDC_NO =pd.TDC_NO Where p.TDC_NO=:TDC_NO";
OracleCommand objFetchCmd = new OracleCommand(qry, objconn);
objconn.Open();
OracleDataReader ReadData = objFetchCmd.ExecuteReader();
lblStdSize_Toler.Text = lblStdSize_Toler.Text+ "<tr>";
while (ReadData.Read())
{
prop_name = ReadData["prop_name"].ToString();
tdc_property = ReadData["tdc_property"].ToString();
Revision_Date.InnerText = ReadData["pdid"].ToString();
Tdc_No.InnerText = ReadData["tdc_NO"].ToString();
Revision.InnerText = ReadData["revision"].ToString();
if (prop_name== "sizMin")
{
lblStdSize_Toler.Text = lblStdSize_Toler.Text+ "<td>" + tdc_property + "</td>";
}
if (prop_name == "sizeMax")
{
lblStdSize_Toler.Text = lblStdSize_Toler.Text + "<td>" + tdc_property + "</td>";
}
if (prop_name == "tolMin")
{
lblStdSize_Toler.Text = lblStdSize_Toler.Text + "<td>" + tdc_property + "</td>";
}
if (prop_name == "tolMax")
{
lblStdSize_Toler.Text = lblStdSize_Toler.Text + "<td>" + tdc_property + "</td></tr>";
}
lblStdSize_Toler.Text += "</table>";
ReadData.Dispose();
objFetchCmd.Dispose();
objconn.Close();
}
catch
{
objconn.Close();
}
}
two table are there first table tdc_product1 columns pdid,tdc_property,revision
second table where dynamic data are storing
table PROP_DETAIL
columns:CODE_VALUE ,TDC_NO ,ROWNO,PROP_NAME,TDC_PROPERTY
