Asp.net VB保存数据问题,无法保存到数据库
<body><formid="login"name="login"method="post"action=""runat="server"><tablewidth="10...
<body>
<form id="login" name="login" method="post" action="" runat="server">
<table width="100%" border="0" cellspacing="0">
<tr>
<td colspan="2" align="center" valign="bottom"><span class="STYLE1">用户注册信息</span></td>
</tr>
<tr>
<td colspan="2" bgcolor="#99CCFF"><span class="STYLE4">带*项目为必填项目</span></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td width="8%" align="left">用户姓名:</td>
<td width="92%" height="30"><asp:TextBox ID="name" runat="server" />
*<asp:RequiredFieldValidator ControlToValidate="name" ErrorMessage="必须输入用户名" ID="namecheck" runat="server" /></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td align="left">性别:</td>
<td height="30"><asp:DropDownList AutoPostBack="false" ID="xb" runat="server"></asp:DropDownList>
*
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td align="left">密码:</td>
<td height="30"><asp:TextBox ID="mm" TextMode="Password" runat="server" />
*</td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td align="left">Email:</td>
<td height="30"><asp:TextBox ID="Email" runat="server" />
*</td>
</tr>
<tr>
<td height="30" colspan="2" align="center"><asp:Button ID="Button1" Text="提交" runat="server" />
<input type="reset" name="Submit" value="重置" /></td>
</tr>
</table>
</form>
</body>
我是在自己电脑上练习的,没有后台啊.本地机器高为服务器. 展开
<form id="login" name="login" method="post" action="" runat="server">
<table width="100%" border="0" cellspacing="0">
<tr>
<td colspan="2" align="center" valign="bottom"><span class="STYLE1">用户注册信息</span></td>
</tr>
<tr>
<td colspan="2" bgcolor="#99CCFF"><span class="STYLE4">带*项目为必填项目</span></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td width="8%" align="left">用户姓名:</td>
<td width="92%" height="30"><asp:TextBox ID="name" runat="server" />
*<asp:RequiredFieldValidator ControlToValidate="name" ErrorMessage="必须输入用户名" ID="namecheck" runat="server" /></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td align="left">性别:</td>
<td height="30"><asp:DropDownList AutoPostBack="false" ID="xb" runat="server"></asp:DropDownList>
*
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td align="left">密码:</td>
<td height="30"><asp:TextBox ID="mm" TextMode="Password" runat="server" />
*</td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td align="left">Email:</td>
<td height="30"><asp:TextBox ID="Email" runat="server" />
*</td>
</tr>
<tr>
<td height="30" colspan="2" align="center"><asp:Button ID="Button1" Text="提交" runat="server" />
<input type="reset" name="Submit" value="重置" /></td>
</tr>
</table>
</form>
</body>
我是在自己电脑上练习的,没有后台啊.本地机器高为服务器. 展开
3个回答
展开全部
database
using System;
using System.Data;
using System.Configuration;
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;
/// <summary>
/// database 的摘要说明
/// </summary>
public class database
{
private SqlConnection conn;
public database()
{
//
// TODO: 在此处添加构造函数逻辑
//
string sqlcon = "Server=localhost;Initial catalog=mydb;user=sa;password=123456";
conn = new SqlConnection(sqlcon);
}
public int executenon(string sqlstr)
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
int num = cmd.ExecuteNonQuery();
return num;
conn.Close();
}
public int executesal(string sqlstr)
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
int num = Convert.ToInt32(cmd.ExecuteScalar());
return num;
conn.Close();
}
public SqlDataReader executeread(string sqlstr)
{
SqlDataReader dr = null;
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
dr=cmd.ExecuteReader();
return dr;
conn.Close();
}
public DataSet executedataset(string sqlstr)
{
DataSet ds=null;
try
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet("userDataset");
da.Fill(ds, "userTable");
return ds;
}
catch
{
return ds;
}
}
}
order
using System;
using System.Data;
using System.Configuration;
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.Text;
using System.Collections;
/// <summary>
/// order 的摘要说明
/// </summary>
public class order
{
public order()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
}
public class OrderItemInfo
{
public int ProductID;
public int Number;
public double Price;
public string Name;
}
public class OrderInfo
{
public int TotalNumber;
public double TotalMoney;
public ArrayList OrderItemList = new ArrayList();
}
注册页面
database db = new database();
String xb;
if (RadioButton1.Checked == true)
xb = "男";
else
xb = "女";
string sqlstr = "insert memberlist(memberid,memberpwd,membersex,membere_mail) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + xb + "','" + TextBox4.Text + "')";
int num = db.executenon(sqlstr);
if (num > 0)
{
Response.Write("<script language='javascript'>alter('注册成功')</script>");
Response.Redirect("Default.aspx");
}
else
{
Response.Write("<script language='javascript'>alert('注册不成功')</script>");
Response.Redirect("loginpage.aspx");
登陆按钮
string meid = TextBox1.Text;
string mepwd = TextBox2.Text;
string sqlstr = null;
if (RadioButton1.Checked)
{
sqlstr = "select count(memberid) from guanglilist where memberid='" + meid + "' and memberpwd='" + mepwd + "'";
}
else
{
sqlstr = "select count(memberid) from memberlist where memberid='" + meid + "' and memberpwd='" + mepwd + "' and checked='已审核'";
}
database db = new database();
int num = db.executesal(sqlstr);
if (num > 0)
{
Response.Write("<script language='javascript'>alter('登陆成功')</script>");
MultiView1.ActiveViewIndex = 1;
if (RadioButton1.Checked)
{
HyperLink1.Visible = true;
}
else
{
HyperLink1.Visible = false;
}
}
else
Response.Write("<script language='javascript'>alert('登录失败')</script>");
HttpCookie cookie = new HttpCookie("loginMessage");
cookie.Values.Add("meid", meid);
Response.Cookies.Add(cookie);
Label3.Text = meid;
密码修改
protected void Page_Load(object sender, EventArgs e)
{
if (null != Request.Cookies["loginMessage"])
{
HttpCookie cookie = Request.Cookies["loginMessage"];
Label2.Text = Request.Cookies["loginMessage"]["meid"].ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string opwd = TextBox1.Text;
string npwd = TextBox2.Text;
string usid = Label2.Text;
string sqlstr = "update guanglilist set memberpwd='" + npwd + "' where memberid='" + usid + "' and memberpwd='" + opwd + "'";
database db = new database();
int num = db.executenon(sqlstr);
if (num > 0)
{
Response.Write("<script language='javascript'>alert('密码修改成功')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('原密码错误')</script>");
}
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
}
成员管理
屏蔽，审核：
string id = Convert.ToString(GridView1.SelectedDataKey.Value);
Response.Redirect("detail.aspx?id=" + id);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("check"))
{
string id = Convert.ToString(GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)].Value);
string sqlstr = "update memberlist set checked='已审核' where id='" + id + "'";
SqlDataSource1.UpdateCommand = sqlstr;
SqlDataSource1.Update();
}
if (e.CommandName.Equals("uncheck"))
{
string id = Convert.ToString(GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)].Value);
string sqlstr = "update memberlist set checked='未审核' where id='" + id + "'";
SqlDataSource1.UpdateCommand = sqlstr;
SqlDataSource1.Update();
}
新闻管理
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["model"] = Request["model"];
ViewState["id"] = Request["id"];
if (ViewState["model"].ToString().Equals("edit"))
{
database db = new database();
string sqlstr = "select * from newlise where id=" + Convert.ToInt32(ViewState["id"]);
SqlDataReader dr = db.executeread(sqlstr);
if (dr.Read())
{
TextBox1.Text = dr[1].ToString();
TextBox2.Text = dr[2].ToString();
}
}
}
}
“添加”
protected void Button1_Click(object sender, EventArgs e)
{
string tle = TextBox1.Text;
string cont = TextBox2.Text;
string sql;
database db = new database();
if (ViewState["model"].ToString().Equals("add"))
sql = "insert into newlist(title,content) values('" + tle + "','" + cont + "')";
else
sql = "update newlise set title='" + tle + "',content='" + cont + "' where id =" + Convert.ToInt32(ViewState["id"]);
int num = db.executenon(sql);
if (num > 0)
Response.Write("<script language='javascript'> alert ('提交成功!')</script>");
else
Response.Write("<script language='javascript'> alert (提交不成功!')</script>");
}
“编辑”
Response.Redirect("newsmanage.aspx?model=edit");
新书添加：
string lb_name = DropDownList1.SelectedValue.ToString();
string bk_name = TextBox2.Text;
string bk_auth = TextBox3.Text;
string bk_cbs = TextBox4.Text;
Double bk_pri = Convert.ToDouble(TextBox6.Text);
string bk_jj = TextBox1.Text;
string bk_ofile = File1.Value.ToString();
string[] tpfile = bk_ofile.Split('.');
string ext = "." + tpfile[tpfile.Length - 1];
Random r = new Random();
string bk_img = DateTime.Now.Year.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Second.ToString() + r.Next(100, 1000).ToString();
bk_img = bk_img + ext;
File1.PostedFile.SaveAs(Server.MapPath("image/") + bk_img);
bk_img = "image" + "/" + bk_img;
string sqlstr = "insert into booklist(bookname,autler,cbs,price,info,img,categary) values('" + bk_name + "','" + bk_auth + "','" + bk_cbs + "'," + bk_pri + ",'" + bk_jj + "','" + bk_img + "','" + lb_name + "')";
database db = new database();
int num = db.executenon(sqlstr);
if (num > 0)
{
Response.Write("<script language='javascript'>alter('插入成功')</script>");
Response.Redirect("bookmanage.aspx");
}
else
{
Response.Write("<script language='javascript'>alter('插入失败')</script>");
}
购物
public partial class bookshop2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request["name"] != null)
{
ViewState["name"] = Request["name"].ToString();
}
else
{
ViewState["name"] = "%";
}
if (!IsPostBack)
{
ViewState["pageindex"] = "0";
BindData(ViewState["name"].ToString());
}
}
private void BindData(string categoryName)
{
database db = new database();
string sqlstr = "SELECT * From booklist where categary like '%" + categoryName + "%'";
DataSet ds = db.executedataset(sqlstr);
DataTable dataTable = ds.Tables[0];
if (dataTable != null && dataTable.Rows.Count > 0)
{
DataView dataView = dataTable.DefaultView;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dataView;
pds.AllowPaging = true;
pds.PageSize = 2;
pds.CurrentPageIndex = Convert.ToInt32(ViewState["pageindex"].ToString());
lb_pageCount.Text = (Convert.ToInt32(ViewState["pageindex"]) + 1).ToString() + "／" + pds.PageCount.ToString() +
"页";
if (!pds.IsFirstPage)
{
lkPre.Visible = true;
}
else
{
lkPre.Visible = false;
}
if (!pds.IsLastPage)
{
lkNext.Visible = true;
}
else
{
lkNext.Visible = false;
}
DataList2.DataSource = pds;
DataList2.DataBind();
}
else
{
lkNext.Visible = false;
lkPre.Visible = false;
lb_pageCount.Visible = false;
}
}
protected void IndexChanging(object sender, EventArgs e)
{
string strCommand = ((LinkButton)sender).CommandArgument.ToString();
int pageindex = Convert.ToInt32(ViewState["pageindex"].ToString());
if (strCommand == "pre")
{
pageindex = pageindex - 1;
}
else
{
pageindex = pageindex + 1;
}
ViewState["pageindex"] = pageindex;
BindData(ViewState["aname"].ToString());
}
protected void DataList2_ItemCommand(object source, DataListCommandEventArgs e)
{
OrderItemInfo item = null;
OrderInfo order = null;
string cmdName = null;
int bookid = 0;
string sqlstr = null;
cmdName = e.CommandName.ToString();
if (cmdName.Equals("buyIt"))
{
bookid = Convert.ToInt32(e.CommandArgument);
sqlstr = "select bookname,price from booklist where id=" + bookid;
}
if (Request.Cookies["loginMessage"] != null)
{
if (Session[Session.SessionID] == null)
{
item = new OrderItemInfo();
order = new OrderInfo();
database db = new database();
SqlDataReader dr = db.executeread(sqlstr);
dr.Read();
item.ProductID = bookid;
item.Name = dr[0].ToString();
item.Number = 1;
item.Price = Convert.ToDouble(dr[1]);
order.OrderItemList.Add(item);
order.TotalMoney = item.Price;
order.TotalNumber = item.Number;
Session[Session.SessionID] = order;
}
else
{
order = (OrderInfo)Session[Session.SessionID];
item = new OrderItemInfo();
OrderItemInfo tempItem = null;
int i = 0;
for (i = 0; i < order.OrderItemList.Count; i++)
{
tempItem = (OrderItemInfo)order.OrderItemList[i];
if (tempItem.ProductID == bookid)
{
tempItem.Number++;
order.TotalMoney += tempItem.Price;
break;
}
}
if (i == order.OrderItemList.Count)
{
database db = new database();
SqlDataReader dr = db.executeread(sqlstr);
dr.Read();
item.ProductID = bookid;
item.Name = dr[0].ToString();
item.Number = 1;
item.Price = Convert.ToDouble(dr[1]);
order.OrderItemList.Add(item);
order.TotalMoney += item.Price;
}
order.TotalNumber++;
Session[Session.SessionID] = order;
}
Response.Write("<script>window.alert('恭喜您，添加该商品到购物车成功！')</script>");
}
else
{
Response.Write("<script>window.alert('未登陆用户不允许购买商品！')</script>");
}
}
}
using System;
using System.Data;
using System.Configuration;
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;
/// <summary>
/// database 的摘要说明
/// </summary>
public class database
{
private SqlConnection conn;
public database()
{
//
// TODO: 在此处添加构造函数逻辑
//
string sqlcon = "Server=localhost;Initial catalog=mydb;user=sa;password=123456";
conn = new SqlConnection(sqlcon);
}
public int executenon(string sqlstr)
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
int num = cmd.ExecuteNonQuery();
return num;
conn.Close();
}
public int executesal(string sqlstr)
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
int num = Convert.ToInt32(cmd.ExecuteScalar());
return num;
conn.Close();
}
public SqlDataReader executeread(string sqlstr)
{
SqlDataReader dr = null;
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
dr=cmd.ExecuteReader();
return dr;
conn.Close();
}
public DataSet executedataset(string sqlstr)
{
DataSet ds=null;
try
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet("userDataset");
da.Fill(ds, "userTable");
return ds;
}
catch
{
return ds;
}
}
}
order
using System;
using System.Data;
using System.Configuration;
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.Text;
using System.Collections;
/// <summary>
/// order 的摘要说明
/// </summary>
public class order
{
public order()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
}
public class OrderItemInfo
{
public int ProductID;
public int Number;
public double Price;
public string Name;
}
public class OrderInfo
{
public int TotalNumber;
public double TotalMoney;
public ArrayList OrderItemList = new ArrayList();
}
注册页面
database db = new database();
String xb;
if (RadioButton1.Checked == true)
xb = "男";
else
xb = "女";
string sqlstr = "insert memberlist(memberid,memberpwd,membersex,membere_mail) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + xb + "','" + TextBox4.Text + "')";
int num = db.executenon(sqlstr);
if (num > 0)
{
Response.Write("<script language='javascript'>alter('注册成功')</script>");
Response.Redirect("Default.aspx");
}
else
{
Response.Write("<script language='javascript'>alert('注册不成功')</script>");
Response.Redirect("loginpage.aspx");
登陆按钮
string meid = TextBox1.Text;
string mepwd = TextBox2.Text;
string sqlstr = null;
if (RadioButton1.Checked)
{
sqlstr = "select count(memberid) from guanglilist where memberid='" + meid + "' and memberpwd='" + mepwd + "'";
}
else
{
sqlstr = "select count(memberid) from memberlist where memberid='" + meid + "' and memberpwd='" + mepwd + "' and checked='已审核'";
}
database db = new database();
int num = db.executesal(sqlstr);
if (num > 0)
{
Response.Write("<script language='javascript'>alter('登陆成功')</script>");
MultiView1.ActiveViewIndex = 1;
if (RadioButton1.Checked)
{
HyperLink1.Visible = true;
}
else
{
HyperLink1.Visible = false;
}
}
else
Response.Write("<script language='javascript'>alert('登录失败')</script>");
HttpCookie cookie = new HttpCookie("loginMessage");
cookie.Values.Add("meid", meid);
Response.Cookies.Add(cookie);
Label3.Text = meid;
密码修改
protected void Page_Load(object sender, EventArgs e)
{
if (null != Request.Cookies["loginMessage"])
{
HttpCookie cookie = Request.Cookies["loginMessage"];
Label2.Text = Request.Cookies["loginMessage"]["meid"].ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string opwd = TextBox1.Text;
string npwd = TextBox2.Text;
string usid = Label2.Text;
string sqlstr = "update guanglilist set memberpwd='" + npwd + "' where memberid='" + usid + "' and memberpwd='" + opwd + "'";
database db = new database();
int num = db.executenon(sqlstr);
if (num > 0)
{
Response.Write("<script language='javascript'>alert('密码修改成功')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('原密码错误')</script>");
}
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
}
成员管理
屏蔽，审核：
string id = Convert.ToString(GridView1.SelectedDataKey.Value);
Response.Redirect("detail.aspx?id=" + id);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("check"))
{
string id = Convert.ToString(GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)].Value);
string sqlstr = "update memberlist set checked='已审核' where id='" + id + "'";
SqlDataSource1.UpdateCommand = sqlstr;
SqlDataSource1.Update();
}
if (e.CommandName.Equals("uncheck"))
{
string id = Convert.ToString(GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)].Value);
string sqlstr = "update memberlist set checked='未审核' where id='" + id + "'";
SqlDataSource1.UpdateCommand = sqlstr;
SqlDataSource1.Update();
}
新闻管理
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["model"] = Request["model"];
ViewState["id"] = Request["id"];
if (ViewState["model"].ToString().Equals("edit"))
{
database db = new database();
string sqlstr = "select * from newlise where id=" + Convert.ToInt32(ViewState["id"]);
SqlDataReader dr = db.executeread(sqlstr);
if (dr.Read())
{
TextBox1.Text = dr[1].ToString();
TextBox2.Text = dr[2].ToString();
}
}
}
}
“添加”
protected void Button1_Click(object sender, EventArgs e)
{
string tle = TextBox1.Text;
string cont = TextBox2.Text;
string sql;
database db = new database();
if (ViewState["model"].ToString().Equals("add"))
sql = "insert into newlist(title,content) values('" + tle + "','" + cont + "')";
else
sql = "update newlise set title='" + tle + "',content='" + cont + "' where id =" + Convert.ToInt32(ViewState["id"]);
int num = db.executenon(sql);
if (num > 0)
Response.Write("<script language='javascript'> alert ('提交成功!')</script>");
else
Response.Write("<script language='javascript'> alert (提交不成功!')</script>");
}
“编辑”
Response.Redirect("newsmanage.aspx?model=edit");
新书添加：
string lb_name = DropDownList1.SelectedValue.ToString();
string bk_name = TextBox2.Text;
string bk_auth = TextBox3.Text;
string bk_cbs = TextBox4.Text;
Double bk_pri = Convert.ToDouble(TextBox6.Text);
string bk_jj = TextBox1.Text;
string bk_ofile = File1.Value.ToString();
string[] tpfile = bk_ofile.Split('.');
string ext = "." + tpfile[tpfile.Length - 1];
Random r = new Random();
string bk_img = DateTime.Now.Year.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Second.ToString() + r.Next(100, 1000).ToString();
bk_img = bk_img + ext;
File1.PostedFile.SaveAs(Server.MapPath("image/") + bk_img);
bk_img = "image" + "/" + bk_img;
string sqlstr = "insert into booklist(bookname,autler,cbs,price,info,img,categary) values('" + bk_name + "','" + bk_auth + "','" + bk_cbs + "'," + bk_pri + ",'" + bk_jj + "','" + bk_img + "','" + lb_name + "')";
database db = new database();
int num = db.executenon(sqlstr);
if (num > 0)
{
Response.Write("<script language='javascript'>alter('插入成功')</script>");
Response.Redirect("bookmanage.aspx");
}
else
{
Response.Write("<script language='javascript'>alter('插入失败')</script>");
}
购物
public partial class bookshop2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request["name"] != null)
{
ViewState["name"] = Request["name"].ToString();
}
else
{
ViewState["name"] = "%";
}
if (!IsPostBack)
{
ViewState["pageindex"] = "0";
BindData(ViewState["name"].ToString());
}
}
private void BindData(string categoryName)
{
database db = new database();
string sqlstr = "SELECT * From booklist where categary like '%" + categoryName + "%'";
DataSet ds = db.executedataset(sqlstr);
DataTable dataTable = ds.Tables[0];
if (dataTable != null && dataTable.Rows.Count > 0)
{
DataView dataView = dataTable.DefaultView;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dataView;
pds.AllowPaging = true;
pds.PageSize = 2;
pds.CurrentPageIndex = Convert.ToInt32(ViewState["pageindex"].ToString());
lb_pageCount.Text = (Convert.ToInt32(ViewState["pageindex"]) + 1).ToString() + "／" + pds.PageCount.ToString() +
"页";
if (!pds.IsFirstPage)
{
lkPre.Visible = true;
}
else
{
lkPre.Visible = false;
}
if (!pds.IsLastPage)
{
lkNext.Visible = true;
}
else
{
lkNext.Visible = false;
}
DataList2.DataSource = pds;
DataList2.DataBind();
}
else
{
lkNext.Visible = false;
lkPre.Visible = false;
lb_pageCount.Visible = false;
}
}
protected void IndexChanging(object sender, EventArgs e)
{
string strCommand = ((LinkButton)sender).CommandArgument.ToString();
int pageindex = Convert.ToInt32(ViewState["pageindex"].ToString());
if (strCommand == "pre")
{
pageindex = pageindex - 1;
}
else
{
pageindex = pageindex + 1;
}
ViewState["pageindex"] = pageindex;
BindData(ViewState["aname"].ToString());
}
protected void DataList2_ItemCommand(object source, DataListCommandEventArgs e)
{
OrderItemInfo item = null;
OrderInfo order = null;
string cmdName = null;
int bookid = 0;
string sqlstr = null;
cmdName = e.CommandName.ToString();
if (cmdName.Equals("buyIt"))
{
bookid = Convert.ToInt32(e.CommandArgument);
sqlstr = "select bookname,price from booklist where id=" + bookid;
}
if (Request.Cookies["loginMessage"] != null)
{
if (Session[Session.SessionID] == null)
{
item = new OrderItemInfo();
order = new OrderInfo();
database db = new database();
SqlDataReader dr = db.executeread(sqlstr);
dr.Read();
item.ProductID = bookid;
item.Name = dr[0].ToString();
item.Number = 1;
item.Price = Convert.ToDouble(dr[1]);
order.OrderItemList.Add(item);
order.TotalMoney = item.Price;
order.TotalNumber = item.Number;
Session[Session.SessionID] = order;
}
else
{
order = (OrderInfo)Session[Session.SessionID];
item = new OrderItemInfo();
OrderItemInfo tempItem = null;
int i = 0;
for (i = 0; i < order.OrderItemList.Count; i++)
{
tempItem = (OrderItemInfo)order.OrderItemList[i];
if (tempItem.ProductID == bookid)
{
tempItem.Number++;
order.TotalMoney += tempItem.Price;
break;
}
}
if (i == order.OrderItemList.Count)
{
database db = new database();
SqlDataReader dr = db.executeread(sqlstr);
dr.Read();
item.ProductID = bookid;
item.Name = dr[0].ToString();
item.Number = 1;
item.Price = Convert.ToDouble(dr[1]);
order.OrderItemList.Add(item);
order.TotalMoney += item.Price;
}
order.TotalNumber++;
Session[Session.SessionID] = order;
}
Response.Write("<script>window.alert('恭喜您，添加该商品到购物车成功！')</script>");
}
else
{
Response.Write("<script>window.alert('未登陆用户不允许购买商品！')</script>");
}
}
}
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
首先，你应该把错误提示贴出来
其次，应该把你保存数据的那段代码贴出来
你现在给的就是简单的HTML代码，和你保存数据没有必然联系
其次，应该把你保存数据的那段代码贴出来
你现在给的就是简单的HTML代码，和你保存数据没有必然联系
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
后台代码呢
e,本地机器是不是服务器都一样啊
你写的代码只是html啊，只是页面而已，你要保存到数据库，你的VB代码呢？
e,本地机器是不是服务器都一样啊
你写的代码只是html啊，只是页面而已，你要保存到数据库，你的VB代码呢？
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
更多回答（1）
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
