ASP.Net/ADO.net Database/Insert SqlConnection
Insert data to Sql server through SqlConnection
<source lang="csharp">
<%@ Page Language=VB Debug=true %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SQLClient" %> <script runat=server> Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim DBConn as SQLConnection Dim DBAdd As New SQLCommand
" DBConn = New SQLConnection("server=localhost;" _
" & "Initial Catalog=TT;" _ " & "User Id=sa;" _ " & "Password=yourpassword;") DBConn = New SQLConnection("Data Source=whsql-v08.prod.mesa1.secureserver.net;Initial Catalog=DB_49907;User ID=nfexuser;Password="password";") DBAdd.rumandText = "Insert Into Employee (" _ & "LastName, FirstName, Salary " _ & ") values ("" & txtLastName.Text & ""," _ & """ & txtFirstName.Text _ & ""," & txtSalary.Text & ")" DBAdd.Connection = DBConn DBAdd.Connection.Open DBAdd.ExecuteNonQuery()
End Sub
</SCRIPT>
<HTML>
<HEAD>
<TITLE>Adding SQL Server Data</TITLE>
</HEAD>
<Body LEFTMARGIN="40">
<form runat="server">
Last Name:
<asp:textbox id="txtLastName" runat="Server"/>
First Name:
<asp:textbox id="txtFirstName" runat="Server"/>
Salary:
<asp:textbox id="txtSalary" runat="Server"/>
<asp:button id="butOK" text="OK" onclick="SubmitBtn_Click" runat="server"/>
</form>
</BODY>
</HTML>
</source>