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
What is the feature anonymous type?
Described strong typing
What are the parts of the visual basic control?
What are the assembly entry points?
When do you use virutal keyword?
What are the difference between structure and class?
Can you please explain the difference between vb and vb.net?
What is the advantages of VB.NET?
Define serialization in .net?
Explain code security?
What is globalization?
What is the significance of delegates?
source code for how to login a vb.net application ?
How to connect crystal report in vb.net ?
what's ArrayList in .Net (VB.Net or C#).What's the advantageous using ArrayList.