Hi,
I use this code for update:
Dim cmd1 As New SqlCommand("firekeyup1", con)
cmd1.CommandType = CommandType.StoredProcedure
cmd1.Parameters.Add(New SqlParameter("@fire", Request.QueryString("fire")))
cmd1.Parameters.Add(New SqlParameter("@key1", TextBox2.Text.Replace(Environment.NewLine, "<br/>")))
con.Open()
cmd1.ExecuteNonQuery()
con.Close()
this is work, but when i use this code for read data in page load:
Try
Dim cmd5 As New SqlCommand("firekeyse1", con)
cmd5.CommandType = CommandType.StoredProcedure
cmd5.Parameters.Add(New SqlParameter("@fire", Request.QueryString("fire")))
con.Open()
Dim dr5 As SqlDataReader
dr5 = cmd5.ExecuteReader()
dr5.Read()
TextBox2.Text = d ...
Go to the complete details ...