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;
public partial class student_stu_mag_mag_book : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!this.IsPostBack )
{
string strsql = "select * from View_lib_book_result where 学号='"+Session["stuID"]+"'"; student stu = new student();
this.GridView1.DataSource = stu.ExecuteSQL_DataSet(strsql);
this.GridView1.DataBind();
}
}
}
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;
public partial class student_stu_mag_mag_book : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!this.IsPostBack )
{
string strsql = "select * from View_lib_book_result where 学号='"+Session["stuID"]+"'"; student stu = new student();
this.GridView1.DataSource = stu.ExecuteSQL_DataSet(strsql);
this.GridView1.DataBind();
}
}
}
好好问问你们老师,让他给你讲解下ado.net知识
你这问题和你帖出来的代码不符啊。。更新不成功先调式:
1.看看抛不抛异常2.看看是不是传入对的条件。。3.注意细节比如where条件前后的空格(在数据库中如果:“abc”,你传入的条件是“ abc”),这样你sql语法没问题,也不会更新成功因为没找到符合条件的行。。
这个方法估计有问题,代码帖出来看看,要不你就单步调试下
{
protected void Page_Load(object sender, EventArgs e)
{
//防止非法进入
if (!IsPostBack)
{
if (Request.Browser.Cookies == true)
{
if (Request.Cookies["name"] == null)
{
Response.Redirect("login.aspx");//跳转到登录页面
} }
}
T_UserTableAdapter adapter = new T_UserTableAdapter();
var user = adapter.GetDataByname(Request.Cookies["name"].Value);
var data = user.Single();
lbname.Text = data.name;
txtpassword.Text = data.password;
txtQQ.Text = data.QQ;
txtEmail.Text = data._E_Mail;
txtface.Text = data.face;
faceimg.Src = data.face;
if (data.gender == "男")
{
RadioButton1.Checked = true;
}
else
{
RadioButton2.Checked = true;
} } protected void btn_Click(object sender, EventArgs e)
{
T_UserTableAdapter adapter = new T_UserTableAdapter();
var user = adapter.GetDataByname(Request.Cookies["name"].Value);
var data= user.Single();
if (RadioButton1.Checked == true)
{
data.password = txtpassword.Text;
data.gender = RadioButton1.Text;
data.face = txtface.Text;
data.QQ = txtQQ.Text;
data._E_Mail = txtEmail.Text;
data.Date = DateTime.Now;
}
else if (RadioButton2.Checked == true)
{
data.password = txtpassword.Text;
data.gender = RadioButton2.Text;
data.face = txtface.Text;
data.QQ = txtQQ.Text;
data._E_Mail = txtEmail.Text;
data.Date = DateTime.Now;
}
adapter.Update(data);
Response.Redirect("WebForm1.aspx");
}
}这段代码为什么不能更新