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 are the assembly entry points?
What are option strict and option explicit?
Explain about the performance of visual basic?
Explain enumerator?
List the different types of assembly?
What is the size of .net object?
What do you mean by option strict on?
Name the tool which can convert visual basic old version to .net compatibility version?
Can you please explain the difference between system.string and system.stringbuilder classes?
Explain the use of option explicit?
What are the types of generations in garbage collector?
Using VB, how can you change the Mouse Pointer?
What is writeline in vb.net?
Described strong typing
What are all the differences between dispose and finalize()?