Here in my code, I am inserting bound field data, can anyone send me code samplefor how to insert Template field data.(TextBox)
Public Sub InsertData()
For Each item As GridDataItem In GD_Prod.Items
Dim str0 As String = item("port_recipe_num").Text
Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("FConnectionString").ConnectionString)
Dim cmd As New SqlCommand("P_FN_PR_InsertGridData", con)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@PL_Recipe_Number", SqlDbType.Char).Value = str0
con.Open()
cmd.ExecuteNonQuery()
con.Close()
Next
End Sub
Thanks In Advance.
Public Sub InsertData()
For Each item As GridDataItem In GD_Prod.Items
Dim str0 As String = item("port_recipe_num").Text
Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("FConnectionString").ConnectionString)
Dim cmd As New SqlCommand("P_FN_PR_InsertGridData", con)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@PL_Recipe_Number", SqlDbType.Char).Value = str0
con.Open()
cmd.ExecuteNonQuery()
con.Close()
Next
End Sub
Thanks In Advance.