sql+c#.docVIP

sql+c# c#连接SQL数据库2007-11-30 16:06using System; using System.Collections.Generic; using System.Text; using Model; using System.Data; using System.Data.SqlClient; 1.返回一个结果集 public static DataSet GetDataSet2(string sql) { DataSet ds = new DataSet(); string strConn = server=.;uid=sa;pwd=;database=ShopManegerDB; SqlConnection conn = new SqlConnection(strConn); SqlDataAdapter da = new SqlDataAdapter(sql, conn); da.Fill(ds, Shop); return ds; } 2.返回一个影响的行数 public static int update(string sql) { string strConn = server=.;uid=sa;pwd=;database=ShopManegerDB; SqlConnection conn = new SqlConnection(strConn); SqlCommand cmd = new SqlCommand(sql,conn); conn.Open(); int i = cmd.ExecuteNonQuery(); conn.Close(); return i; } 3.其他 Sql Server · ODBC o 标准连接（Standard Security）: Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd; 1）当服务器为本地时Server可以使用(local); Driver={SQL Server};Server=(local);Database=pubs;Uid=sa;Pwd=asdasd; 2）当连接远程服务器时，需指定地址、端口号和网络库 Driver={SQL Server};Server=01;Address=01,1052;Network=dbmssocn;Database=pubs;Uid=sa;Pwd=asdasd; 注：Address参数必须为IP地址，而且必须包括端口号 o 信任连接（Trusted connection）: （Microsoft Windows NT 集成了安全性） Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes; 或者 Driver={SQL Server};Server=Aron1;Database=pubs; Uid=;Pwd=; o 连接时弹出输入用户名和口令对话框: Conn.Properties(Prompt) = adPromptAlways Conn.Open Driver={SQL Server};Server=Aron1;DataBase=pubs; · OLE DB, OleDbConnection (.NET) o 标准连接（Standard Security）: Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd; o 信任连接（Trusted connection）: Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI; (如果连接一个具体的已命名SQLServer实例,使用Data Source=Servere Name\Instance Name;但仅适用于 SQLServer2000)例如：”Provider=sqloledb;Data Sour