 |
|
ผมติดปัญหาคือ เมือ่กดเพิ่มแล้วมัน Error ครับ
ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
ใช้ Sql server 2005 EXPRESS ครับ
Code (VB.NET)
Imports System.Data
Imports System.Data.SqlClient
Partial Class AddTest
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Protected Sub btnOK_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnOK.Click
Dim strConn As String
Dim myConn As System.Data.SqlClient.SqlConnection
strConn = "Server=localhost;Initial Catalog=com;Persist Security Info=True;User ID=sa;Password=0000"
myConn = New System.Data.SqlClient.SqlConnection(strConn)
Dim strcomm As New SqlCommand("INSERT INTO TBTest ( [ID], UserName, Password, FName, LName, Email, Address, TelMobie ,Tel)VALUES ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "',);", myConn)
strcomm.ExecuteNonQuery()
TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
TextBox4.Text = ""
TextBox5.Text = ""
TextBox6.Text = ""
TextBox7.Text = ""
TextBox8.Text = ""
End Sub
End Class
Tag : .NET, Ms SQL Server 2005, VB.NET, VS 2005 (.NET 2.x)
|
|
|
 |
 |
 |
 |
| Date :
2010-10-27 16:01:53 |
By :
Neptune29 |
View :
1291 |
Reply :
6 |
|
 |
 |
 |
 |
|
|
|
|
 |
