C#数据库操作的三种经典方法
以下是我在 visualstudio2008 上写的一个 C#类(连的是 SQLServer2000) ,已经过测试通过。里面有 3 个方法比较典型,源代码如下:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace DatabaseOperate
{
class SqlOperateInfo
{
//假设你的ServerName 是"aa",DatabaseName 是 "bb",UserName 是 "cc", Password 是 "dd"
private string sqlConnectionCommand = "Data Source=aa;Initial Catalog=bb;User ID=cc;Pwd=dd";
//这张数据表有两个列:KeywordID(int,not null), KeywordName(varchar(100),not null)
private string dataTableName = "Basic_Keyword_Test";
private string storedProcedureName = "Sp_InertToBasic_Keyword_Test";
private string sqlSelectCommand = "Select KeywordID, KeywordName From Basic_Keyword_Test";
//sqlUpdateCommand 可包含 "insert" , "delete" , "update" 等操作
private string sqlUpdateCommand = "Delete From Basic_Keyword_Test Where KeywordID = 1";