您現(xiàn)在的位置： 365建站網(wǎng) > 365文章 > 關(guān)于DropDownList ， GridView的一道測試題

關(guān)于DropDownList ， GridView的一道測試題

文章來源：365jz.com 點擊數(shù)：656 更新時間：2009-11-09 22:40 參與評論

一、數(shù)據(jù)庫

提供數(shù)據(jù)庫db_Shop，其中有兩張表：一是商品類別表T_GoodsType；二是商品信息表T_GoodsInfo,兩張表的結(jié)構(gòu)為：

T_GoodsType：

字段名稱	類型	備注
TypeID	Int	主鍵，類別id
TypeName	Varchar（50）	類別名稱

T_ GoodsInfo：

字段名稱	類型	備注
GoodsID	Int	主鍵，商品id
TypeID	Int	商品類別id
GoodsName	Varchar（50）	商品名稱
GoodsPrice	Float	商品價格

二、需要實現(xiàn)的功能

1、添加商品（15分）

2、使用GridView顯示所有商品列表（15分）

3、可以按商品類別顯示商品列表（15分）

4、修改商品單價（15分）

5、刪除一件商品（10分）

三、考試要求：

1、對頁面樣式無要求；

2、封裝數(shù)據(jù)庫訪問類（10分）

3、其中【修改商品單價】要求使用存儲過程實現(xiàn)；（10分）

4、良好的編碼規(guī)范，包括：命名、注釋等；（10分）

5、總分100分，每部分占得分數(shù)已在后面標出；

6、做完之后打包QQ發(fā)給我，壓縮包命名方式：“ADO.NET測試_張三”

四、功能截圖

顯示所有商品：

顯示顯示器類商品：

修改商品單價：

可以刪除某個商品：

添加商品：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Shop</title> </head> <body> <form id="form1" runat="server"> <div> <asp:Label ID="lbShowShop" runat="server" Text="商品類別:" ForeColor="red"></asp:Label> <asp:DropDownList ID="DdlSelect" runat="server" AutoPostBack="true" onselectedindexchanged="DdlSelect_SelectedIndexChanged" AppendDataBoundItems="true" > </asp:DropDownList> <asp:Button ID="btShowGoods" runat="server" Text="搜索" onclick="btShowGoods_Click" /> <br /> <asp:GridView ID="Gv_Show" runat="server" BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4" style="width: 500px" Width="211px" Height="168px" DataKeyNames="GoodsID" AutoGenerateColumns="False" onrowcancelingedit="Gv_Show_RowCancelingEdit" onrowediting="Gv_Show_RowEditing" onrowupdating="Gv_Show_RowUpdating" onrowcommand="Gv_Show_RowCommand" > <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" /> <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" /> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" /> <RowStyle BackColor="White" ForeColor="#330099" /> <Columns> <asp:BoundField HeaderText="商品類別" DataField="TypeName" ReadOnly="true"/> <asp:BoundField DataField="GoodsName" HeaderText="商品名稱" ReadOnly="true" /> <asp:BoundField DataField="GoodsPrice" HeaderText="商品價格" /> <asp:CommandField ShowEditButton="true" HeaderText="編輯"/> <asp:TemplateField HeaderText="刪除"> <ItemTemplate> <asp:LinkButton ID="lbdel" runat="server" CommandName="del" CommandArgument='<%#Eval("GoodsID") %>'>Delete</asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> <br /> <br /> <asp:Label ID="lbAdd" runat="server" Text="添加商品:" ForeColor="red"></asp:Label> <br /> 商品類別: <asp:DropDownList ID="DdlSelect1" runat="server" AutoPostBack="true"> </asp:DropDownList><hr/> <br /> 商品名稱: <asp:TextBox ID="tbGoodsName" runat="server"></asp:TextBox><hr /> <br /> 商品單價: <asp:TextBox ID="tbGoodsPrice" runat="server"></asp:TextBox> <br /> <div align="left" style=" padding-left:150px" mce_style=" padding-left:150px"><asp:Button ID="btAddGoods" runat="server" Text="確定" onclick="btAddGoods_Click" /></div> <hr/> </span> </div> </form> </body> </html>

后臺代碼：

