?? default.aspx.cs
字號:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace WuLiu
{
public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.GridView1.DataSource = sss("tb_Cargo");
this.GridView1.DataBind();
this.GridView2.DataSource = sss("tb_Truck");
this.GridView2.DataBind();
this.GridView3.DataSource = sss("tb_Chauffeur");
this.GridView3.DataBind();
this.GridView4.DataSource = sss("tb_OldTruck");
this.GridView4.DataBind();
this.GridView5.DataSource = sss("tb_Way");
this.GridView5.DataBind();
}
}
public DataTable sss(string tb)
{
SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
strcon.Open();
SqlDataAdapter sda = new SqlDataAdapter("select top 8 * from " + tb + " where Auditing=1 order by id desc", strcon);
DataSet ds = new DataSet();
sda.Fill(ds, tb);
return ds.Tables[tb];
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -