注册 登录
编程论坛 ASP.NET技术论坛

怎样连接数据库

秋意 发布于 2016-08-25 13:25, 3861 次点击
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include virtual="/Connections/ljsjk.asp" -->
<%
Dim MM_editAction
MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
  MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

' boolean to abort record edit
Dim MM_abortEdit
MM_abortEdit = false
%>
<%
If (CStr(Request("MM_insert")) = "form1") Then
  If (Not MM_abortEdit) Then
    ' execute the insert
    Dim MM_editCmd

    Set MM_editCmd = Server.CreateObject (")
    MM_editCmd.ActiveConnection = MM_ljsjk_STRING
    MM_ = "INSERT INTO [user] ([username], mima, dizi, zname, tel) VALUES (?, ?, ?, ?, ?)"
    MM_editCmd.Prepared = true
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 201, 1, 10, Request.Form("hname")) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 201, 1, 10, Request.Form("pass1")) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 201, 1, 100, Request.Form("add")) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 201, 1, 20, Request.Form("zname")) ' adLongVarChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 201, 1, 20, Request.Form("tel")) ' adLongVarChar
    MM_editCmd.Execute请问错在哪里
2 回复
#2
stave_72016-08-25 14:10
VB的看不懂
#3
qq124143332016-12-08 15:53
vs...

string ConnectionString = "Integrated Security=True;Data Source=.;Initial Catalog=...;";
      
   SqlConnection conn = new SqlConnection(ConnectionString);
      
    conn.Open();
        
            int count = 0;
            
         string sql = string.Format("select count (*) from 学生 where 学号 ='{0}' and 登录密码 ='{1}'", Username, Userpass);
            
         SqlCommand cmd = new SqlCommand(sql, conn);
           
         count = (int)cmd.ExecuteScalar();
1