Protected Sub grvPos_RowCommand(sender As Object, e As GridViewCommandEventArgs) Handles grvPos.RowCommand
If e.CommandName = "Insert" AndAlso Page.IsValid Then
Dim Index As Integer = Convert.ToInt32(e.CommandArgument)
Dim row As GridViewRow = grvPos.Rows(Index)
Dim cs As String
Dim con As iDB2Connection
Dim sql As String
Dim cmd As iDB2Command
Dim valDate = grvPos.DataKeys(Index).Values(1)
Dim portCode As String = grvPos.DataKeys(Index).Values(3).ToString()
Dim secCode As String = grvPos.DataKeys(Index).Values(10).ToString()
Dim valType As TextBox = CType(row.FindControl("txtValType"), TextBox)
Dim portSName As TextBox = CType(row.FindControl("txtPortSName"), TextBox)
Dim portName As TextBox = CType(row.FindControl("txtPortName"), TextBox)
Dim secName As TextBox = CType(row.FindControl("txtSecName"), TextBox)
Dim secCcyAbbr As TextBox = CType(row.FindControl("txtSecCcyAbbr"), TextBox)
Dim portGrpCD As TextBox = CType(row.FindControl("txtPortGrpCD"), TextBox)
Dim portGrpNAme As TextBox = CType(row.FindControl("txtPortGrpName"), TextBox)
Dim prd As TextBox = CType(row.FindControl(""), TextBox)
Dim cent As TextBox = CType(row.FindControl("txtCentre"), TextBox)
Dim centName As TextBox = CType(row.FindControl("txtCentreName"), TextBox)
Dim secCcy As TextBox = CType(row.FindControl("txtSecCcy"), TextBox)
Dim secExRate As TextBox = CType(row.FindControl("txtScBcExRate"), TextBox)
Dim baseCcy As TextBox = CType(row.FindControl("txtBaseCcy"), TextBox)
Dim mValSc As TextBox = CType(row.FindControl("txtMvalAmtSc"), TextBox)
Dim mValBc As TextBox = CType(row.FindControl("txtMvalAmtBc"), TextBox)
cs = ConfigurationManager.ConnectionStrings("ConnectionStringDB2").ConnectionString
con = New iDB2Connection(cs)
sql = "INSERT INTO PFDTA.OPTR_POS3 (" &
"VALN_DATE,VAL_TYPE,PORT_CODE,PORT_SNAME" &
",PORT_NAME,PORT_GROUP_CD,PORT_GROUP_NAME" &
",CENTRE,CENTRE_NAME,SEC_CODE,SEC_SNAME" &
",SEC_CCY,SEC_CCY_ABBR,SC_BC_EX_RATE" &
",BASE_CCY,MVAL_AMT_SC,MVAL_AMT_BC" &
",PRD) VALUES (@VALN_DATE,@VAL_TYPE" &
",@PORT_CODE,@PORT_SNAME,@PORT_NAME" &
",@PORT_GROUP_CD,@PORT_GROUP_NAME" &
",@CENTRE,@CENTRE_NAME,@SEC_CODE" &
",@SEC_SNAME,@SEC_CCY,@SEC_CCY_ABBR" &
",@SC_BC_EX_RATE,@BASE_CCY" &
",@MVAL_AMT_SC,@MVAL_AMT_BC" &
",@PRD)"
cmd = New iDB2Command(sql, con)
cmd.Parameters.AddWithValue("@VALN_DATE", valDate)
cmd.Parameters.AddWithValue("@PORT_CODE", portCode)
cmd.Parameters.AddWithValue("@SEC_CODE", secCode)
cmd.Parameters.AddWithValue("@VAL_TYPE", valType)
cmd.Parameters.AddWithValue("@PORT_SNAME", portSName)
cmd.Parameters.AddWithValue("@PORT_NAME", portName)
cmd.Parameters.AddWithValue("@PORT_GROUP_CD", portGrpCD)
cmd.Parameters.AddWithValue("@PORT_GROUP_NAME", portGrpNAme)
cmd.Parameters.AddWithValue("@CENTRE", cent)
cmd.Parameters.AddWithValue("@CENTRE_NAME", centName)
cmd.Parameters.AddWithValue("@SEC_CCY", secCcy)
cmd.Parameters.AddWithValue("@SC_BC_EX_RATE", secExRate)
cmd.Parameters.AddWithValue("@BASE_CCY", baseCcy)
cmd.Parameters.AddWithValue("@MVAL_AMT_SC", mValSc)
cmd.Parameters.AddWithValue("@MVAL_AMT_BC", mValBc)
cmd.Parameters.AddWithValue("@SEC_SNAME", secName)
cmd.Parameters.AddWithValue("@SEC_CCY_ABBR", secCcyAbbr)
cmd.Parameters.AddWithValue("@PRD", prd)
Try
lblError.Text = ""
Using con
con.Open()
cmd.ExecuteNonQuery()
gridLoad()
End Using
Catch ex As Exception
Throw
End Try
End If
End Sub
I appreciate any help on how to get the insert command insert the values specified in the code.
The is no CommandArgument set on your Gridview, unless you set, it will be string.empty ("").
So Convert.toInt32("") = Input string was not in correct format
By the way, you should set CommandArgument property on all LinkButtons with a value that best fit your needs
Member
28 Points
147 Posts
Need help figuring out the error: Input string was not in a correct format.
Apr 10, 2019 11:20 AM|Matt99|LINK
The error occurs after clicking on the insert command in the footer row.
Error point to:
Dim Index As Integer = Convert.ToInt32(e.CommandArgument)The html page:
<asp:GridView ID="grvPos" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" PageSize="20" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" DataKeyNames="VALN_DATE,PORT_CODE,SEC_CODE" EmptyDataText="No data available" ShowFooter="True"> <AlternatingRowStyle BackColor="Gainsboro" /> <Columns> <asp:TemplateField ShowHeader="False"> <EditItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update" Text="Update"></asp:LinkButton> <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"></asp:LinkButton> </EditItemTemplate> <FooterTemplate> <asp:LinkButton ID="insertBtn" runat="server" CommandName="Insert" ValidationGroup="Insert">Insert</asp:LinkButton> <asp:LinkButton ID="CancelBtn" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"></asp:LinkButton> </FooterTemplate> <FooterStyle Width="100%" Wrap="false" /> <ItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"></asp:LinkButton> <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="VALN_DATE" SortExpression="VALN_DATE"> <EditItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("VALN_DATE") %>'></asp:Label> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label16" runat="server" Text='<%# Bind("VALN_DATE") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Center" /> <FooterTemplate> <asp:TextBox ID="txtValnDate" runat="server" MaxLength="8" ValidationGroup="Insert" Text='<%# Bind("VALN_DATE") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtValnDate" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="VAL_TYPE" SortExpression="VAL_TYPE"> <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server" MaxLength="2" Text='<%# Bind("VAL_TYPE") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Bind("VAL_TYPE") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Center" /> <FooterTemplate> <asp:TextBox ID="txtValType" runat="server" MaxLength="2" ValidationGroup="Insert" Text='<%# Bind("VAL_TYPE") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtValType" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="PORT_CODE" SortExpression="PORT_CODE"> <EditItemTemplate> <asp:Label ID="Label2" runat="server" Text='<%# Eval("PORT_CODE") %>'></asp:Label> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label17" runat="server" Text='<%# Bind("PORT_CODE") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Center" /> <FooterTemplate> <asp:TextBox ID="txtPortCode" runat="server" MaxLength="7" ValidationGroup="Insert" Text='<%# Bind("PORT_CODE") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtPortCode" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="PORT_SNAME" SortExpression="PORT_SNAME"> <EditItemTemplate> <asp:TextBox ID="TextBox2" runat="server" MaxLength="25" Text='<%# Bind("PORT_SNAME") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label2" runat="server" Text='<%# Bind("PORT_SNAME") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtPortSName" runat="server" MaxLength="25" ValidationGroup="Insert" Text='<%# Bind("PORT_SNAME") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="txtPortSName" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="PORT_NAME" SortExpression="PORT_NAME"> <EditItemTemplate> <asp:TextBox ID="TextBox3" runat="server" MaxLength="35" Text='<%# Bind("PORT_NAME") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label3" runat="server" Text='<%# Bind("PORT_NAME") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtPortName" runat="server" MaxLength="35" ValidationGroup="Insert" Text='<%# Bind("PORT_NAME") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtPortName" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="PORT_GROUP_CD" SortExpression="PORT_GROUP_CD"> <EditItemTemplate> <asp:TextBox ID="TextBox4" runat="server" MaxLength="15" Text='<%# Bind("PORT_GROUP_CD") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label4" runat="server" Text='<%# Bind("PORT_GROUP_CD") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtPortGrpCD" runat="server" MaxLength="15" ValidationGroup="Insert" Text='<%# Bind("PORT_GROUP_CD") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="txtPortGrpCD" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="PORT_GROUP_NAME" SortExpression="PORT_GROUP_NAME"> <EditItemTemplate> <asp:TextBox ID="TextBox5" runat="server" MaxLength="30" Text='<%# Bind("PORT_GROUP_NAME") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label5" runat="server" Text='<%# Bind("PORT_GROUP_NAME") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtPortGrpName" runat="server" MaxLength="30" ValidationGroup="Insert" Text='<%# Bind("PORT_GROUP_NAME") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="txtPortGrpName" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="CENTRE" SortExpression="CENTRE"> <EditItemTemplate> <asp:TextBox ID="TextBox6" runat="server" MaxLength="7" Text='<%# Bind("CENTRE") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label6" runat="server" Text='<%# Bind("CENTRE") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtCentre" runat="server" MaxLength="7" ValidationGroup="Insert" Text='<%# Bind("CENTRE") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="txtCentre" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="CENTRE_NAME" SortExpression="CENTRE_NAME"> <EditItemTemplate> <asp:TextBox ID="TextBox7" runat="server" MaxLength="35" Text='<%# Bind("CENTRE_NAME") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label7" runat="server" Text='<%# Bind("CENTRE_NAME") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtCentreName" runat="server" MaxLength="35" ValidationGroup="Insert" Text='<%# Bind("CENTRE_NAME") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="txtCentreName" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="SEC_CODE" SortExpression="SEC_CODE"> <EditItemTemplate> <asp:Label ID="Label3" runat="server" Text='<%# Eval("SEC_CODE") %>'></asp:Label> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label18" runat="server" Text='<%# Bind("SEC_CODE") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtSecCode" runat="server" MaxLength="7" ValidationGroup="Insert" Text='<%# Bind("SEC_CODE") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator10" runat="server" ControlToValidate="txtSecCode" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="SEC_SNAME" SortExpression="SEC_SNAME"> <EditItemTemplate> <asp:TextBox ID="TextBox8" runat="server" MaxLength="35" Text='<%# Bind("SEC_SNAME") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label8" runat="server" Text='<%# Bind("SEC_SNAME") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtSecName" runat="server" MaxLength="35" ValidationGroup="Insert" Text='<%# Bind("SEC_SNAME") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator11" runat="server" ControlToValidate="txtSecName" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="SEC_CCY" SortExpression="SEC_CCY"> <EditItemTemplate> <asp:TextBox ID="TextBox9" runat="server" MaxLength="3" Text='<%# Bind("SEC_CCY") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label9" runat="server" Text='<%# Bind("SEC_CCY") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtSecCcy" runat="server" MaxLength="3" ValidationGroup="Insert" Text='<%# Bind("SEC_CCY") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator12" runat="server" ControlToValidate="txtSecCcy" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="SEC_CCY_ABBR" SortExpression="SEC_CCY_ABBR"> <EditItemTemplate> <asp:TextBox ID="TextBox10" runat="server" MaxLength="73" Text='<%# Bind("SEC_CCY_ABBR") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label10" runat="server" Text='<%# Bind("SEC_CCY_ABBR") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Center" /> <FooterTemplate> <asp:TextBox ID="txtSecCcyAbbr" runat="server" MaxLength="73" ValidationGroup="Insert" Text='<%# Bind("SEC_CCY_ABBR") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator13" runat="server" ControlToValidate="txtSecCcyAbbr" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="BASE_CCY" SortExpression="BASE_CCY"> <EditItemTemplate> <asp:TextBox ID="TextBox11" runat="server" MaxLength="3" Text='<%# Bind("BASE_CCY") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label11" runat="server" Text='<%# Bind("BASE_CCY") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Center" /> <FooterTemplate> <asp:TextBox ID="txtBaseCcy" runat="server" MaxLength="3" ValidationGroup="Insert" Text='<%# Bind("BASE_CCY") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator14" runat="server" ControlToValidate="txtBaseCcy" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="SC_EX_RATE" SortExpression="SC_BC_EX_RATE"> <EditItemTemplate> <asp:TextBox ID="TextBox12" runat="server" MaxLength="13" Text='<%# Bind("SC_BC_EX_RATE") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label12" runat="server" Text='<%# Bind("SC_BC_EX_RATE", "{0:N9}") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" Width="100%" Wrap="False" /> <FooterTemplate> <asp:TextBox ID="txtScBcExRate" runat="server" MaxLength="13" ValidationGroup="Insert" Text='<%# Bind("SC_BC_EX_RATE") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator15" runat="server" ControlToValidate="txtScBcExRate" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="MVAL_AMT_SC" SortExpression="MVAL_AMT_SC"> <EditItemTemplate> <asp:TextBox ID="TextBox13" runat="server" MaxLength="22" Text='<%# Bind("MVAL_AMT_SC") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label13" runat="server" Text='<%# Bind("MVAL_AMT_SC", "{0:N3}") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" Width="100%" Wrap="False" /> <FooterTemplate> <asp:TextBox ID="txtMvalAmtSc" runat="server" MaxLength="22" ValidationGroup="Insert" Text='<%# Bind("MVAL_AMT_SC") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator16" runat="server" ControlToValidate="txtMvalAmtSc" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="MVAL_AMT_BC" SortExpression="MVAL_AMT_BC"> <EditItemTemplate> <asp:TextBox ID="TextBox14" runat="server" MaxLength="22" Text='<%# Bind("MVAL_AMT_BC") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label14" runat="server" Text='<%# Bind("MVAL_AMT_BC", "{0:N3}") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" Width="100%" Wrap="False" /> <FooterTemplate> <asp:TextBox ID="txtMvalAmtBc" runat="server" MaxLength="22" ValidationGroup="Insert" Text='<%# Bind("MVAL_AMT_BC") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator17" runat="server" ControlToValidate="txtMvalAmtBc" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> <asp:TemplateField HeaderText="PRD" SortExpression="PRD"> <EditItemTemplate> <asp:TextBox ID="TextBox15" runat="server" MaxLength="6" Text='<%# Bind("PRD") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label15" runat="server" Text='<%# Bind("PRD") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtPrd" runat="server" MaxLength="6" ValidationGroup="Insert" Text='<%# Bind("PRD") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator18" runat="server" ControlToValidate="txtPrd" Display="Dynamic" ForeColor="Red" ValidationGroup="Insert" ErrorMessage="*"/> </FooterTemplate> <FooterStyle wrap="false"/> </asp:TemplateField> </Columns> <EditRowStyle Wrap="False" /> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <HeaderStyle Wrap="False" BackColor="#000084" Font-Bold="True" ForeColor="White" /> <PagerSettings Mode="NumericFirstLast" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Left" /> <RowStyle Wrap="False" BackColor="#EEEEEE" ForeColor="Black" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#0000A9" /> <SortedDescendingCellStyle BackColor="#CAC9C9" /> <SortedDescendingHeaderStyle BackColor="#000065" /> </asp:GridView>code page:
Protected Sub grvPos_RowCommand(sender As Object, e As GridViewCommandEventArgs) Handles grvPos.RowCommand If e.CommandName = "Insert" AndAlso Page.IsValid Then Dim Index As Integer = Convert.ToInt32(e.CommandArgument) Dim row As GridViewRow = grvPos.Rows(Index) Dim cs As String Dim con As iDB2Connection Dim sql As String Dim cmd As iDB2Command Dim valDate = grvPos.DataKeys(Index).Values(1) Dim portCode As String = grvPos.DataKeys(Index).Values(3).ToString() Dim secCode As String = grvPos.DataKeys(Index).Values(10).ToString() Dim valType As TextBox = CType(row.FindControl("txtValType"), TextBox) Dim portSName As TextBox = CType(row.FindControl("txtPortSName"), TextBox) Dim portName As TextBox = CType(row.FindControl("txtPortName"), TextBox) Dim secName As TextBox = CType(row.FindControl("txtSecName"), TextBox) Dim secCcyAbbr As TextBox = CType(row.FindControl("txtSecCcyAbbr"), TextBox) Dim portGrpCD As TextBox = CType(row.FindControl("txtPortGrpCD"), TextBox) Dim portGrpNAme As TextBox = CType(row.FindControl("txtPortGrpName"), TextBox) Dim prd As TextBox = CType(row.FindControl(""), TextBox) Dim cent As TextBox = CType(row.FindControl("txtCentre"), TextBox) Dim centName As TextBox = CType(row.FindControl("txtCentreName"), TextBox) Dim secCcy As TextBox = CType(row.FindControl("txtSecCcy"), TextBox) Dim secExRate As TextBox = CType(row.FindControl("txtScBcExRate"), TextBox) Dim baseCcy As TextBox = CType(row.FindControl("txtBaseCcy"), TextBox) Dim mValSc As TextBox = CType(row.FindControl("txtMvalAmtSc"), TextBox) Dim mValBc As TextBox = CType(row.FindControl("txtMvalAmtBc"), TextBox) cs = ConfigurationManager.ConnectionStrings("ConnectionStringDB2").ConnectionString con = New iDB2Connection(cs) sql = "INSERT INTO PFDTA.OPTR_POS3 (" & "VALN_DATE,VAL_TYPE,PORT_CODE,PORT_SNAME" & ",PORT_NAME,PORT_GROUP_CD,PORT_GROUP_NAME" & ",CENTRE,CENTRE_NAME,SEC_CODE,SEC_SNAME" & ",SEC_CCY,SEC_CCY_ABBR,SC_BC_EX_RATE" & ",BASE_CCY,MVAL_AMT_SC,MVAL_AMT_BC" & ",PRD) VALUES (@VALN_DATE,@VAL_TYPE" & ",@PORT_CODE,@PORT_SNAME,@PORT_NAME" & ",@PORT_GROUP_CD,@PORT_GROUP_NAME" & ",@CENTRE,@CENTRE_NAME,@SEC_CODE" & ",@SEC_SNAME,@SEC_CCY,@SEC_CCY_ABBR" & ",@SC_BC_EX_RATE,@BASE_CCY" & ",@MVAL_AMT_SC,@MVAL_AMT_BC" & ",@PRD)" cmd = New iDB2Command(sql, con) cmd.Parameters.AddWithValue("@VALN_DATE", valDate) cmd.Parameters.AddWithValue("@PORT_CODE", portCode) cmd.Parameters.AddWithValue("@SEC_CODE", secCode) cmd.Parameters.AddWithValue("@VAL_TYPE", valType) cmd.Parameters.AddWithValue("@PORT_SNAME", portSName) cmd.Parameters.AddWithValue("@PORT_NAME", portName) cmd.Parameters.AddWithValue("@PORT_GROUP_CD", portGrpCD) cmd.Parameters.AddWithValue("@PORT_GROUP_NAME", portGrpNAme) cmd.Parameters.AddWithValue("@CENTRE", cent) cmd.Parameters.AddWithValue("@CENTRE_NAME", centName) cmd.Parameters.AddWithValue("@SEC_CCY", secCcy) cmd.Parameters.AddWithValue("@SC_BC_EX_RATE", secExRate) cmd.Parameters.AddWithValue("@BASE_CCY", baseCcy) cmd.Parameters.AddWithValue("@MVAL_AMT_SC", mValSc) cmd.Parameters.AddWithValue("@MVAL_AMT_BC", mValBc) cmd.Parameters.AddWithValue("@SEC_SNAME", secName) cmd.Parameters.AddWithValue("@SEC_CCY_ABBR", secCcyAbbr) cmd.Parameters.AddWithValue("@PRD", prd) Try lblError.Text = "" Using con con.Open() cmd.ExecuteNonQuery() gridLoad() End Using Catch ex As Exception Throw End Try End If End SubI appreciate any help on how to get the insert command insert the values specified in the code.
Thanks in advance
Participant
1061 Points
666 Posts
Re: Need help figuring out the error: Input string was not in a correct format.
Apr 10, 2019 01:56 PM|jzero|LINK
The is no CommandArgument set on your Gridview, unless you set, it will be string.empty ("").
So Convert.toInt32("") = Input string was not in correct format
By the way, you should set CommandArgument property on all LinkButtons with a value that best fit your needs
Member
28 Points
147 Posts
Re: Need help figuring out the error: Input string was not in a correct format.
Apr 10, 2019 06:03 PM|Matt99|LINK
Solved the problem differently:
cmd.Parameters.AddWithValue("@VALN_DATE", TryCast(grvPos.FooterRow.FindControl("txtValnDate"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@PORT_CODE", TryCast(grvPos.FooterRow.FindControl("txtPortCode"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@SEC_CODE", TryCast(grvPos.FooterRow.FindControl("txtSecCode"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@VAL_TYPE", TryCast(grvPos.FooterRow.FindControl("txtValType"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@PORT_SNAME", TryCast(grvPos.FooterRow.FindControl("txtPortSName"), TextBox).Text()) cmd.Parameters.AddWithValue("@PORT_NAME", TryCast(grvPos.FooterRow.FindControl("txtPortName"), TextBox).Text()) cmd.Parameters.AddWithValue("@PORT_GROUP_CD", TryCast(grvPos.FooterRow.FindControl("txtPortGrpCD"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@PORT_GROUP_NAME", TryCast(grvPos.FooterRow.FindControl("txtPortGrpName"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@CENTRE", TryCast(grvPos.FooterRow.FindControl("txtCentre"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@CENTRE_NAME", TryCast(grvPos.FooterRow.FindControl("txtCentreName"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@SEC_CCY", TryCast(grvPos.FooterRow.FindControl("txtSecCcy"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@SC_BC_EX_RATE", TryCast(grvPos.FooterRow.FindControl("txtScBcExRate"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@BASE_CCY", TryCast(grvPos.FooterRow.FindControl("txtBaseCcy"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@MVAL_AMT_SC", TryCast(grvPos.FooterRow.FindControl("txtMvalAmtSc"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@MVAL_AMT_BC", TryCast(grvPos.FooterRow.FindControl("txtMvalAmtBc"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@SEC_SNAME", TryCast(grvPos.FooterRow.FindControl("txtSecName"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@SEC_CCY_ABBR", TryCast(grvPos.FooterRow.FindControl("txtSecCcyAbbr"), TextBox).Text.Trim()) cmd.Parameters.AddWithValue("@PRD", TryCast(grvPos.FooterRow.FindControl("txtPrd"), TextBox).Text.Trim())