insert n save n delete a row

[parag100]

hello
i have a sql table address. name varchar,city varchar,street int

.i want to insert ,delete ,save a record on button controls respectively.in C# and VB.NET .

give code :

corresponding stored procedures.

[klaydze]

hello
i have a sql table address. name varchar,city varchar,street int

.i want to insert ,delete ,save a record on button controls respectively.in C# and VB.NET .

give code :

corresponding stored procedures.

here are some of the lines of code you needed to save,delete insert and save i think is the same.

Dim objConnection As SqlConnection
Dim objDataAdapter As New SqlDataAdapter
Dim objCommand As New SqlCommand

Dim objDataSet As New DataSet
Dim objDataTable As New DataTable

Dim strSelect As String
Dim strInsert As String
Dim i, j As Integer

Try

strSelect = "Select * from "your table" "
strInsert = "Insert Into tbluseraccess (fld1,fld2....) Values('" & txtfld1.Text & "','" & txtfld2.Text & "')"

objConnection = New SqlConnection("Server=localhost; DataBase="YOUR DBASE"; User ID=sa; pwd=")

objDataAdapter.SelectCommand = New SqlCommand(strSelect, objConnection)

objDataAdapter.Fill(objDataSet)

objDataTable = objDataSet.Tables(0)

With objCommand
.Connection = conn
.Connection.Open()
.CommandText = strInsert
.CommandType = CommandType.Text
.ExecuteNonQuery()

.Connection.Close()
End With

ShowGrid()
MsgBox("Record Save")

Catch ex As Exception
MsgBox(ex.ToString)

End Try

that's it. try the delete and update with your own. just base in that code. its also the same.