java07

摘要： var conn,sql; var conn=server.createobject("ADODB.connection"); con.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=testweb"); sql = "insert into test(activeid,userid,chrtel) ("+activeid+","+userid+",'"+mobile+"' 阅读全文

摘要： 由于项目的需要，找的一些列子。以备查看。using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;using System.Data.SqlClient;namespace datad 阅读全文

摘要： 首先加入命名空间using System.Data.SqlClient;1.查询 SqlConnection conn = new SqlConnection(); conn = new SqlConnection(); conn.ConnectionString = "Data Source=(local);Initial Catalog=数据库名;UserID=sa;Password=123456"; conn.Open(); string strsql=“select语句"; SqlCommand cmd = new SqlCommand(... 阅读全文