有没简单的C#对数据库SQL server 2000表实现查询,插入,更新,删除的例子啊? 越简单越好,我刚学C#难了怕看不懂. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 using System;using System.Windows.Forms;using System.Data;using System.Data.SqlClient;using System.IO;using System.Text;using System.Xml;using System.Collections;namespace Com.Richinfo.Framework.Utils{ class SysBaseUtils { private static SqlConnection con; private static SqlCommand cmd; private static DataSet ds; private static SqlDataAdapter da; #region 获取数据库连接对象 /// <summary> /// 获取数据库连接对象 /// </summary> /// <returns>SqlConnection</returns> public static SqlConnection GetDBConnection() { string ConnStr = GetDBConnectionString(); try { con = new SqlConnection(ConnStr); return con; } catch //(Exception ex) { //System.Console.Out.Write(ex.Message); ShowError("连接数据库失败。"); return null; } } #endregion #region 获取连接字符串 /// <summary> /// 获取连接字符串 /// </summary> /// <returns>string</returns> public static string GetDBConnectionString() { string text = Application.StartupPath + "\\config"; try { if (!Directory.Exists(text)) { Directory.CreateDirectory(text); } XmlTextReader xtr = new XmlTextReader(text + "\\data.xml"); while (xtr.Read()) { if (xtr.Name == "STRING") { xtr.Read(); return xtr.Value; } } xtr.Close(); return null; } catch //(Exception ex) { //System.Console.Out.Write(ex.Message); ShowError("获取不到数据库连接。"); return null; } } #endregion #region 查询操作,并且返回记录集 /// <summary> /// 查询操作,并且返回记录集 /// </summary> /// <param name="StrSQL">查询SQL语句</param> /// <param name="obj"></param> /// <returns>DataSet</returns> public static DataSet ExecuteQuery(string StrSQL, Hashtable obj) { GetDBConnection(); try { con.Open(); cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = StrSQL; cmd.Connection = con; if (obj != null) { IDictionaryEnumerator numerator = obj.GetEnumerator(); while (numerator.MoveNext()) { cmd.Parameters.AddWithValue(numerator.Entry.Key.ToString(), numerator.Entry.Value); } } ds = new DataSet(); da = new SqlDataAdapter(cmd); da.Fill(ds); for (int i = 0; i < cmd.Parameters.Count; i++) { cmd.Parameters.Remove(cmd.Parameters[i]); } cmd.Dispose(); con.Close(); con.Dispose(); return ds; } finally { cmd.Dispose(); con.Close(); con.Dispose(); } } #endregion #region 查询操作,并且返回记录集 /// <summary> /// 查询操作,并且返回记录集 /// </summary> /// <param name="StrSQL">查询SQL语句</param> /// <param name="obj"></param> /// <returns>DataSet</returns> public static DataSet ExecuteQuery(string StrSQL) { GetDBConnection(); try { con.Open(); cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = StrSQL; cmd.Connection = con; ds = new DataSet(); da = new SqlDataAdapter(cmd); da.Fill(ds); for (int i = 0; i < cmd.Parameters.Count; i++) { cmd.Parameters.Remove(cmd.Parameters[i]); } cmd.Dispose(); con.Close(); con.Dispose(); return ds; } finally { cmd.Dispose(); con.Close(); con.Dispose(); } } #endregion #region 获取DataReader /// <summary> /// 获取DataReader /// </summary> /// <param name="strSQL">SQL语句</param> /// <param name="obj"></param> /// <returns>SqlDataReader</returns> public static SqlDataReader GetReaderCloseDb(string strSQL, Hashtable obj) { GetDBConnection(); try { con.Open(); cmd.CommandType = CommandType.Text; cmd.CommandText = strSQL; cmd.Connection = con; if (obj != null) { IDictionaryEnumerator numerator = obj.GetEnumerator(); while (numerator.MoveNext()) { cmd.Parameters.AddWithValue(numerator.Entry.Key.ToString(), numerator.Entry.Value); } } SqlDataReader dr = cmd.ExecuteReader(); for (int i = 0; i < cmd.Parameters.Count; i++) { cmd.Parameters.Remove(cmd.Parameters[i]); } return dr; } catch { MessageBox.Show("数据库连接错误!"); return null; } } #endregion #region 数据增、删、改操作,成功返回1,失败返回0 /// <summary> /// 数据增、删、改操作,成功返回1,失败返回0 /// </summary> /// <param name="StrSQL">增、删、改SQL语句</param> /// <param name="obj"></param> /// <returns>int</returns> public static int ExecuteUpdate(string StrSQL, Hashtable obj) { GetDBConnection(); try { con.Open(); cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = StrSQL; cmd.Connection = con; if (obj != null) { IDictionaryEnumerator numerator = obj.GetEnumerator(); while (numerator.MoveNext()) { cmd.Parameters.AddWithValue(numerator.Entry.Key.ToString(), numerator.Entry.Value); } } return cmd.ExecuteNonQuery(); } finally { cmd.Dispose(); con.Close(); con.Dispose(); } } #endregion #region 数据增、删、改操作,成功返回1,失败返回0 /// <summary> /// 数据增、删、改操作,成功返回1,失败返回0 /// </summary> /// <param name="StrSQL">增、删、改SQL语句</param> /// <param name="obj"></param> /// <returns>int</returns> public static int ExecuteUpdate(string StrSQL) { GetDBConnection(); try { con.Open(); cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = StrSQL; cmd.Connection = con; return cmd.ExecuteNonQuery(); } finally //(Exception ex) { cmd.Dispose(); con.Close(); con.Dispose(); } } #endregion using System;using System.IO;using System.Data.OleDb;namespace ConsoleCommandDemo{ /// <summary> /// Class1 的摘要说明。 /// </summary> class CommandClass { /// <summary> /// 应用程序的主入口点。 /// </summary> [STAThread] static void Main(string[] args) { string strCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataBase.mdb;"; // 定义连接 OleDbConnection MyCon = new OleDbConnection(strCon); try { MyCon.Open(); string strSQL = @"INSERT INTO ADODemo (姓名, 年龄) VALUES ('赵六', 25)"; OleDbCommand MyCom = new OleDbCommand(strSQL, MyCon); // 执行没有返回结果的指令 Console.WriteLine("执行的命令:{0}", MyCom.CommandText); Console.WriteLine("执行结果影响了:{0}个记录", MyCom.ExecuteNonQuery()); // 删除一条记录 strSQL = @"delete from ADODemo where (姓名 = '赵六')"; MyCom.CommandText = strSQL; Console.WriteLine("执行的命令:{0}", MyCom.CommandText); Console.WriteLine("执行结果影响了:{0}个记录", MyCom.ExecuteNonQuery()); // 使用参数插入一条记录 MyCom.CommandText = "INSERT INTO ADODemo (姓名, 年龄) VALUES (?, ?)"; MyCom.Parameters.Add("@姓名", OleDbType.VarChar, 20); MyCom.Parameters.Add("@年龄", OleDbType.TinyInt); MyCom.Parameters["@姓名"].Value = "赵六"; MyCom.Parameters["@年龄"].Value = 23; Console.WriteLine("执行的命令:{0}", MyCom.CommandText); Console.WriteLine("执行结果影响了:{0}个记录", MyCom.ExecuteNonQuery()); // 删除一条记录 strSQL = @"delete from ADODemo where (姓名 = '赵六')"; MyCom.CommandText = strSQL; Console.WriteLine("执行的命令:{0}", MyCom.CommandText); Console.WriteLine("执行结果影响了:{0}个记录", MyCom.ExecuteNonQuery()); // 浏览数据 strSQL = @"select * from ADODemo"; MyCom.CommandText = strSQL; OleDbDataReader MyDataReader = MyCom.ExecuteReader(); // 显示数据库中的数据 Console.WriteLine("显示数据库中的数据"); while(MyDataReader.Read()) { Console.WriteLine("姓名:{0} 年龄:{1}", MyDataReader.GetValue(0), MyDataReader.GetValue(2)); } MyDataReader.Close(); } catch (Exception ex) { Console.WriteLine("{0}", ex.ToString()); } finally { MyCon.Close(); } Console.ReadLine(); } }} 数据库修复技术和数据库技术网站登录 http://www.feike.com.cn http://www.itpub.net China best online store ,Goodwholesaleshop.com offers lots of product,China Wholesale and Wholesale iPad accessories from China,best choice for you. 怎么回贴没有显示UBB? 一段让我很费解的循环,求高手解决 如何用List<string>获取数据库内容? 咱们论坛有没有研究过 CLR调试器的高手? 了解ICorDebug的朋友来帮忙看看,想做一个仿VS IDE的代码调试器 excel表格处理 datetime 读文本问题?100分求个方法。 WEB调用水晶报表本地做好移植到服务器上时出问题 C#下如何做饼图,曲线和柱图 中文版和英文版的win2k哪个用着爽啊?有理的都给分 请熟悉VS2005 C#的帮忙看看是什么问题 如何在一个DataGridView中的一列添加DateTimePicker控件
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Text;
using System.Xml;
using System.Collections;namespace Com.Richinfo.Framework.Utils
{
class SysBaseUtils
{
private static SqlConnection con;
private static SqlCommand cmd;
private static DataSet ds;
private static SqlDataAdapter da;
#region 获取数据库连接对象
/// <summary>
/// 获取数据库连接对象
/// </summary>
/// <returns>SqlConnection</returns>
public static SqlConnection GetDBConnection()
{
string ConnStr = GetDBConnectionString();
try
{
con = new SqlConnection(ConnStr);
return con;
}
catch //(Exception ex)
{
//System.Console.Out.Write(ex.Message);
ShowError("连接数据库失败。");
return null;
}
} #endregion #region 获取连接字符串
/// <summary>
/// 获取连接字符串
/// </summary>
/// <returns>string</returns>
public static string GetDBConnectionString()
{
string text = Application.StartupPath + "\\config";
try
{
if (!Directory.Exists(text))
{
Directory.CreateDirectory(text);
}
XmlTextReader xtr = new XmlTextReader(text + "\\data.xml");
while (xtr.Read())
{
if (xtr.Name == "STRING")
{
xtr.Read();
return xtr.Value;
} }
xtr.Close();
return null;
}
catch //(Exception ex)
{
//System.Console.Out.Write(ex.Message);
ShowError("获取不到数据库连接。");
return null;
}
} #endregion #region 查询操作,并且返回记录集
/// <summary>
/// 查询操作,并且返回记录集
/// </summary>
/// <param name="StrSQL">查询SQL语句</param>
/// <param name="obj"></param>
/// <returns>DataSet</returns>
public static DataSet ExecuteQuery(string StrSQL, Hashtable obj)
{
GetDBConnection();
try
{
con.Open();
cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = StrSQL;
cmd.Connection = con;
if (obj != null)
{
IDictionaryEnumerator numerator = obj.GetEnumerator();
while (numerator.MoveNext())
{
cmd.Parameters.AddWithValue(numerator.Entry.Key.ToString(), numerator.Entry.Value);
}
}
ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
for (int i = 0; i < cmd.Parameters.Count; i++)
{
cmd.Parameters.Remove(cmd.Parameters[i]);
}
cmd.Dispose();
con.Close();
con.Dispose();
return ds;
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
} } #endregion #region 查询操作,并且返回记录集
/// <summary>
/// 查询操作,并且返回记录集
/// </summary>
/// <param name="StrSQL">查询SQL语句</param>
/// <param name="obj"></param>
/// <returns>DataSet</returns>
public static DataSet ExecuteQuery(string StrSQL)
{
GetDBConnection();
try
{
con.Open();
cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = StrSQL;
cmd.Connection = con; ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
for (int i = 0; i < cmd.Parameters.Count; i++)
{
cmd.Parameters.Remove(cmd.Parameters[i]);
}
cmd.Dispose();
con.Close();
con.Dispose();
return ds;
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
} } #endregion #region 获取DataReader
/// <summary>
/// 获取DataReader
/// </summary>
/// <param name="strSQL">SQL语句</param>
/// <param name="obj"></param>
/// <returns>SqlDataReader</returns>
public static SqlDataReader GetReaderCloseDb(string strSQL, Hashtable obj)
{
GetDBConnection();
try
{
con.Open();
cmd.CommandType = CommandType.Text;
cmd.CommandText = strSQL;
cmd.Connection = con; if (obj != null)
{
IDictionaryEnumerator numerator = obj.GetEnumerator();
while (numerator.MoveNext())
{
cmd.Parameters.AddWithValue(numerator.Entry.Key.ToString(), numerator.Entry.Value);
}
}
SqlDataReader dr = cmd.ExecuteReader();
for (int i = 0; i < cmd.Parameters.Count; i++)
{
cmd.Parameters.Remove(cmd.Parameters[i]);
}
return dr;
}
catch
{
MessageBox.Show("数据库连接错误!");
return null;
} } #endregion #region 数据增、删、改操作,成功返回1,失败返回0
/// <summary>
/// 数据增、删、改操作,成功返回1,失败返回0
/// </summary>
/// <param name="StrSQL">增、删、改SQL语句</param>
/// <param name="obj"></param>
/// <returns>int</returns>
public static int ExecuteUpdate(string StrSQL, Hashtable obj)
{
GetDBConnection();
try
{
con.Open();
cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = StrSQL;
cmd.Connection = con;
if (obj != null)
{
IDictionaryEnumerator numerator = obj.GetEnumerator();
while (numerator.MoveNext())
{
cmd.Parameters.AddWithValue(numerator.Entry.Key.ToString(), numerator.Entry.Value);
}
}
return cmd.ExecuteNonQuery();
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
}
} #endregion #region 数据增、删、改操作,成功返回1,失败返回0
/// <summary>
/// 数据增、删、改操作,成功返回1,失败返回0
/// </summary>
/// <param name="StrSQL">增、删、改SQL语句</param>
/// <param name="obj"></param>
/// <returns>int</returns>
public static int ExecuteUpdate(string StrSQL)
{
GetDBConnection();
try
{
con.Open();
cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = StrSQL;
cmd.Connection = con; return cmd.ExecuteNonQuery();
}
finally //(Exception ex)
{
cmd.Dispose();
con.Close();
con.Dispose();
}
} #endregion
using System.IO;
using System.Data.OleDb;namespace ConsoleCommandDemo
{
/// <summary>
/// Class1 的摘要说明。
/// </summary>
class CommandClass
{
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main(string[] args)
{
string strCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataBase.mdb;";
// 定义连接
OleDbConnection MyCon = new OleDbConnection(strCon);
try
{
MyCon.Open();
string strSQL = @"INSERT INTO ADODemo (姓名, 年龄) VALUES ('赵六', 25)"; OleDbCommand MyCom = new OleDbCommand(strSQL, MyCon);
// 执行没有返回结果的指令
Console.WriteLine("执行的命令:{0}", MyCom.CommandText);
Console.WriteLine("执行结果影响了:{0}个记录", MyCom.ExecuteNonQuery()); // 删除一条记录
strSQL = @"delete from ADODemo where (姓名 = '赵六')";
MyCom.CommandText = strSQL;
Console.WriteLine("执行的命令:{0}", MyCom.CommandText);
Console.WriteLine("执行结果影响了:{0}个记录", MyCom.ExecuteNonQuery());
// 使用参数插入一条记录
MyCom.CommandText = "INSERT INTO ADODemo (姓名, 年龄) VALUES (?, ?)";
MyCom.Parameters.Add("@姓名", OleDbType.VarChar, 20);
MyCom.Parameters.Add("@年龄", OleDbType.TinyInt); MyCom.Parameters["@姓名"].Value = "赵六";
MyCom.Parameters["@年龄"].Value = 23;
Console.WriteLine("执行的命令:{0}", MyCom.CommandText);
Console.WriteLine("执行结果影响了:{0}个记录", MyCom.ExecuteNonQuery()); // 删除一条记录
strSQL = @"delete from ADODemo where (姓名 = '赵六')";
MyCom.CommandText = strSQL;
Console.WriteLine("执行的命令:{0}", MyCom.CommandText);
Console.WriteLine("执行结果影响了:{0}个记录", MyCom.ExecuteNonQuery());
// 浏览数据
strSQL = @"select * from ADODemo";
MyCom.CommandText = strSQL;
OleDbDataReader MyDataReader = MyCom.ExecuteReader();
// 显示数据库中的数据
Console.WriteLine("显示数据库中的数据");
while(MyDataReader.Read())
{
Console.WriteLine("姓名:{0} 年龄:{1}", MyDataReader.GetValue(0), MyDataReader.GetValue(2));
}
MyDataReader.Close();
}
catch (Exception ex)
{
Console.WriteLine("{0}", ex.ToString());
}
finally
{
MyCon.Close();
}
Console.ReadLine();
}
}
}