求一个.net C#连接数据库例子

;server=RSPSQLSRV;Trusted_Connection=false;database=RSPTraining;connection timeout=0"; //string connStr = "Server=localhost;Database=survey;User ID=sa;Password=19841207"; public ArchiveReport() { this.conn = new SqlConnection(connStr); } public DataTable GetArchiveReport(string name) { DataSet ds = new DataSet(); this.conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = this.conn; cmd.CommandText = "select * from ArchiveReport where clientID=@ClientID order by formID desc"; cmd.Parameters.Add("@ClientID" conn); result = cmd.ExecuteNonQuery(); } catch (Exception ex) { this._Message = ex.Message; } finally { conn.Close(); } return result; } /// <summary> /// 查询结果 /// count等结果 /// </summary> /// <param name="sql"></param> /// <returns></returns> public int ExecuteScalar(string sql) { try { conn = new SqlConnection(connectionstring); conn.Open(); cmd = new SqlCommand(sql conn); dt = new DataTable(); da.Fill(dt); } catch (Exception ex) { this._Message = ex.Message; } finally { conn.Close(); } return dt; } /// <summary> /// insert、update、delete操作 /// </summary> /// <param name="sql"></param> /// <returns></returns> public int ExecuteNonQuery(string sql) { try { conn = new SqlConnection(connectionstring); conn.Open(); cmd = new SqlCommand(sql 我写一个完整的WinForm增删改查程序给你．邮箱 283345903@qq.com ||| 一般连接数据库和数据库的增 删 改 查是分开来的 这里写不清楚如果需要就加我Q说吧 ||| using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using System.Configuration;namespace DBManager{ /// <summary> /// 数据库基本操作类 /// </summary> public class BaseBusiness { private string connectionstring; private string _Message; private SqlConnection conn; private SqlCommand cmd; private SqlDataAdapter da; private DataTable dt; private int result; /// <summary> /// 数据库信息 一般都是分层写的 不过的确像楼上说的 read.GetString(1)); } read.Close(); con.Close(); } read.GetInt32(0) CategoryName FROM Categories"; con.Open(); SqlDataReader read = catCMD.ExecuteReader(); while(read.Read()) { Console.WriteLine("/t{0}/t{1}" 没有区别的 把数据库样例(.MdF　.Ldf)　格式传给我 ＳＱＬ数据库表你自己设计一张表 如果你想要可以联系我 这样贴上去不是很直观 包括错误信息 /// </summary> public string Message { get { return this._Message; } } public BaseBusiness() { connectionstring = ConfigurationSettings.AppSettings["connstring"]; } /// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable ExecuteReader(string sql) { try { conn = new SqlConnection(connectionstring); conn.Open(); da = new SqlDataAdapter(sql 呵呵 代码不可能全部拷过来Q:104468473 ||| SqlConnection con = new SqlConnection("DataSource=localhost;Integrated Security=SSPI;Initial Catalog=northwind"); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT CategoryID 也得自己动动脑子吧. ||| 不管是windows应用程序还是Web应用程序都是使用的ado.net 即使做作业 你再看不懂神也没办法了. 如果你想学编程的话 SqlDbType.Int); cmd.ExecuteNonQuery(); this.conn.Close(); }} 答案补充 使用DataTable和SqlCommand对象之前需要添加 using System.Data.SqlClient; 和using System.Data;的引用.update和insert 与delete的代码相同. 只是sql语句不同. 答案补充 代码写成这样了 SqlDbType.VarChar); cmd.Parameters["@ClientID"].Value = name; SqlDataAdapter sqlDA = new SqlDataAdapter(cmd); sqlDA.Fill(ds); this.conn.Close(); return ds.Tables[0]; } public void deleteRecord(int formID) { this.conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = this.conn; cmd.CommandText = "delete from ArchiveReport where formID=@formID "; cmd.Parameters.Add("@formID" conn); result = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { this._Message = ex.Message; } finally { conn.Close(); } return result; } }} ||| public class ArchiveReport{ private SqlConnection conn; string connStr = "user id=clientportal;password=cp2008*