using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DdlBind(); DdlBindForSelect1(); GvBind(); } } /// <summary> /// 定義數(shù)據(jù)庫連接方法 /// </summary> /// <returns></returns> public SqlHelper OpenConnection() { SqlHelper helper = new SqlHelper(@"Data Source=A102-35\SQLEXPRESS;Initial Catalog=db_Shop;Integrated Security=True"); return helper; } /// <summary> /// 搜索下拉框的綁定方法 /// </summary> public void DdlBind() { SqlHelper helper = OpenConnection(); //創(chuàng)建查詢字符串 string strQry = @"select * from T_GoodsType"; //返回數(shù)據(jù)表 DdlSelect.DataSource = helper.RunProcDataTable(strQry); DdlSelect.Items.Add(new ListItem("顯示全部","all")); //綁定文本域 DdlSelect.DataTextField = "TypeName"; //綁定主鍵域 DdlSelect.DataValueField = "TypeID"; //綁定下拉框控件 DdlSelect.DataBind( ); } /// <summary> /// 添加商品下拉框的數(shù)據(jù)綁定 /// </summary> public void DdlBindForSelect1() { SqlHelper helper = OpenConnection(); //創(chuàng)建查詢字符串 string strQry = @"select * from T_GoodsType"; //返回數(shù)據(jù)表 DdlSelect1.DataSource = helper.RunProcDataTable(strQry); //綁定文本域 DdlSelect1.DataTextField = "TypeName"; //綁定主鍵域 DdlSelect1.DataValueField = "TypeID"; //綁定下拉框控件 DdlSelect1.DataBind(); } /// <summary> /// 數(shù)據(jù)列表的綁定方法 /// </summary> public void GvBind() { SqlHelper helper = OpenConnection(); //創(chuàng)建查詢字符串 string strQry = @"select * from T_GoodsInfo,T_GoodsType where T_GoodsInfo.TypeID=T_GoodsType.TypeID Order By T_GoodsType.TypeName"; //返回數(shù)據(jù)表 Gv_Show.DataSource = helper.RunProcDataTable(strQry); Gv_Show.DataBind(); } /// <summary> /// 獲得TypeID的數(shù)據(jù)列表綁定 /// </summary> /// <param name="str"></param> public void GvBind(string str) { SqlHelper helper = OpenConnection(); string strVar = str; //創(chuàng)建查詢字符串 string strQry = @"select * from T_GoodsInfo,T_GoodsType where T_GoodsInfo.TypeID=T_GoodsType.TypeID and T_GoodsInfo.TypeID='" + strVar + "'"; //返回數(shù)據(jù)表 Gv_Show.DataSource = helper.RunProcDataTable(strQry); Gv_Show.DataBind(); } ///// <summary> ///// 下拉框處理事件 ///// </summary> ///// <param name="sender"></param> ///// <param name="e"></param> protected void DdlSelect_SelectedIndexChanged(object sender, EventArgs e) { //如果為新表，則直接退出事件 if (DdlSelect.SelectedValue == null) { return; } //選擇查看全部商品，否則為選擇某件商品查看 if (DdlSelect.SelectedValue == "all") { GvBind(); } else { GvBind(DdlSelect.SelectedValue); } } /// <summary> /// 數(shù)據(jù)列表行編輯 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Gv_Show_RowEditing(object sender, GridViewEditEventArgs e) { Gv_Show.EditIndex = e.NewEditIndex; //該屬性獲取或設(shè)置所編輯的行的索引 //選擇查看全部商品，否則為選擇某件商品查看 if (DdlSelect.SelectedValue == "all") { GvBind(); } else { GvBind(DdlSelect.SelectedValue); } } /// <summary> /// 數(shù)據(jù)列表行編輯更新操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Gv_Show_RowUpdating(object sender, GridViewUpdateEventArgs e) { SqlHelper helper = OpenConnection(); string price = ((TextBox)(Gv_Show.Rows[e.RowIndex].Cells[2].Controls[0])).Text; //獲得更新行 int goodsid = Convert.ToInt32(Gv_Show.DataKeys[e.RowIndex].Value); //獲得主鍵 SqlParameter[] para ={new SqlParameter ("@price",SqlDbType.Float), //添加命令變量 new SqlParameter("@goodsid",SqlDbType.Int) }; para[0].Value = float.Parse(price); para[1].Value = goodsid; string sqlStr = "update T_GoodsInfo set GoodsPrice = @price where GoodsID= @goodsid"; //跟新語句 //執(zhí)行跟新操作 helper.RunSQL(sqlStr, para); if (DdlSelect.SelectedValue == "all") { GvBind(); } else { GvBind(DdlSelect.SelectedValue); } } /// <summary> /// 數(shù)據(jù)列表行編輯取消操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Gv_Show_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { Gv_Show.EditIndex = -1; if (DdlSelect.SelectedValue == "all") { GvBind(); } else { GvBind(DdlSelect.SelectedValue); } } /// <summary> /// 數(shù)據(jù)列表行刪除操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Gv_Show_RowCommand(object sender, GridViewCommandEventArgs e) { //刪除指定行的商品 if (e.CommandName == "del") { SqlHelper helper = OpenConnection(); string delStr = @"delete from T_GoodsInfo where GoodsID='" + e.CommandArgument.ToString() + "'"; //執(zhí)行刪除操作 helper.RunSQL(delStr); //選擇查看全部商品，否則為選擇某件商品查看 if (DdlSelect.SelectedValue == "all") { GvBind(); } else { GvBind(DdlSelect.SelectedValue); } } } /// <summary> /// 搜索商品事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btShowGoods_Click(object sender, EventArgs e) { //如果為新表，則直接退出 if (DdlSelect.SelectedValue == null) { return; } //選擇查看全部商品，否則為選擇某件商品查看 if (DdlSelect.SelectedValue == "all") { GvBind(); } else { GvBind(DdlSelect.SelectedValue); } } /// <summary> /// 添加商品事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btAddGoods_Click(object sender, EventArgs e) { SqlHelper helper = OpenConnection(); //添加命令參數(shù) SqlParameter[] para ={ new SqlParameter("@typeid",SqlDbType.Int), new SqlParameter("@goodsname",SqlDbType.VarChar,50), new SqlParameter("@goodsprice",SqlDbType.Float) }; para[0].Value = DdlSelect1.SelectedValue; para[0].Direction = ParameterDirection.Input; para[1].Value = tbGoodsName.Text.Trim(); para[1].Direction = ParameterDirection.Input; para[2].Value = tbGoodsPrice.Text.Trim(); para[2].Direction = ParameterDirection.Input; //如果返回受影響的行數(shù)，則添加成功，否則添加失敗 if ((int)(helper.RunSQL("proc_AddGoods", CommandType.StoredProcedure, para)) == 1) { Response.Write("<mce:script type="text/javascript"></mce:script>"); tbGoodsName.Text = ""; tbGoodsPrice.Text = ""; } else { Response.Write("<mce:script type="text/javascript"></mce:script>"); } } }

另一種較簡潔的做法：

using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DdlBind(); DdlBindForSelect1(); GvBind(); } } /// <summary> /// 定義數(shù)據(jù)庫連接方法 /// </summary> /// <returns></returns> public SqlHelper OpenConnection() { SqlHelper helper = new SqlHelper(@"Data Source=A102-35\SQLEXPRESS;Initial Catalog=db_Shop;Integrated Security=True"); return helper; } /// <summary> /// 搜索下拉框的綁定方法 /// </summary> public void DdlBind() { SqlHelper helper = OpenConnection(); //創(chuàng)建查詢字符串 string strQry = @"select * from T_GoodsType"; //返回數(shù)據(jù)表 DdlSelect.DataSource = helper.RunProcDataTable(strQry); DdlSelect.Items.Add(new ListItem("顯示全部", "all")); //綁定文本域 DdlSelect.DataTextField = "TypeName"; //綁定主鍵域 DdlSelect.DataValueField = "TypeID"; //綁定下拉框控件 DdlSelect.DataBind(); } /// <summary> /// 添加商品下拉框的數(shù)據(jù)綁定 /// </summary> public void DdlBindForSelect1() { SqlHelper helper = OpenConnection(); //創(chuàng)建查詢字符串 string strQry = @"select * from T_GoodsType"; //返回數(shù)據(jù)表 DdlSelect1.DataSource = helper.RunProcDataTable(strQry); //綁定文本域 DdlSelect1.DataTextField = "TypeName"; //綁定主鍵域 DdlSelect1.DataValueField = "TypeID"; //綁定下拉框控件 DdlSelect1.DataBind(); } /// <summary> /// 數(shù)據(jù)列表的綁定方法 /// </summary> public void GvBind() { SqlHelper helper = OpenConnection(); //創(chuàng)建查詢字符串 string strQry = @"select * from T_GoodsInfo,T_GoodsType where T_GoodsInfo.TypeID=T_GoodsType.TypeID "; int DdlgetValue = Convert.ToInt32(DdlSelect.SelectedValue); //判斷直接寫在一個綁定方法里 if (DdlSelect.SelectedValue != "all") { strQry += "and T_GoodsInfo.TypeID='" + DdlgetValue; } //返回數(shù)據(jù)表 Gv_Show.DataSource = helper.RunProcDataTable(strQry); Gv_Show.DataBind(); } ///// <summary> ///// 下拉框處理事件 ///// </summary> ///// <param name="sender"></param> ///// <param name="e"></param> protected void DdlSelect_SelectedIndexChanged(object sender, EventArgs e) { //如果為新表，則直接退出事件 if (DdlSelect.SelectedValue == null) { return; } //綁定列表 GvBind(); } /// <summary> /// 數(shù)據(jù)列表行編輯 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Gv_Show_RowEditing(object sender, GridViewEditEventArgs e) { Gv_Show.EditIndex = e.NewEditIndex; //該屬性獲取或設(shè)置所編輯的行的索引 GvBind(); } /// <summary> /// 數(shù)據(jù)列表行編輯更新操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Gv_Show_RowUpdating(object sender, GridViewUpdateEventArgs e) { SqlHelper helper = OpenConnection(); string price = ((TextBox)(Gv_Show.Rows[e.RowIndex].Cells[2].Controls[0])).Text; //獲得更新行 int goodsid = Convert.ToInt32(Gv_Show.DataKeys[e.RowIndex].Value); //獲得主鍵 SqlParameter[] para ={new SqlParameter ("@price",SqlDbType.Float), //添加命令變量 new SqlParameter("@goodsid",SqlDbType.Int) }; para[0].Value = float.Parse(price); para[1].Value = goodsid; string sqlStr = "update T_GoodsInfo set GoodsPrice = @price where GoodsID= @goodsid"; //跟新語句 //執(zhí)行跟新操作 helper.RunSQL(sqlStr, para); GvBind(); } /// <summary> /// 數(shù)據(jù)列表行編輯取消操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Gv_Show_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { Gv_Show.EditIndex = -1; GvBind(); } /// <summary> /// 數(shù)據(jù)列表行刪除操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Gv_Show_RowCommand(object sender, GridViewCommandEventArgs e) { //刪除指定行的商品 if (e.CommandName == "del") { SqlHelper helper = OpenConnection(); string delStr = @"delete from T_GoodsInfo where GoodsID='" + e.CommandArgument.ToString() + "'"; //執(zhí)行刪除操作 helper.RunSQL(delStr); GvBind(); } } /// <summary> /// 搜索商品事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btShowGoods_Click(object sender, EventArgs e) { //如果為新表，則直接退出 if (DdlSelect.SelectedValue == null) { return; } GvBind(); } /// <summary> /// 添加商品事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btAddGoods_Click(object sender, EventArgs e) { SqlHelper helper = OpenConnection(); //添加命令參數(shù) SqlParameter[] para ={ new SqlParameter("@typeid",SqlDbType.Int), new SqlParameter("@goodsname",SqlDbType.VarChar,50), new SqlParameter("@goodsprice",SqlDbType.Float) }; para[0].Value = DdlSelect1.SelectedValue; para[0].Direction = ParameterDirection.Input; para[1].Value = tbGoodsName.Text.Trim(); para[1].Direction = ParameterDirection.Input; para[2].Value = tbGoodsPrice.Text.Trim(); para[2].Direction = ParameterDirection.Input; //如果返回受影響的行數(shù)，則添加成功，否則添加失敗 if ((int)(helper.RunSQL("proc_AddGoods", CommandType.StoredProcedure, para)) == 1) { Response.Write("<mce:script type="text/javascript"></mce:script>"); tbGoodsName.Text = ""; tbGoodsPrice.Text = ""; } else { Response.Write("<mce:script type="text/javascript"></mce:script>"); } } }

