C Sharp数据库简单操作.docVIP

c#快速开发数据库简单操作 一、已有 数据库（SQL）表，快速生成对应 存储过程的工具。 SQLPilot.exe 二、已有数据库表，快速生成列表、基本查询、高级查询、插入新行、删除、编辑 ASP.net页面的工具ASP.NET Maker。 可参看网址：/aspnetmaker/ 数据库操作类，以下是C#代码： 源代码文件如下： using System;using System.Web.UI;using System.Globalization;using System.Data;using System.Data.SqlClient;namespace ns_db{public class c_db: UserControl{ //********************************//? 返回 数据库连接字符串//******************************** public string ewConnStr(){return Password=******;Persist Security Info=True; User ID=sa;Initial Catalog=******;Data Source= (Local);} // End ewConnStr //******************************************************//? 返回一个 DataView 根据 Connection String SQL//****************************************************** public DataView ewDataView(string sConn, string sSQL){try{ // Create a new Connection ObjectSqlConnection oConn = new SqlConnection(sConn); // Create a new DataAdapter using the Connection Object and SQL statementSqlDataAdapter oDa = new SqlDataAdapter(sSQL, oConn); // Create a new DataSet Object to fill with DataDataSet oDs = new DataSet(); // Fill the DataSet with Data from the DataAdapter ObjectoDa.Fill(oDs, ewDataSet);return oDs.Tables[0].DefaultView;}catch (SqlException oErr){Session[dberrmsg] = ewDataErrorMessage(oErr);return null;}} // End ewDataView //*********************************//? 返回一个 DataView for Linking//********************************* public DataView ewDataViewLink(string sConn, string sTable/*表名*/,string sLnkFld, string sDispFld,string sDispFld2, string sFilterFld,string sOrderBy/*排序列*/, string sOrderType/*排序规则*/,bool bDistinct/*是否剔除重复值*/, string sFilter){string sSQL;try{ // Construct SQL statementsSQL = SELECT;if (bDistinct){sSQL += DISTINCT;}sSQL += [ + sLnkFld + ], [ + sDispFld + ];if (sDispFld2 != ){sSQL += , [ + sDispFld2 + ];}if (sFilterFld != ){sSQL += , [ + sFilterFld + ];}sSQL += FROM [ + sTable + ];if (sFilter != ){sSQL += WHERE + sFilter;}if (sOrderBy != ){sSQL