上一篇博客主要是针对学习内容做了一个简单的总结,感觉知识还是不太熟悉。所以,需要我们动手亲自去敲每一个例子,要将例子中的知识点提出来才好。
数据库连接
SqlConnection con = new SqlConnection("Data source=.;database=DongleTest;Integrated Security=true");
con.Open();
SqlCommand cmd = new SqlCommand("select count(*) from t_person where pID='" + pID + "'", con);
cmd.ExecuteScalar()
DataAdapater
SqlConnection con = new SqlConnection("Data source=.;database=DongleTest;Integrated Security=true");//连接数据库(本地)
con.Open();//代开数据库
SqlDataAdapter sda = new SqlDataAdapter();//创建DataAdapter,用于填充DataSet和更新数据库SQL
sda.SelectCommand = new SqlCommand("select * from t_person", con);//选择T-SQL语句,在数据源中记录
DataSet ds = new DataSet();//实例化DataSet
sda.Fill(ds, "person");//DataAdapter填充DataSet
return ds.Tables["person"];//获取DataSet中表的集合
注意
数据库再不适用的时候一定要记得关闭!
Application对象
void Session_Start(object sender, EventArgs e)
{
// 在新会话启动时运行的代码
Application.Lock();//锁定状态
Application["count"] = (int)Application["count"] + 1;
Application.UnLock();//解除锁定
}
//连接数据库
SqlConnection con = new SqlConnection("Data Source=.;Database=Dongle.Test;uid=sa;pwd=123456");
con.Open();//打开数据库
//执行数据库语句
SqlCommand cmd = new SqlCommand("select * from countPeople",con);
int count = Convert.ToInt32(cmd.ExecuteScalar());//获取查询结果中的第一行第一列(忽略其它行和列)
con.Close();//关闭数据库
Application["total"] = count;//总人数
Application["online"] = 0;//在线人数
GridView控件
<asp:GridView ID="GridView1" runat ="server" AutoGenerateColumns ="false"
BackColor ="White" BorderColor ="#3366CC" BorderStyle ="None" BorderWidth ="1px"
CellPadding ="4" AllowPaging ="true" AllowSorting ="true" OnPageIndexChanged ="GridView1_PageIndexChanging"
OnRowCancelingEdit ="GridView1_RowCancelingEdit" OnRowDeleted ="GridView1_RowDelecting" OnRowEditing ="GridView1_RowEditing"
OnRowUpdating="GridView1_RowUpdating" OnSorting ="GridView1_Sorting" PageSize ="4" OnRowDataBound ="GridView1_RowDataBound">
<FooterStyle BackColor ="#99cccc" ForeColor ="#003399" Font-Bold ="false" />
<Columns >
<asp:HyperLinkField DataNavigateUrlFields ="emploeeID" DataNavigateUrlFormatString ="showDetails.aspx?empID={0}" DataTextField ="employeeID"
HeaderText ="员工编号" SortExpression ="EmployeeID" />
<asp:BoundField DataField ="EmployeeID" HeaderText ="员工编号" SortExpression ="EmployeeID" />
<asp:BoundField DataField ="LastName" HeaderText ="LastName" SortExpression ="LastName" />
<asp:BoundField DataField ="FirstName" HeaderText ="FirstName" SortExpression ="FirstName" />
<asp:BoundField DataField ="Title" HeaderText ="标题" SortExpression ="Title" />
<asp:TemplateField HeaderText ="出生日期" SortExpression ="BirthDate">
<EditItemTemplate >
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
这个控件属性比较多,这里就以这个来描述吧。如果我们自己真实手动输入代码添加控件的话,我相信大家可定能总结出个一二的。比如,很多控件就有ID名称,border(Border-width,border-height,borderstyle)边框(宽、高,方式),borderColor边框颜色,backColor背景颜色, font-bold字体粗体,font-size字体大小,等等,很多很多相同的属性,可谓知其一得其三!会写一个了,其他的也就盲人摸象般的摸索出来了,当然这个要看个人耐心啦!
然后就是个别控件存在个别的特别属性,比如DataGrid控件,列数CellPadding,是否允许分页AllowPage,删除行OnRowsDeleted,选页事件OnPageIndexChange,取消修改数据OnRowCancelingEdit,还有组成页脚Footers,列Columns,等等。当然很多表控件也存在类似的功能。
在学习使用控件的时候,要多去找相似处,找相似处会比找不同处学习起来更容易的!