數(shù)據(jù)庫封裝類：

using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; /// <summary> ///Sql 的摘要說明 /// </summary> public class SqlHelper { private string ConnStr = null; private SqlConnection Conn = null; /// <summary> /// 無參構(gòu)造函數(shù) /// </summary> public SqlHelper() { try { ConnStr = ConfigurationManager.ConnectionStrings["db_Shop"].ConnectionString; Conn = new SqlConnection(ConnStr); Conn.Open(); } catch (Exception ex) { throw ex; } } /// <summary> /// 帶連接字符串構(gòu)造函數(shù) /// </summary> /// <param name="Str"></param> public SqlHelper(string Str) { try { this.ConnStr = Str; Conn = new SqlConnection(ConnStr); Conn.Open(); } catch (Exception ex) { throw ex; } } /// <summary> /// 打開數(shù)據(jù)庫連接 /// </summary> public void OpenConn() { if (Conn == null) { Conn.Open(); } } /// <summary> /// 關(guān)閉連接 /// </summary> public void Dispose() { if (Conn != null) { Conn.Close(); Conn.Dispose(); } GC.Collect(); } /// <summary> /// 生成Command對象 /// </summary> /// <param name="SQL">SQL語句</param> /// <returns>SqlCommand對象</returns> public SqlCommand CreateCmd(string SQL) { SqlCommand Cmd; Cmd = new SqlCommand(SQL, Conn); return Cmd; } /// <summary> /// 調(diào)用存儲過程的Command對象，用于查詢 /// </summary> /// <param name="procname">存儲過程</param> /// <param name="i">CommandType.StoredProcedure屬性值</param> /// <returns>SqlCommand對象</returns> public SqlCommand CreateCmd(string procname, CommandType i) { SqlCommand Cmd= new SqlCommand(); try { Cmd.Connection = Conn; Cmd.CommandType = i; Cmd.CommandText = procname; } catch(Exception Err) { throw Err; } return Cmd; } /// <summary> /// 運行SQL語句執(zhí)行插入，刪除，跟新操作 /// </summary> /// <param name="SQL">SQL語句</param> public int RunSQL(string SQL) { SqlCommand Cmd; Cmd = CreateCmd(SQL); int result; try { result=Cmd.ExecuteNonQuery(); } catch { throw new Exception(SQL); } Dispose(); return result; } /// <summary> /// 運行SQL語句執(zhí)行插入，刪除，跟新操作 /// </summary> /// <param name="SQL">SQL語句</param> /// <param name="pa">命令變量元素</param> public int RunSQL(string SQL, SqlParameter[] pa) { SqlCommand Cmd; Cmd = CreateCmd(SQL); int result; for (int i = 0; i < pa.Length; i++) { Cmd.Parameters.Add(pa[i]); } try { result=Cmd.ExecuteNonQuery(); } catch { throw new Exception(SQL); } Dispose(); return result; } /// <summary> /// 調(diào)用存儲過程的SQL語句 /// </summary> /// <param name="procname">存儲過程</param> /// <param name="i">CommandType.StoredProcedure屬性值</param> /// <param name="pa">命令變量元素</param> public result RunSQL(string procname, CommandType i, SqlParameter[] pa) { SqlCommand Cmd; Cmd = CreateCmd(procname,i); int result; for (int j = 0; j < pa.Length; j++) { Cmd.Parameters.Add(pa[j]); } try { result=Cmd.ExecuteNonQuery(); } catch { throw new Exception(procname); } Dispose(); return result; } /// <summary> /// 運行SQL語句返回DataReader /// </summary> /// <param name="SQL">SQL語句</param> /// <returns>SqlDataReader對象.</returns> public SqlDataReader RunProcGetReader(string SQL) { SqlCommand Cmd; Cmd = CreateCmd(SQL); SqlDataReader Dr; try { Dr = Cmd.ExecuteReader(); } catch { throw new Exception(SQL); } //Dispose(Conn); return Dr; } /// <summary> /// 調(diào)用存儲過程返回DataReader /// </summary> /// <param name="procname">存儲過程</param> /// <param name="i">CommandType.StoredProcedure屬性值</param> /// <returns>SqlDataReader對象</returns> public SqlDataReader RunProcGetReader(string procname, CommandType i) { SqlCommand Cmd; Cmd = CreateCmd(procname,i); SqlDataReader Dr; try { Dr = Cmd.ExecuteReader(); } catch { throw new Exception(procname); } //Dispose(Conn); return Dr; } /// <summary> /// 返回adapter對象 /// </summary> /// <param name="SQL">SQL語句</param> /// <returns>SqlDataAdapter對象</returns> public SqlDataAdapter CreateAdapter(string SQL) { SqlDataAdapter Da; Da = new SqlDataAdapter(CreateCmd(SQL)); return Da; } /// <summary> /// 調(diào)用存儲過程返回adapter對象 /// </summary> /// <param name="procname">存儲過程</param> /// <param name="i">CommandType.StoredProcedure屬性值</param> /// <returns>SqlDataAdapter對象</returns> public SqlDataAdapter CreateAdapter(string procname, CommandType i) { SqlDataAdapter Da; Da = new SqlDataAdapter(CreateCmd(procname, i)); return Da; } /// <summary> /// 填充數(shù)據(jù)集,，返回dataset對象 /// </summary> /// <param name="SQL">SQL語句</param> /// <returns>DataSet對象</returns> public DataSet RunProcDataSet(string SQL) { SqlDataAdapter Da; Da = CreateAdapter(SQL); DataSet Ds = new DataSet(); try { Da.Fill(Ds); } catch (Exception Err) { throw Err; } Dispose(); return Ds; } /// <summary> /// 填充數(shù)據(jù)集,，返回dataset對象 /// </summary> /// <param name="SQL">SQL語句</param> /// <param name="tablename">表名</param> /// <returns>DataSet對象</returns> public DataSet RunProcDataSet(string SQL, string tablename) { SqlDataAdapter Da; Da = CreateAdapter(SQL); DataSet Ds = new DataSet(); try { Da.Fill(Ds, tablename); } catch (Exception Err) { throw Err; } Dispose(); return Ds; } /// <summary> /// 調(diào)用存儲過程填充數(shù)據(jù)集,返回DataSet對象 /// </summary> /// <param name="procname">存儲過程</param> /// <param name="i">CommandType.StoredProcedure屬性值</param> /// <param name="tablename">表名</param> /// <returns>DataSet對象</returns> public DataSet RunProcDataSet(string procname, CommandType i, string tablename) { SqlDataAdapter Da; Da = CreateAdapter(procname ,i); DataSet Ds = new DataSet(); try { Da.Fill(Ds, tablename); } catch (Exception Err) { throw Err; } Dispose(); return Ds; } /// <summary> /// 返回DataTable對象 /// </summary> /// <param name="SQL">SQL語句</param> /// <returns>DataTable對象</returns> public DataTable RunProcDataTable(string SQL) { DataTable dt = RunProcDataSet(SQL).Tables[0]; return dt; } /// <summary> /// 返回DataTable對象 /// </summary> /// <param name="SQL">SQL語句</param> /// <param name="tablename">表名</param> /// <returns>DataTable對象</returns> public DataTable RunProcDataTable(string SQL, string tablename) { DataTable dt = RunProcDataSet(SQL, tablename).Tables[tablename]; return dt; } /// <summary> /// 調(diào)用存儲過程返回DataTable對象 /// </summary> /// <param name="procname">存儲過程</param> /// <param name="i">CommandType.StoredProcedure屬性值</param> /// <param name="tablename">表名</param> /// <returns>DataSet對象</returns> public DataTable RunProcDataTable(string procname, CommandType i, string tablename) { DataTable dt = RunProcDataSet(procname,i, tablename).Tables[tablename]; return dt; } }

存儲過程：

create proc dbo.proc_AddGoods ( @typeid int, @goodsname varchar(50), @goodsprice float ) as --添加商品 insert into T_GoodsInfo(TypeID,GoodsName,GoodsPrice) values(@typeid,@goodsname,@goodsprice) go

如對本文有疑問，請?zhí)峤坏浇涣髡搲?，廣大熱心網(wǎng)友會為你解答?。?點擊進入論壇