asp.net 1.1 sql server 2000怎么实现

来源:百度知道 编辑:UC知道 时间:2024/06/17 15:01:16
此软件服务器运行环境:asp.net 1.1 sql server 2000,也就是说必须安装在“asp.net 1.1 sql server 2000”服务器上才能使用。

Public Function insertupdel(ByVal strUser As String, ByVal strPassword As String) As Boolean
Dim isFlag As Boolean = False
Dim StrNewSql As String = "Select txtuserid From users Where txtuserid='" & strUser & "'"
Dim strIntSql As String = "insert into users(txtuserid,txtpassword)Values('" & strUser & "','" & strPassword & "') "
Dim com As New SqlCommand
com.CommandText = StrNewSql
conn.ConnectionString = strConn
com.Connection = conn

SQL2000,好古老啊

Imports System.Data.SqlClient
Public Class sqldb
Dim conn As New SqlConnection
Private strConn As String
Public Function checkconnection(ByVal str As String) As Boolean
Dim isFlag As Boolean = False
If conn.State = ConnectionState.Closed Then
conn.ConnectionString = str
conn.