Hi Guys,
I am making a message module in asp.net with database of sql. i have made a gridview and enabled selecting. and a form view is synchorised with grid view on selecting. i am writing update sql but could not get a way to take data on Gridview or Formview to compare the record in sql database.
this is my page viewImports System.Data
Imports System.Data.SqlClient
Partial Class homepage
Inherits System.Web.UI.Page
Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged
FormView1.PageIndex = GridView1.SelectedIndex
Label1.Text = FormView1.FooterText.
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Session("login") = False Then
Response.Redirect("Login.aspx")
End If
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim db As New SqlConnection
db.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Message_Dat.mdf;Integrated Security=True;User Instance=True"
db.Open()
Dim sql As String = "update into tblMessage (msg_status) values('junk') where msg_Id='" & FormView1.text & &q
View Complete Post