ASP.NET类的应用!(短)
刚接触这个类。对类的概念比较模糊。今天用它做了数据库链接(仅数据库链接),感觉很方便。。。具体的实现过程是这样的
VS2005+SQL2000
首先建立一个类命令为DB.CS 导入空间命名:using System.Data.SqlClient;
构建函数逻辑:
public static SqlConnection createConnection()
{
System.Data.SqlClient.SqlConnection xiaocon = new SqlConnection("server=.; uid=sa;pwd=xiaolei;database=pubs");
return xiaocon;
这个类就搞定了!
下面建立一个页面:放置一个 GridView控件。
在Page_load代码处写入下面代码
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = DB.createConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from Authors",conn);
SqlDataReader dtr = cmd.ExecuteReader();
this.GridView1.DataSource = dtr;
this.GridView1.DataBind();
conn.Close();
}
插入数据库内容:
protected void Button3_Click(object sender, EventArgs e)
{
SqlConnection conn = DB.createConnection();
SqlCommand cmd = new SqlCommand();
string name = TextBox1.Text.Trim();
string qq = TextBox2.Text.Trim();
string conents = TextBox3.Text.Trim();
string strSql = "insert into db(name,qq,conents) values('" + name + "','" + qq + "','" + conents + "')";
conn.Open();
cmd.Connection = conn;
cmd.CommandText = strSql;
cmd.ExecuteNonQuery();
conn.Close();
}
这样就OK了。是不是很简单!?
posted on 2007-05-26 13:20 ASP.NET学习日记!!! 阅读(660) 评论(3) 编辑 收藏 举报