asp.net 读取数据库并显示源码
1,新建一个网站项目
在 web.config 中添加连接数据库的字符串
<appSettings>
<add key="db_conn" value="Data Source=.;Initial Catalog=test;User ID=sa;Password=123456"/>
</appSettings>
2,新建一个页面,放一个铵钮,在放一个GridView
添加按钮事件,以下是源码
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
/// <summary>
/// 显示新闻
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonShowNews_Click(object sender, EventArgs e)
{
//list 对象存放 News
List<News> list = new List<News>();
//1,连接sql server
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["db_conn"]);
//2,执行查询
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from News";
//3,读取结果集
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
list.Add(new News {
Id = Convert.ToInt32(reader["Id"]),
Title = Convert.ToString(reader["Title"]),
CreateTime = Convert.ToDateTime(reader["CreateTime"])
});
}
//4,关闭结果集
reader.Close();
//5,关闭连接
conn.Close();
//6,设置显示
this.GridView1.DataSource = list;
this.GridView1.DataBind();
}
}
//内部类 这里为了简单,我把类写到内部了
class News {
private int id;
public int Id
{
get { return id; }
set { id = value; }
}
private string title;
public string Title
{
get { return title; }
set { title = value; }
}
private DateTime createTime;
public DateTime CreateTime
{
get { return createTime; }
set { createTime = value; }
}
}
3,前台模板显示
<asp:GridView ID="GridView1" runat="server" BackColor="White"
BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3"
AutoGenerateColumns="False">
<Columns>
<asp:TemplateField HeaderText="主键ID">
<ItemTemplate><asp:Label ID="Id" runat="server" Text='<%#Eval("Id") %>'></asp:Label></ItemTemplate>
</asp:TemplateField>
</Columns>
<Columns>
<asp:TemplateField HeaderText="标题">
<ItemTemplate><asp:Label ID="Title" runat="server" Text='<%#Eval("Title") %>'></asp:Label></ItemTemplate>
</asp:TemplateField>
</Columns>
<Columns>
<asp:TemplateField HeaderText="创建时间">
<ItemTemplate><asp:Label ID="CreateTime" runat="server" Text='<%#Eval("CreateTime","{0:yyyy年mm月dd日}") %>'></asp:Label></ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="White" ForeColor="#000066" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#007DBB" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#00547E" />
</asp:GridView>