How to Insert a TextBox value in to Sql database using
VB.Net coding?
Answer Posted / dinesh
Imports System.Configuration
Imports System.Data.SqlClient
Public Class Form1
Dim objcon As SqlConnection
Dim objcmd As SqlCommand
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
objcon.Open()
objcmd = New SqlClient.SqlCommand("insert into customer_master(First_Name,Last_Name,Address,contact_number,email_id)values('" & TextBox1.Text.Trim & "','"& TextBox2.Text.Trim &"','"& TextBox3.Text.Trim &"','" & TextBox5.Text.Trim & "','" & TextBox7.Text.Trim & "')", objcon)
Dim i As Integer = objcmd.ExecuteNonQuery()
If (i > 0) Then
MsgBox("Customer saved successfully!")
Else
MsgBox("Failed to save Customer!")
End If
objcon.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
Can you please explain the difference between thread and process?
What is sealed class?
What is a static class?
Allowed program to auto-correct the database when loading a presentation.
What is stack used for in vb. Net?
Explain about globalization?
what is commom language runtime?
What is meant by jagged arrays?
Explain the difference between vb.net and c#, related to oops concepts?
How vb implements the disconnected architecture as like vb.net?
How to send xml file on server using http protocol?
what is difference between web.config and machine.config and where it will be ?
What is the Advantage of vb.net over vb
What are the differences between vb.net and c#, related to oops concepts
What is difference between import system.data.sqlclient,system.data.oledb?