摘要: 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+"' 阅读全文
posted @ 2009-12-08 15:33 java程序代码 阅读(243) 评论(0) 推荐(0) 编辑
摘要: 由于项目的需要,找的一些列子。以备查看。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 阅读全文
posted @ 2009-12-08 15:30 java程序代码 阅读(280) 评论(0) 推荐(0) 编辑
摘要: 首先加入命名空间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(... 阅读全文
posted @ 2009-12-08 15:28 java程序代码 阅读(151) 评论(0) 推荐(0) 编辑