Delete, insert, update

Question

Hii

I am new to VB.NET. I have created a database and a form Which has 5 fields. I am using This code to insert data into data base.

Sub insert()
        Dim strCon As String = "Data Source=win-8mmefl12klc\

sqlexpress;Initial Catalog=Dataconnect;Integrated Security=True"
        Dim con As New SqlClient.SqlConnection
        Dim strCommand As String = "Insert into User1_t (name, address, phone, nationality, hsecry, puc, degree, post_graduation) values ('" & Me.TextBox1.Text & "','" & Me.TextBox2.Text & "','" & Me.TextBox3.Text & "','" & Me.TextBox4.Text & "','" & Me.TextBox5.Text & "','" & Me.TextBox6.Text & "','" & Me.TextBox7.Text & "','" & Me.TextBox8.Text & "')"
        Try

            con.ConnectionString = strCon

            Dim cm As New SqlClient.SqlCommand(strCommand, con)

            con.Open()

            cm.ExecuteNonQuery()

            MsgBox("Succesfully saved…")

        Catch ex As Exception

            MessageBox.Show(ex.Message, "Error")
            'MessageBox.Show(ex.InnerException, "Error")

        Finally

            If con.State = ConnectionState.Open Then

                con.Close()

            End If

        End Try

    End Sub

Would any one suggest me how to delete record and update.

This is urgent as my project work is going on.........

Regard
Mithil

Answer 1

HI Bhaskar,

 

Please refer this below URL for your reference,

 

http://www.c-sharpcorner.com/UploadFile/6b8651/read-excel-file-in-windows-application-using-C-Sharp/

 

Answer 2

Hi Baskar,

 

Can you share your screnn shot of error message 

Answer 3

I am talking about the example on that URL , there it gives an exception on giving the name of sheet as the name of sheet becomes too long., so any solution for that

 

i.e OleDbDataAdapter oleAdpt = new OleDbDataAdapter("select * from [Sheet1$]", con);  

Answer 4

Hi Baskar,

 

xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item("Mention your sheet name")

//mention your excel sheet name

<span style="font-family: Roboto, sans-serif;"> </span>

Answer 5

I have to upload a  specific sheet from a woorkbook how can i do that.