在asp.net中怎么写类啊,给点经验之谈,好不好? 是新建一个类的工程,在工程中写是吧?如果谁能给我一个向导,或者有一个实例,那真是感激不尽啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 初学者的简单类,见笑using System;using System.Data;using System.Data.OleDb;using System.Text;using System.Web;namespace Database{ /// <summary> /// OleDbDatabase 的摘要说明。 /// </summary> public class OleDbDatabase { public OleDbDatabase() { // // TODO: 在此处添加构造函数逻辑 // } private string ConnString; #region 数据库连接字符串 public string strConn { set { ConnString = value; } get { return ConnString; } } #endregion #region 执行SQL命令,参数为SQL语句。返回DataSet(正常)或null(错误) public DataSet GetDataSet(string strSelectSQL) { try { OleDbConnection Conn = new OleDbConnection(ConnString); OleDbCommand SelCommand = new OleDbCommand(strSelectSQL,Conn); OleDbDataAdapter objDataAdapter = new OleDbDataAdapter(); DataSet SelDataSet = new DataSet(); objDataAdapter.SelectCommand = SelCommand; objDataAdapter.Fill(SelDataSet); return SelDataSet; } catch(Exception e) { HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite); HttpContext.Current.Response.Write("<br><font size='2'>请检查GetDataSet调用参数!</font>"); return null; } } #endregion #region 执行SQL命令,参数为SQL语句。返回执行成功(true)与失败(false) public bool CommandSQL ( string strCommandSQL) { try { OleDbConnection Conn = new OleDbConnection(ConnString); OleDbCommand SQLCommand = new OleDbCommand(strCommandSQL,Conn); Conn.Open(); SQLCommand.ExecuteNonQuery(); Conn.Close(); return true; } catch(Exception e) { HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite); HttpContext.Current.Response.Write("<br><font size='2'>请检查CommandSQL调用参数!</font>"); return false; } } #endregion #region 执行SQL插入操作,参数值为域值二维数组、表名,返回插入成功(true)与失败(false) public bool CommandSQL (string[,] strColumn,string TableName) { try { StringBuilder InsertSQL = new StringBuilder("insert into " + TableName + " ("); StringBuilder Column = new StringBuilder(); StringBuilder Value = new StringBuilder(); for (int i=0;i<strColumn.GetLength(0);i++) { if (i!= strColumn.GetLength(0)-1) { Column.Append ( strColumn[i,0] + ","); Value.Append("'"+ strColumn[i,1] + "',"); } else { Column.Append(strColumn[i,0]); Value.Append("'" + strColumn[i,1] + "'"); } } InsertSQL.Append( Column.ToString() + ")" + " values (" + Value.ToString() + ") "); OleDbConnection Conn = new OleDbConnection(ConnString); OleDbCommand SQLCommand = new OleDbCommand(InsertSQL.ToString(),Conn); Conn.Open(); SQLCommand.ExecuteNonQuery(); Conn.Close(); return true; } catch(Exception e) { HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite); HttpContext.Current.Response.Write("<br><font size='2'>请检查CommandSQL调用参数!</font>"); return false; } } #endregion #region 执行SQL字段唯一性检查,参数为表名、列名、检查值。返回存在(true)与不存在(false) public bool GetExsitValue ( string vTable,string vColumn,string Value) { try { string strSQL = "select " + vColumn +" from " + vTable + " where " + vColumn + "='" + Value +"'"; OleDbConnection Conn = new OleDbConnection(ConnString); OleDbCommand SQLCommand = new OleDbCommand(strSQL,Conn); OleDbDataReader objRead; Conn.Open(); objRead = SQLCommand.ExecuteReader(); bool Result = objRead.HasRows; Conn.Close(); if (Result) { return true; } else { return false; } } catch(Exception e) { HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite); HttpContext.Current.Response.Write("<br><font size='2'>请检查GetExsitValue调用参数!</font>"); HttpContext.Current.Response.End(); return false; } } #endregion #region 执行SQL字段唯一性检查,参数为表名、列名1、检查值1、列2、检查值2。返回存在(true)与不存在(false) public bool GetExsitValue ( string vTable,string vColumn1,string Value1,string vColumn2,string Value2) { try { string strSQL = "select " + vColumn1 +"," + vColumn2 +" from " + vTable + " where " + vColumn1 + "='" + Value1 +"' and "+ vColumn2 + "='" + Value2 + "'" ; OleDbConnection Conn = new OleDbConnection(ConnString); OleDbCommand SQLCommand = new OleDbCommand(strSQL,Conn); OleDbDataReader objRead; Conn.Open(); objRead = SQLCommand.ExecuteReader(); bool Result = objRead.HasRows; Conn.Close(); if (Result) { return true; } else { return false; } } catch(Exception e) { HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite); HttpContext.Current.Response.Write("<br><font size='2'>请检查GetExsitValue调用参数!</font>"); HttpContext.Current.Response.End(); return false; } } #endregion }} 右击项目-添加类using System;namespace asp.net_xml{ /// <summary> /// Class1 的摘要说明。 /// </summary> public class Class1 { public Class1() { // // TODO: 在此处添加构造函数逻辑 // } }} 右键项目->添加类其实就是一个class,手工写也行 在asp.net中写的都是类。除了及少数如style.css...。只是你用没用到类的好处罢了比如继承.重载。我不是高手,你去问那些星星们他们肯定会给你好的答案哦 如何限制一个用户名同时在多台计算机上登陆. ※ WebNoteEditor在线编辑器 新增“服务器文件浏览管理”功能,欢迎大家测试一下。 当鼠标划过gridview的行时,该行的字体变色,请帮忙! 水晶报表的问题 求助:弹出页面传值的问题!!! 网站标题字母与汉字的长度不一呀!(救我!) Session为何不能保值 日期比较的问题! 超级着急的问题!2003和2002都如此的报错! SqlConnection 问题!!! asp.net需要的windows操作系统环境是什么 关于货币类型的模糊查询!!···!!!!!!!!!!!!!!!
using System;
using System.Data;
using System.Data.OleDb;
using System.Text;
using System.Web;namespace Database
{
/// <summary>
/// OleDbDatabase 的摘要说明。
/// </summary>
public class OleDbDatabase
{
public OleDbDatabase()
{
//
// TODO: 在此处添加构造函数逻辑
//
} private string ConnString;
#region 数据库连接字符串
public string strConn
{
set
{
ConnString = value;
}
get
{
return ConnString;
}
}
#endregion #region 执行SQL命令,参数为SQL语句。返回DataSet(正常)或null(错误)
public DataSet GetDataSet(string strSelectSQL)
{
try
{
OleDbConnection Conn = new OleDbConnection(ConnString);
OleDbCommand SelCommand = new OleDbCommand(strSelectSQL,Conn);
OleDbDataAdapter objDataAdapter = new OleDbDataAdapter();
DataSet SelDataSet = new DataSet(); objDataAdapter.SelectCommand = SelCommand;
objDataAdapter.Fill(SelDataSet); return SelDataSet;
}
catch(Exception e)
{
HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite);
HttpContext.Current.Response.Write("<br><font size='2'>请检查GetDataSet调用参数!</font>");
return null;
}
}
#endregion #region 执行SQL命令,参数为SQL语句。返回执行成功(true)与失败(false)
public bool CommandSQL ( string strCommandSQL)
{
try
{
OleDbConnection Conn = new OleDbConnection(ConnString);
OleDbCommand SQLCommand = new OleDbCommand(strCommandSQL,Conn);
Conn.Open(); SQLCommand.ExecuteNonQuery(); Conn.Close();
return true;
}
catch(Exception e)
{
HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite);
HttpContext.Current.Response.Write("<br><font size='2'>请检查CommandSQL调用参数!</font>");
return false;
}
}
#endregion #region 执行SQL插入操作,参数值为域值二维数组、表名,返回插入成功(true)与失败(false)
public bool CommandSQL (string[,] strColumn,string TableName)
{
try
{
StringBuilder InsertSQL = new StringBuilder("insert into " + TableName + " (");
StringBuilder Column = new StringBuilder();
StringBuilder Value = new StringBuilder();
for (int i=0;i<strColumn.GetLength(0);i++)
{
if (i!= strColumn.GetLength(0)-1)
{
Column.Append ( strColumn[i,0] + ",");
Value.Append("'"+ strColumn[i,1] + "',");
}
else
{
Column.Append(strColumn[i,0]);
Value.Append("'" + strColumn[i,1] + "'");
}
} InsertSQL.Append( Column.ToString() + ")" + " values (" + Value.ToString() + ") ");
OleDbConnection Conn = new OleDbConnection(ConnString);
OleDbCommand SQLCommand = new OleDbCommand(InsertSQL.ToString(),Conn);
Conn.Open(); SQLCommand.ExecuteNonQuery(); Conn.Close(); return true;
}
catch(Exception e)
{
HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite);
HttpContext.Current.Response.Write("<br><font size='2'>请检查CommandSQL调用参数!</font>");
return false;
} }
#endregion #region 执行SQL字段唯一性检查,参数为表名、列名、检查值。返回存在(true)与不存在(false)
public bool GetExsitValue ( string vTable,string vColumn,string Value)
{
try
{
string strSQL = "select " + vColumn +" from " + vTable + " where " + vColumn + "='" + Value +"'";
OleDbConnection Conn = new OleDbConnection(ConnString);
OleDbCommand SQLCommand = new OleDbCommand(strSQL,Conn);
OleDbDataReader objRead;
Conn.Open(); objRead = SQLCommand.ExecuteReader();
bool Result = objRead.HasRows; Conn.Close();
if (Result)
{
return true;
}
else
{
return false;
}
}
catch(Exception e)
{
HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite);
HttpContext.Current.Response.Write("<br><font size='2'>请检查GetExsitValue调用参数!</font>");
HttpContext.Current.Response.End();
return false;
}
}
#endregion #region 执行SQL字段唯一性检查,参数为表名、列名1、检查值1、列2、检查值2。返回存在(true)与不存在(false)
public bool GetExsitValue ( string vTable,string vColumn1,string Value1,string vColumn2,string Value2)
{
try
{
string strSQL = "select " + vColumn1 +"," + vColumn2 +" from " + vTable + " where " + vColumn1 + "='" + Value1 +"' and "+ vColumn2 + "='" + Value2 + "'" ;
OleDbConnection Conn = new OleDbConnection(ConnString);
OleDbCommand SQLCommand = new OleDbCommand(strSQL,Conn);
OleDbDataReader objRead;
Conn.Open(); objRead = SQLCommand.ExecuteReader();
bool Result = objRead.HasRows; Conn.Close();
if (Result)
{
return true;
}
else
{
return false;
}
}
catch(Exception e)
{
HttpContext.Current.Response.Write("<font color=red size='2'>" + e.Message + "</font><br>" + e.TargetSite);
HttpContext.Current.Response.Write("<br><font size='2'>请检查GetExsitValue调用参数!</font>");
HttpContext.Current.Response.End();
return false;
}
}
#endregion
}
}
{
/// <summary>
/// Class1 的摘要说明。
/// </summary>
public class Class1
{
public Class1()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
}
}
其实就是一个class,手工写也行
只是你用没用到类的好处罢了
比如继承.重载。
我不是高手,你去问那些星星们他们肯定会给你好的答案哦