数据的连接是软件开发的基础,是重中之重,在Java有jdbc,而c#也有连接数据库的方法,今天演示的例子就是使用c#连接sql server数据库的方法。还有使用.net的控件实现分页处理。
连接数据库有七个步骤:
1、建立SqlConnection对象;
2、指定SqlConnection对象的ConnectionString 属性;
3、打开数据库连接;
4、指定SQL语句;
5、建立SqlDataAdapter对象和DataSet对象(myDataAdapter = new SqlDataAdapter(strCmd,conn));
6、添冲DataSet;
7、给DataGrid指定数据源
为了减少代码的复用率,我将数据库连接进行了封装,返回的是SqlConnection 对象,即简化了前三个步骤。
public SqlConnection Connect( )
{
string source = "Data Source=localhost;Initial Catalog=index1;User Id=sa;Password=gctxiao;Trusted_Connection=true";
SqlConnection connect = new SqlConnection(source);
connect.Open();
return connect;
}
下面就进行业务的处理了,即实现数据库的增删改查。
写后端前,我们要先写前端页面。使用asp.net控件,我们写了四个按钮,一个GridView控件。属性OnPageIndexChanging="Gridview1_Page" PageSize="3"设定了动作的函数,指定了一页内有几行。
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="index.aspx.cs" Inherits="Frist.index" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</div>
<p>
<asp:Button ID="Button1" runat="server" Text="建表" OnClick="Button1_Click" style="height: 27px" />
<asp:Button ID="Button2" runat="server" Text="查数据" OnClick="Button2_Click" />
<asp:Button ID="Button3" runat="server" Text="添加数据" OnClick="Button3_Click" />
<asp:Button ID="Button4" runat="server" Text="删除数据" OnClick="Button4_Click" />
<asp:TextBox ID="t1" runat="server"></asp:TextBox>
<asp:Button ID="Button5" runat="server" Text="更新数据" OnClick="Button5_Click" />
</p>
<asp:GridView ID="GridView1" runat="server" AllowPaging="true" OnPageIndexChanging="Gridview1_Page" PageSize="3">
</asp:GridView>
</form>
</body>
</html>
后端使用c#处理业务,控件 GridView方法GridView1.PageIndex = e.NewPageIndex;GridView1.DataBind(); int i = GridView1.PageIndex + 1;Label1.Text = "第"+i+"页";设置了换页的功能。进行了数据绑定。
protected void Page_Load(object sender, EventArgs e)
{
Label1.Visible = false;
if (!IsPostBack)
{
Validate();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Visible = true;
welcome.QuerData qd = new welcome.QuerData();
qd.Create();
Label1.Text = "建表成功";
}
protected void Button2_Click(object sender, EventArgs e)
{
query();
Label1.Text = "数据查询成功";
}
public void query()
{
GridView1.Visible = true;
QuerData q = new QuerData();
DataTable dt = q.Select();
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Button3_Click(object sender, EventArgs e)
{
Label1.Visible = true;
welcome.QuerData qd = new welcome.QuerData();
qd.Add();
Label1.Text = "数据添加成功";
}
protected void Gridview1_Page(object sender, GridViewPageEventArgs e)
{
Label1.Visible = true;
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
int i = GridView1.PageIndex + 1;
Label1.Text = "第"+i+"页";
query();
}
protected void Button4_Click(object sender, EventArgs e)
{
Label1.Visible = true;
welcome.QuerData qd = new welcome.QuerData();
qd.DropDate();
Label1.Text = "数据删除成功";
}
protected void Button5_Click(object sender, EventArgs e)
{
Label1.Visible = true;
welcome.QuerData qd = new welcome.QuerData();
qd.UpdateDate(t1.Text);
Label1.Text = "数据更新成功";
}
以上就是简单的数据库的全部操作,有增删改查。
实现的页面如下: