c# - How to make each button respond to that row only -
i have repeater creates table multiple row same field name:
<asp:repeater runat="server" id="rptcontent"> <headertemplate> <table border="0" style="width: 95%;"> <tr> <td style="width: 25%;">name</td> <td style="width: 25%;">last 4 ssn #</td> <td style="width: 25%;">pdf generator</td> </tr> </headertemplate> <itemtemplate> <tr> <td><%# eval("name").tostring() %></td> <td><%# eval("ssn3").tostring() %></td> <td><asp:button id="btngeneratepdf" runat="server" text="generate pdf for" onclick="btngeneratepdf_click" /></td> </tr> </itemtemplate> <footertemplate> </table> </footertemplate> </asp:repeater>
my code behind looks this:
public void writedata() { conn = new sqlconnection(cstring); conn.open(); namee = txtname.text; var pdfpath = path.combine(server.mappath("~/pdftemplates/9.pdf")); // form fields pdf , fill them in! var formfieldmap = pdfhelper.getformfieldnames(pdfpath); formfieldmap["topmostsubform[0].page1[0].f1_01_0_[0]"] = txtname.text; sqlcode = "select * [db].[dbo].[tablepdftest] [name] = '" + namee + "'"; using (sqlcommand command = new sqlcommand(sqlcode, conn)) { command.commandtype = commandtype.text; using (reader = command.executereader()) { if (reader.hasrows) { if (reader.read()) { formfieldmap["topmostsubform[0].page1[0].f1_02_0_[0]"] = reader.getvalue(1).tostring(); formfieldmap["topmostsubform[0].page1[0].f1_04_0_[0]"] = reader.getvalue(2).tostring(); formfieldmap["topmostsubform[0].page1[0].f1_05_0_[0]"] = reader.getvalue(3).tostring(); formfieldmap["topmostsubform[0].page1[0].f1_07_0_[0]"] = reader.getvalue(4).tostring(); formfieldmap["topmostsubform[0].page1[0].social[0].textfield1[0]"] = reader.getvalue(5).tostring(); formfieldmap["topmostsubform[0].page1[0].social[0].textfield2[0]"] = reader.getvalue(6).tostring(); formfieldmap["topmostsubform[0].page1[0].social[0].textfield2[1]"] = reader.getvalue(7).tostring(); formfieldmap["topmostsubform[0].page1[0].social[0].textfield2[2]"] = reader.getvalue(8).tostring(); formfieldmap["topmostsubform[0].page1[0].social[0].textfield2[3]"] = reader.getvalue(9).tostring(); } } } } // requester's name , address (hard-coded) formfieldmap["topmostsubform[0].page1[0].f1_06_0_[0]"] = "medical group\n2700 wr ave\npurchase, ny 10232"; var pdfcontents = pdfhelper.generatepdf(pdfpath, formfieldmap); pdfhelper.returnpdf(pdfcontents, "compl.pdf"); }
how can make if there more 1 entries each button query [name]
last 4 ssn different?
first, nod using parameters...
anyway, lot of ways this, 1 add commandargument value button (and evaluate in code behind).
<asp:button id="btngeneratepdf" runat="server" text="generate pdf for" commandargument = '<%# eval("l4_ssn") %>' onclick="btngeneratepdf_click" />
then you'd need make sure had field in select statement such right(ssn,4) l4_ssn
and finally, you'd modify btngeneratepdf_click
sub evaluate e.commandargument
...
Comments
Post a Comment