using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sqlStr;
cmd.ExecuteNonQuery(); //执行sql语句，插入数据
}
}
Response.Write(“”);
}
}
4、?新建goodsadmin页面，首先判断用户是否已经登录，如果没有登录则跳转到login.aspx页面。在此页码中，要求用gridview显示所有的商品信息，并在gridview中为商品添加**“编辑“和”删除“功能**。(Done)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class goodsAdmin : System.Web.UI.Page
{
//连接字符串
string connStr = “Data Source=.\SQLEXPRESS;AttachDbFilename=D:\My Documents\Test.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True”;
DataSet ds;
protected void Page_Load(object sender, EventArgs e)
{
//如果用户没有登陆
if (Session[“username”] == null)
{
Response.Redirect("~/login.aspx");
}
else
{
bind();
}
}
///
/// 数据绑定到gridView
///
public void bind()
{
string sqlStr = “select * from goods_info”;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sqlStr;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
ds = new DataSet();
adapter.Fill(ds);
}
}
GridView1.DataSource = ds;
GridView1.DataBind();
}
///
/// 为gridview 添加编辑功能
///
///
///
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
//设计要编辑的行
GridView1.EditIndex = e.NewEditIndex;
bind();
}
///
/// 删除操作
///
///
///
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string goods_name = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString();
string sql = “delete from goods_info where goods_name = '” + goods_name + “’”;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
GridView1.EditIndex = -1;
bind();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
bind();
}
}
5、? 在网站中添加”App_Code”文件夹，在其中添加一个类，在此类中分别定义可以实现建立数据库连接、执行sql查询语句和执行sql更新语句的方法。（Done）
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
///
///SqlHelp 的摘要说明
///
public class SqlHelper
{
//连接字符串
private static string connStr = “Data Source=.\SQLEXPRESS;AttachDbFilename=D:\My Documents\Test.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True”;
private SqlConnection conn = null;
private SqlCommand cmd = null;
private SqlDataReader dataReader = null;
private DataSet ds = null;
///
/// 获得数据库对象
///
///
public SqlConnection getConnection()
{
conn = new SqlConnection(connStr);
return conn;
}
///
/// 返回查询结果
///
///
///
public SqlDataReader executeNonQuery(string sql)
{
if (conn == null)
{
conn = getConnection();
}
cmd = new SqlCommand(sql, conn);
conn.Open();
return cmd.ExecuteReader();
}
///
/// 更新操作
///
///
///
public int update(string sql)
{
if (conn == null)
{
conn = getConnection();
}
cmd = new SqlCommand(sql, conn);
conn.Open();
int i = cmd.ExecuteNonQuery();
return i;
}
///
/// 给定sql语句，返回结构集
///
///
///
public DataSet executeDataSet(string sql)
{
if (conn == null)
{
conn = getConnection();
}
cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(
《Android学习笔记总结+最新移动架构视频+大厂安卓面试真题+项目实战源码讲义》
【docs.qq.com/doc/DSkNLaERkbnFoS0ZF】 完整内容开源分享
ds);
return ds;
}
///
/// 关闭数据库连接
///
public void close()
{
if (conn != null)
{
conn.Close();
}
}
}
6、? 新建index.aspx页面,在此页面中通过datalist控件来显示goods_info表中每个商品的商品的名称、价格、上传日期和图片，并在每个商品的下面添加一个按钮，当单击按钮时，弹出对话框显示该按钮被单击的次数。(Done)
界面代码：
<%@ Page Language=“C#” AutoEventWireup=“true” CodeFile=“index.aspx.cs” Inherits=“goodsnum” %>
<asp:SqlDataSource ID=“SqlDataSource1” runat=“server”
ConnectionString=“Data Source=.\SQLEXPRESS;AttachDbFilename=“D:\My Documents\Test.mdf”;Integrated Security=True;Connect Timeout=30;User Instance=True”
ProviderName=“System.Data.SqlClient” SelectCommand=“SELECT * FROM [goods_info]”>
</asp:SqlDataSource>
<asp:DataList ID=“DataList1” runat=“server” DataSourceID=“SqlDataSource1”
RepeatColumns=“3” RepeatDirection=“Horizontal” onitemcommand=“DataList1_ItemCommand”
<asp:Image ID=“Image1” runat=“server” Height=“108px”
ImageUrl=’<%# Eval(“goods_images”) %>’ Width=“227px” />
名称：
<asp:Label ID=“Label1” runat=“server” Text=’<%# Eval(“goods_name”) %>’></asp:Label>
价格：
<asp:Label ID=“Label2” runat=“server” Text=’<%# Eval(“goods_price”) %>’></asp:Label>
上传日期：
<asp:Label ID=“Label3” runat=“server” Text=’<%# Eval(“goods_date”) %>’></asp:Label>
<asp:Button ID=“Button1” runat=“server” Text=“显示点击次数”
CommandArgument=’<%# Eval(“goods_id”) %>’ />
</asp:DataList>
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
string id = e.CommandArgument.ToString();
Hashtable ht;
if (Session[“count”] == null)
{
ht = new Hashtable();
ht.Add(id, 1);
Session[“count”] = ht;
}
else
{
ht = (Hashtable)Session[“count”];
if (ht.Contains(id))
{
int count = int.Parse(ht[id].ToString());
ht[id] = count + 1;
Session[“count”] = ht;
Response.Write(“”);
}
else
{
ht.Add(id, 1);
Session[“count”] = ht;
}
}
7、? 新建goodsnum.aspx页面，在此页面的Page_Load事件中，首先定义一个DataTable,分别包含三列
列名??? 类型
name??string
price???float
num???int
并编程在此表中添加三条记录。通过GridView显示此表中的数据。(Done)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
using System.Data;
public partial class index : System.Web.UI.Page
{
private DataTable dt;
protected void Page_Load(object sender, EventArgs e)
{
/**定义一个DataTable,分别包含三列
列名 类型
name string
price float
num int
**/
dt = new DataTable();
DataColumn col = new DataColumn();
col.ColumnName = “name”;
col.DataType = System.Type.GetType(“System.String”);
dt.Columns.Add(col);
col = new DataColumn();
col.ColumnName = “price”;
col.DataType = System.Type.GetType(“System.Single”);
dt.Columns.Add(col);
col = new DataColumn();
col.ColumnName = “num”;
col.DataType = System.Type.GetType(“System.Int32”);
dt.Columns.Add(col);
Bind();
}
///
/// 通过编程来实现往DataTable里添加数据，并绑定到GridView当中
///
public void Bind()
{
DataRow row = dt.NewRow();
row[“name”] = “zhangsan”;
row[“price”] = 11.0f;
row[“num”] = 10;
dt.Rows.Add(row);
row = dt.NewRow();
row[“name”] = “lishi”;
row[“price”] = 12.0f;