Click here to Skip to main content
15,443,281 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Am using viewstate to store the row of values from grid but this is very problematic while insertin the values into the database . Please suggest another solution for the same.
Posted
Updated 9-Feb-14 23:14pm
v2
Comments
What is the exact problem with ViewState?
Ni!E$H_WAGH 10-Feb-14 7:44am    
Viewstate not storing the last row of values from the gridview .
Show your code. It should store. You must be doing something wrong.
Ni!E$H_WAGH 10-Feb-14 7:50am     CRLF
This is the code for Save button Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnSave.Click 'Please do not double click this button to view code. 'If you double click it will generate Handles event due to which the 'values will be inserted twice into the database Try 'SetRowData() Dim table As DataTable = TryCast(ViewState("CurrentTable"), DataTable) If table IsNot Nothing Then For Each row As DataRow In table.Rows Dim funob As String = TryCast(row.ItemArray(1), String) Dim measur As String = TryCast(row.ItemArray(2), String) Dim d_line As String = TryCast(row.ItemArray(3), String) Dim wtfact As String = TryCast(row.ItemArray(4), String) 'If funob IsNot Nothing OrElse measur IsNot Nothing OrElse d_line IsNot Nothing OrElse wtfact IsNot Nothing Then If funob IsNot Nothing Or measur IsNot Nothing Or d_line IsNot Nothing Or wtfact IsNot Nothing Then Dim cmd As New SqlCommand Dim obj As New GenericCode Dim str As String Dim con As New SqlConnection Dim empcode As String = Session("emp_code") con.ConnectionString = strConnString con.Open() str = " insert into MBO_Details(MBO_EMP_Code,MBO_FUNC_OBJ,MBO_MEASURED_VAR,MBO_DEADLINE,MBO_WEIGHT_FACT) values ('" & empcode & "','" str = str & funob & "','" & measur & "','" & d_line & "','" & wtfact & "')" cmd.CommandText = str cmd = New SqlCommand(str, con) cmd.ExecuteNonQuery() con.Close() End If Next lblusrmsg.Visible = True btnSave.Enabled = False ButtonAdd.Enabled = False End If Catch ex As Exception Throw New Exception(ex.Message) End Try End Sub

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900