The @first, @second are references to the text boxes we take the data from to insert
Imports System.Data
Imports System.Data.SqlClient
Partial Class Testaspnet
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim DBConn As New SqlConnection("Data Source=RACHID\MYRACHID1;Initial Catalog=TELE;Integrated Security=True")
Dim DBCmd As New SqlCommand
Dim DBAdap As New SqlDataAdapter
Dim DS As New DataSet
DBConn.Open()
Try
'Add Insert Statement
DBCmd = New SqlCommand("INSERT INTO TELETAB1 (name,age) VALUES (@first, @second)", DBConn)
'Add Database Parameters
DBCmd.Parameters.Add("@first", SqlDbType.NVarChar).Value = txt1.Text
DBCmd.Parameters.Add("@second", SqlDbType.NChar).Value = txt2.Text
DBCmd.ExecuteNonQuery()
Response.Write("Your Record is Updated ")
'Set the value of DataAdapter
DBAdap = New SqlDataAdapter("SELECT * FROM TELETAB1", DBConn)
'Fill the DataSet
DBAdap.Fill(DS)
'Bind with GridView control and Display the Record
GridView1.DataSource = DS
GridView1.DataBind()
Catch exp As Exception
Response.Write(exp)
End Try
DBCmd.Dispose()
DBAdap.Dispose()
DBConn.Close()
DBConn = Nothing
End Sub
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
End Sub
End Class
No comments:
Post a Comment