下面的代码,只能读取表中的头一个ID ,但ACCESS 数据完全通过测试。public partial class X_Edit_Basic : System.Web.UI.Page
{
private int XuexiaoId = -1; protected void Page_Load(object sender, EventArgs e)
{
///获取参数XuexiaoId的值
if (Session["XuexiaoId"] != null)
{
///获取参数XuexiaoId的值
if (Int32.TryParse(Session["XuexiaoId"].ToString(), out XuexiaoId) == false)
{
return;
}
}
else
{
Response.Redirect("~/X/School_Login.aspx");
}
if (!Page.IsPostBack)
{ ///判断参数是否正确
if (XuexiaoId > -1)
{ ///从数据库中读取数据,并显示
BindUserData(XuexiaoId);
}
else
{
UpdateBtn.Enabled = false;
}
}
}
private void BindUserData(int XuexiaoId)
{
DB Users = new DB();
SQLiteDataReader dr = Users.GetsingUser(XuexiaoId);
if (dr.Read())
{//读取数据
this.yuanxiaoId.Text = dr["XuexiaoId"].ToString();
this.zhaoshengId.Text = dr["ZhaoshenId"].ToString();
this.xuexiaoadds.Text = dr["Adss"].ToString();
this.phone.Text = dr["phone"].ToString();
this.fax.Text = dr["fax"].ToString();
this.netadds.Text = dr["Net"].ToString();
this.Label1.Text = dr["GaoxiaoId"].ToString();
}
dr.Close();
}} public SQLiteDataReader GetsingUser(int XuexiaoId)
{
SQLiteConnection Conn = Getconn();
string Get = "SELECT * FROM [k_XuexiaoName] WHERE ( [XuexiaoId] = " + XuexiaoId.ToString() + ") limit 1";
SQLiteCommand Cmd = new SQLiteCommand (Get,Conn);
//Conn.Open();
//return Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Cmd.ExecuteReader(); }
{
private int XuexiaoId = -1; protected void Page_Load(object sender, EventArgs e)
{
///获取参数XuexiaoId的值
if (Session["XuexiaoId"] != null)
{
///获取参数XuexiaoId的值
if (Int32.TryParse(Session["XuexiaoId"].ToString(), out XuexiaoId) == false)
{
return;
}
}
else
{
Response.Redirect("~/X/School_Login.aspx");
}
if (!Page.IsPostBack)
{ ///判断参数是否正确
if (XuexiaoId > -1)
{ ///从数据库中读取数据,并显示
BindUserData(XuexiaoId);
}
else
{
UpdateBtn.Enabled = false;
}
}
}
private void BindUserData(int XuexiaoId)
{
DB Users = new DB();
SQLiteDataReader dr = Users.GetsingUser(XuexiaoId);
if (dr.Read())
{//读取数据
this.yuanxiaoId.Text = dr["XuexiaoId"].ToString();
this.zhaoshengId.Text = dr["ZhaoshenId"].ToString();
this.xuexiaoadds.Text = dr["Adss"].ToString();
this.phone.Text = dr["phone"].ToString();
this.fax.Text = dr["fax"].ToString();
this.netadds.Text = dr["Net"].ToString();
this.Label1.Text = dr["GaoxiaoId"].ToString();
}
dr.Close();
}} public SQLiteDataReader GetsingUser(int XuexiaoId)
{
SQLiteConnection Conn = Getconn();
string Get = "SELECT * FROM [k_XuexiaoName] WHERE ( [XuexiaoId] = " + XuexiaoId.ToString() + ") limit 1";
SQLiteCommand Cmd = new SQLiteCommand (Get,Conn);
//Conn.Open();
//return Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Cmd.ExecuteReader(); }
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货