hi guys
My code is working fine on button click.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim constr As String = ConfigurationManager.ConnectionStrings("oapConnectionString").ConnectionString
Using con As New SqlConnection(constr)
Using cmd As New SqlCommand("Update [OAP].[dbo].[Beneficiary_max_limit] set [District_Code]=@District_Code,[Block_Code]= @Block_Code ,[District_max_value]= @District_max_value,[scheme_type]=@scheme_type ,[scheme_subtype]=@scheme_subtype where [Block_Code]= @Block_Code and [scheme_type]=@scheme_type ")
cmd.CommandType = CommandType.Text
cmd.Connection = con
con.Open()
cmd.Parameters.AddWithValue("@District_Code", DropDownList1 ...
Go to the complete details ...