Hi all,
i have some problem storing values into database from gridview data.
In my case i have one gridview and html button. whenever i click on button the gridview records are stored in database but the way of storing records are not properly
saved. in my example, below is code, i want to store this values properly based on gridview data.
in my gridview i have below rows(26). i want to store these rows as it is in database
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
default.ascx:
<asp:GridView ID="GvGrid1" runat="server" AutoGenerateColumns="false" CellPadding="4" Width="400px" ForeColor="#333333">
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="UtSubGrp_Nm" ItemStyle-HorizontalAlign="left" HeaderText="Sub Group Name" ReadOnly="True" HeaderStyle-HorizontalAlign="Left" />
<asp:CommandField ShowDeleteButton="true" />
</Columns>
</asp:GridView>
<table>
<tr>
<td>
<input type="button" id="SubGrpNmSave" value="SAVE" class="Btns" onclick="FetchSubGrpNmSave();" />
</td>
</tr>
</table>
<script language="jscript" type="text/javascript">
function FetchSubGrpNmSave(sender, e) {
var GvGrid = document.getElementById("<%= GvGrid1.ClientID%>");
if (GvGrid == null) {
alert("Add Grid value");
return;
}
for (i = 1; i < GvGrid.rows.length; i++) {
var GridNm = GvGrid.rows[i].cells[0].innerText;
PageMethods.SaveGridNm(GridNm);
}
return true;
}
</script>
<table>
<tr>
<td>
<input type="button" id="SubGrpNmSave" value="SAVE" class="Btns" onclick="FetchSubGrpNmSave();" />
</td>
</tr>
</table>
<script language="jscript" type="text/javascript">
function FetchSubGrpNmSave(sender, e) {
var GvGrid = document.getElementById("<%= GvGrid1.ClientID%>");
if (GvGrid == null) {
alert("Add Grid value");
return;
}
for (i = 1; i < GvGrid.rows.length; i++) {
var GridNm = GvGrid.rows[i].cells[0].innerText;
PageMethods.SaveGridNm(GridNm);
}
return true;
}
</script>
default.ascx.cs:
public static decimal? SaveGridNm(string GridNm)
{
DL.default s = new DL.default();
return s.SaveGridNm(GridNm);
}
default.aspx.cs:
[WebMethod]
public static decimal? SaveGridNm(GridNm)
{
return pjy.Web.UI.ASCX.newfolder.default.SaveGridNm(GridNm);
}
default.cs:
public decimal? SaveGridNm(GridNm)
{
using (DataContext dc = new DataContext())
{
//dc.USP_INSERT_DEFAULT_VALUE(GridNm);
return 1;
}
}
If anybody understand my problem, please solve my issue..
