前台
|
后台
protected void Page_Load(object sender, EventArgs e)
{
string sqlstr = @"data source=PC-LENOVE\SQLEXPRESS;initial catalog=KFC;USER ID=SA;PASSWORD=abing520";
SqlConnection con = new SqlConnection(sqlstr);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM Foods";
cmd.Connection = con;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cmd.Dispose();
con.Dispose();
this.Repeater1.DataSource = dt;
this.Repeater1.DataBind();
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (i % 4 == 0)//4是一行显示列数
{
e.Item.Controls.Add(new LiteralControl("
}
i++;
}
关注微信公众号获取更多VSCode编程信息,定时发布干货文章
全部评论