9///COperator的摘要說明。10///11publicclassCOperator12{13publicCOperator()14{15//16/" />

欧美三区_成人在线免费观看视频_欧美极品少妇xxxxⅹ免费视频_a级毛片免费播放_鲁一鲁中文字幕久久_亚洲一级特黄

Add/Delete/Update

系統 2056 0

首先是數據訪問層的代碼:

??1 using ?System;
??2 using ?System.Data;
??3 using ?System.Data.SqlClient;
??4 using ?System.Configuration;
??5
??6 namespace ?WebTest.Common
??7 {
??8 ???? /// ? <summary>
??9 ???? /// ?COperator?的摘要說明。
?10 ???? /// ? </summary>
?11 ???? public ? class ?COperator
?12 ???? {
?13 ???????? public ?COperator()
?14 ???????? {
?15 ???????????? //
?16 ???????????? // ?TODO:?在此處添加構造函數邏輯
?17 ???????????? //
?18 ????????}
?19 ???????? public ?DataSet?HaveParameter( string ?StrProcedure)
?20 ???????? {
?21 ????????????SqlConnection?MyConnection? = ? new ?SqlConnection(ConfigurationSettings.AppSettings[ " ConnectionSqlServer " ]);
?22 ????????????SqlCommand?MyCommand? = ? new ?SqlCommand();
?23 ????????????MyCommand.Connection? = ?MyConnection;
?24 ????????????MyCommand.CommandType? = ?CommandType.StoredProcedure;
?25 ????????????MyCommand.CommandText? = ?StrProcedure;
?26
?27
?28 ????????????SqlDataAdapter?MyAdapter? = ? new ?SqlDataAdapter();
?29 ????????????
?30 ????????????MyAdapter.SelectCommand = ?MyCommand;
?31
?32 ????????????DataSet?Ds? = ? new ?DataSet();
?33
?34 ???????????? if ?(MyConnection.State == System.Data.ConnectionState.Closed)
?35 ???????????? {
?36 ????????????????MyConnection.Open();
?37 ????????????}
?38 ???????????? // ?啟動一個事務
?39 ????????????SqlTransaction?MyTrans? = ?MyConnection.BeginTransaction();
?40
?41 ???????????? // ?initialize?command?object
?42 ????????????MyCommand.Transaction? = ?MyTrans;
?43
?44 ???????????? try
?45 ???????????? {
?46 ???????????????? // ?進行數據庫操作
?47 ????????????????MyAdapter.Fill(Ds);
?48 ????????????????MyTrans.Commit();
?49 ????????????}
?50 ???????????? catch
?51 ???????????? {
?52 ????????????????MyTrans.Rollback();
?53 ????????????}
?54 ???????????? finally
?55 ???????????? {
?56 ????????????????MyConnection.Close();
?57 ????????????}
?58
?59 ???????????? return ?Ds;
?60 ????????}
?61
?62 ???????? public ? void ?NoReturnFunction( string ?StrParameter,? string ?StrField,? string ?StrProcedure)
?63 ???????? {
?64 ???????????? // ?創建數據庫連接和命令的對象
?65 ????????????SqlConnection?myConnection? = ? new ?SqlConnection(ConfigurationSettings.AppSettings[ " ConnectionSqlServer " ]);
?66 ????????????
?67 ????????????SqlCommand?myCommand? = ? new ?SqlCommand(StrProcedure,?myConnection);
?68
?69 ???????????? // ?指明Sql命令的操作類型是使用存儲過程
?70 ????????????myCommand.CommandType? = ?CommandType.StoredProcedure;
?71
?72 ????????????SqlParameter?parameterStr? = ? new ?SqlParameter(StrField,?SqlDbType.VarChar,? 500 );
?73 ????????????parameterStr.Value? = ?StrParameter;
?74 ????????????myCommand.Parameters.Add(parameterStr);
?75
?76 ???????????? // ?打開數據庫連接
?77 ???????????? if ?(myConnection.State == System.Data.ConnectionState.Closed)
?78 ???????????? {
?79 ????????????????myConnection.Open();
?80 ????????????}
?81
?82 ???????????? // ?啟動一個事務
?83 ????????????SqlTransaction?MyTrans? = ?myConnection.BeginTransaction();
?84
?85 ???????????? // ?initialize?command?object
?86 ????????????myCommand.Transaction? = ?MyTrans;
?87
?88 ???????????? try
?89 ???????????? {
?90 ???????????????? // ?進行數據庫操作
?91 ????????????????myCommand.ExecuteNonQuery();
?92 ????????????????MyTrans.Commit();
?93 ????????????}
?94 ???????????? catch
?95 ???????????? {
?96 ????????????????MyTrans.Rollback();
?97 ????????????}
?98 ???????????? finally
?99 ???????????? {
100 ???????????????? // ?關閉數據庫連接
101 ????????????????myConnection.Close();
102 ????????????} ????
103 ????????}
104
105 ???????? // ?2參數
106 ???????? public ? void ?NoReturnFunction( string ?StrParameter1,? string ?StrField1,? string ?StrParameter2,? string ?StrField2,? string ?StrProcedure)
107 ???????? {
108 ???????????? // ?創建數據庫連接和命令的對象
109 ????????????SqlConnection?myConnection? = ? new ?SqlConnection(ConfigurationSettings.AppSettings[ " ConnectionSqlServer " ]);
110 ????????????
111 ????????????SqlCommand?myCommand? = ? new ?SqlCommand(StrProcedure,?myConnection);
112
113 ???????????? // ?指明Sql命令的操作類型是使用存儲過程
114 ????????????myCommand.CommandType? = ?CommandType.StoredProcedure;
115
116 ????????????SqlParameter?parameterStr1? = ? new ?SqlParameter(StrField1,?SqlDbType.NVarChar,? 50 );
117 ????????????parameterStr1.Value? = ?StrParameter1;
118 ????????????myCommand.Parameters.Add(parameterStr1);
119
120 ????????????SqlParameter?parameterStr2? = ? new ?SqlParameter(StrField2,?SqlDbType.NVarChar,? 50 );
121 ????????????parameterStr2.Value? = ?StrParameter2;
122 ????????????myCommand.Parameters.Add(parameterStr2);
123
124 ???????????? // ?打開數據庫連接
125 ???????????? if ?(myConnection.State == System.Data.ConnectionState.Closed)
126 ???????????? {
127 ????????????????myConnection.Open();
128 ????????????}
129
130 ???????????? // ?啟動一個事務
131 ????????????SqlTransaction?MyTrans? = ?myConnection.BeginTransaction();
132
133 ???????????? // ?initialize?command?object
134 ????????????myCommand.Transaction? = ?MyTrans;
135
136 ???????????? try
137 ???????????? {
138 ???????????????? // ?進行數據庫操作
139 ????????????????myCommand.ExecuteNonQuery();
140 ????????????????MyTrans.Commit();
141 ????????????}
142 ???????????? catch
143 ???????????? {
144 ????????????????MyTrans.Rollback();
145 ????????????}
146 ???????????? finally
147 ???????????? {
148 ???????????????? // ?關閉數據庫連接
149 ????????????????myConnection.Close();
150 ????????????} ????
151
152 ????????}
153 ????}
154 }
155

Add:
?1 using ?System;
?2 using ?System.Collections;
?3 using ?System.ComponentModel;
?4 using ?System.Data;
?5 using ?System.Drawing;
?6 using ?System.Web;
?7 using ?System.Web.SessionState;
?8 using ?System.Web.UI;
?9 using ?System.Web.UI.WebControls;
10 using ?System.Web.UI.HtmlControls;
11
12 namespace ?WebTest
13 {
14 ???? /// ? <summary>
15 ???? /// ?AddInfo?的摘要說明。
16 ???? /// ? </summary>
17 ???? public ? class ?AddInfo?:?System.Web.UI.Page
18 ???? {
19 ???????? protected ?System.Web.UI.WebControls.Button?BtOk;
20 ???????? protected ?System.Web.UI.WebControls.TextBox?TextBox1;
21 ????
22 ???????? private ? void ?Page_Load( object ?sender,?System.EventArgs?e)
23 ???????? {
24 ???????????? // ?在此處放置用戶代碼以初始化頁面
25 ????????}
26
27 ???????? Web?窗體設計器生成的代碼
48
49 ???????? private ? void ?BtOk_Click( object ?sender,?System.EventArgs?e)
50 ???????? {
51 ????????????WebTest.Common.COperator?AddObj? = ? new ?WebTest.Common.COperator();
52 ????????????AddObj.NoReturnFunction(TextBox1.Text,? " @StrTValues " ,? " TS_AddValuesIntoTb " );
53 ????????}
54
55 ????}
56 }
57

Edit/Delete with DataGrid:
??1 using ?System;
??2 using ?System.Collections;
??3 using ?System.ComponentModel;
??4 using ?System.Data;
??5 using ?System.Drawing;
??6 using ?System.Web;
??7 using ?System.Web.SessionState;
??8 using ?System.Web.UI;
??9 using ?System.Web.UI.WebControls;
?10 using ?System.Web.UI.HtmlControls;
?11
?12 namespace ?WebTest
?13 {
?14 ???? /// ? <summary>
?15 ???? /// ?_Default?的摘要說明。
?16 ???? /// ? </summary>
?17 ???? public ? class ?_Default?:?System.Web.UI.Page
?18 ???? {
?19 ???????? protected ?System.Web.UI.WebControls.DataGrid?DataGrid1;
?20 ????
?21 ???????? private ? void ?Page_Load( object ?sender,?System.EventArgs?e)
?22 ???????? {
?23 ???????????? // ?在此處放置用戶代碼以初始化頁面
?24 ???????????? if ?( ! IsPostBack)
?25 ???????????? {
?26 ????????????????MyDataBind();
?27 ????????????}
?28 ????????}
?29
?30 ???????? Web?窗體設計器生成的代碼
?53
?54 ???????? private ? void ?MyDataBind()
?55 ???????? {
?56 ????????????WebTest.Common.COperator?ShowObj? = ? new ?WebTest.Common.COperator();
?57 ????????????DataGrid1.DataSource? = ?ShowObj.HaveParameter( " SearchAllInfoFromTb " );
?58 ????????????DataGrid1.DataBind();
?59 ????????}
?60
?61 ???????? public ? void ?BtEdit( object ?sender,?System.Web.UI.WebControls.CommandEventArgs?e)
?62 ???????? {
?63 ???????????? string ?Str? = ?e.CommandArgument.ToString();
?64 ???????????? // ?Response.Write("<script>alert('xx')</script>");
?65 ????????????Response.Write(Str);
?66 ????????}
?67
?68 ???????? public ? void ?BtDelete( object ?sender,?System.Web.UI.WebControls.CommandEventArgs?e)
?69 ???????? {
?70 ????????????WebTest.Common.COperator?DeleteObj? = ? new ?WebTest.Common.COperator();
?71 ????????????DeleteObj.NoReturnFunction(e.CommandArgument.ToString(),? " @StrID " ,? " TS_DeleteInfoFromTb " );
?72 ????????????MyDataBind();
?73 ????????}
?74
?75 ???????? private ? void ?DataGrid1_EditCommand( object ?source,?System.Web.UI.WebControls.DataGridCommandEventArgs?e)
?76 ???????? {
?77 ????????????DataGrid1.EditItemIndex? = ?e.Item.ItemIndex;
?78 ????????????MyDataBind();
?79 ????????}
?80
?81 ???????? private ? void ?DataGrid1_CancelCommand( object ?source,?System.Web.UI.WebControls.DataGridCommandEventArgs?e)
?82 ???????? {
?83 ????????????DataGrid1.EditItemIndex? = ? - 1 ;
?84 ????????????MyDataBind();
?85 ????????}
?86
?87 ???????? private ? void ?DataGrid1_UpdateCommand( object ?source,?System.Web.UI.WebControls.DataGridCommandEventArgs?e)
?88 ???????? {
?89 ????????????TextBox?MyTb? = ?(TextBox)e.Item.FindControl( " TextBox1 " );
?90 ????????????Label?MyLb? = ?(Label)e.Item.FindControl( " LbID " );
?91 ???????????? // ?int?IntT?=?(int)DataGrid1.DataKeyField[e.Item.ItemIndex];
?92 ????????????WebTest.Common.COperator?UpdateObj? = ? new ?WebTest.Common.COperator();
?93 ????????????UpdateObj.NoReturnFunction(MyLb.Text,? " @StrTID " ,?MyTb.Text,? " @StrTValues " ,? " TS_UpdateTb " );
?94
?95 ????????????DataGrid1.EditItemIndex? = ? - 1 ;
?96 ????????????MyDataBind();
?97 ????????}
?98
?99 ???????? public ? void ?DataGrid1_OnPageIndexChanged( object ?source,?System.Web.UI.WebControls.DataGridPageChangedEventArgs?e)
100 ???????? {
101 ???????????? // 設置當前頁的索引
102 ????????????DataGrid1.CurrentPageIndex? = ?e.NewPageIndex;
103 ???????????? // 重新進行數據綁定
104 ????????????MyDataBind();
105 ????????}
106 ????}
107 }
108

html:
?1 <% @?Page?language = " c# " ?Codebehind = " Default.aspx.cs " ?AutoEventWireup = " false " ?Inherits = " WebTest._Default " ? %>
?2 <! DOCTYPE?HTML?PUBLIC?"-//W3C//DTD?HTML?4.0?Transitional//EN"? >
?3 < HTML >
?4 ???? < HEAD >
?5 ???????? < title > Default </ title >
?6 ???????? < meta? content ="Microsoft?Visual?Studio?.NET?7.1" ?name ="GENERATOR" >
?7 ???????? < meta? content ="C#" ?name ="CODE_LANGUAGE" >
?8 ???????? < meta? content ="JavaScript" ?name ="vs_defaultClientScript" >
?9 ???????? < meta? content ="http://schemas.microsoft.com/intellisense/ie5" ?name ="vs_targetSchema" >
10 ???? </ HEAD >
11 ???? < body? MS_POSITIONING ="GridLayout" >
12 ???????? < form? id ="Form1" ?method ="post" ?runat ="server" >
13 ???????????? < FONT? face ="宋體" >
14 ???????????????? < asp:datagrid? id ="DataGrid1" ?style ="Z-INDEX:?101;?LEFT:?256px;?POSITION:?absolute;?TOP:?88px"
15 ????????????????????runat ="server" ?OnPageIndexChanged ="DataGrid1_OnPageIndexChanged" ?AutoGenerateColumns ="False"
16 ????????????????????DataKeyField ="TID" ?PageSize ="5" ?AllowPaging ="True" >
17 ???????????????????? < Columns >
18 ???????????????????????? < asp:TemplateColumn? HeaderText ="ID" >
19 ???????????????????????????? < ItemTemplate >
20 ???????????????????????????????? < asp:Label? id =LbID? runat ="server" ?text ='<%#? DataBinder.Eval(Container.DataItem,?"TID")?% > '>
21 ???????????????????????????????? </ asp:Label >
22 ???????????????????????????? </ ItemTemplate >
23 ???????????????????????? </ asp:TemplateColumn >
24 ???????????????????????? < asp:TemplateColumn? HeaderText ="Values" >
25 ???????????????????????????? < ItemTemplate >
26 ???????????????????????????????? < asp:Label? id =LbValues? runat ="server" ?text ='<%#? DataBinder.Eval(Container.DataItem,?"TValues")?% > '>
27 ???????????????????????????????? </ asp:Label >
28 ???????????????????????????? </ ItemTemplate >
29 ???????????????????????????? < EditItemTemplate >
30 ???????????????????????????????? < asp:TextBox? id =TextBox1? runat ="server" ?Text ='<%#? DataBinder.Eval(Container.DataItem,?"TValues")?% > '?Width="64px">
31 ???????????????????????????????? </ asp:TextBox >
32 ???????????????????????????? </ EditItemTemplate >
33 ???????????????????????? </ asp:TemplateColumn >
34 ???????????????????????? < asp:EditCommandColumn? ButtonType ="PushButton" ?UpdateText ="更新" ?HeaderText ="編輯" ?CancelText ="取消" ?EditText ="編輯" ></ asp:EditCommandColumn >
35 ???????????????????????? < asp:TemplateColumn? HeaderText ="刪除" >
36 ???????????????????????????? < ItemTemplate >
37 ???????????????????????????????? < asp:Button? id ="BtDelete" ?runat ="server" ?Text ="刪除" ?CommandArgument? =?'<%#? DataBinder.Eval(Container.DataItem,?"TID")?% > '?OnCommand?=?"BtDelete">
38 ???????????????????????????????? </ asp:Button >
39 ???????????????????????????? </ ItemTemplate >
40 ???????????????????????? </ asp:TemplateColumn >
41 ???????????????????? </ Columns >
42 ???????????????????? < PagerStyle? HorizontalAlign ="Right" ?Mode ="NumericPages" ></ PagerStyle >
43 ???????????????? </ asp:datagrid ></ FONT ></ form >
44 ???? </ body >
45 </ HTML >
46
precedure:
1 ?? ALTER ? PROCEDURE ?SearchAllInfoFromTb
2 /*
3 ????(
4 ????????@parameter1?datatype?=?default?value,
5 ????????@parameter2?datatype?OUTPUT
6 ????)
7 */
8 AS
9 ???? select ? * ? from ?Tb
?1 ?? ALTER ? PROCEDURE ?TS_AddValuesIntoTb
?2 (
?3 ???? @StrTValues ? nvarchar ( 50 )
?4 )
?5 AS
?6 ???? insert ? into ?Tb
?7 ????(TValues)
?8 ???? values
?9 ????( @StrTValues )
10
1 ? ALTER ? PROCEDURE ?TS_DeleteInfoFromTb
2 (
3 ???? @StrID ? varchar ( 50 )
4 )
5 AS
6 ???? delete ?Tb
7 ???? where ?TID? = ? @StrID
?1 ?? ALTER ? PROCEDURE ?TS_UpdateTb
?2 (
?3 ???? @StrTID ? nvarchar ( 50 ),
?4 ???? @StrTValues ? nvarchar ( 50 )
?5 )
?6 AS
?7 ???? update ?Tb
?8 ???? set ?TValues? = ? @StrTValues
?9 ???? where ?TID? = ? @StrTID
10

Add/Delete/Update


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索：z360901061

微信掃一掃加我為好友

QQ號聯系： 360901061

您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。

【本文對您有幫助就好】元

您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧，站長會非常 感謝您的哦！?。?/p>

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板： 久操欧美 | 一区二区三区四区免费 | 国产精品v欧美精品v日韩精品 | 奇米影音先锋 | 91日本在线观看亚洲精品 | 国产精品果冻麻豆精东天美 | 伦一区二区三区中文字幕v亚洲 | 亚洲伊人色一综合网 | 成人福利在线视频 | 亚洲精品在线视频观看 | 免费大香伊蕉在人线国产 | a色在线| www.日本在线播放 | 漂流教室在线观看 | 一区二区三区四区五区中文字幕 | 午夜视频在线观看www中文 | 高清国产激情视频在线观看 | 欧美精品在线一区二区三区 | www.小视频| 亚洲精品日韩在线 | 欧美亚洲精品在线 | 久久精品免费一区二区三 | 日韩手机专区 | 久久久精品视频免费看 | 欧美一级毛片在线看视频 | 日韩欧美在线视频 | 色在线视频观看 | 新91 | 最新国产网址 | 婷婷久月| 国产日韩欧美精品 | 久久免费精品视频在线观看 | 亚洲精品老司机综合影院 | 亚洲国产精品一区二区第一页 | 欧美三级美国一级 | 国产精品免费av | 免费亚洲视频在线观看 | 天天摸天天做天天爽在线 | 欧美激情欧美激情在线五月 | 国产精品日韩欧美 | 亚拍自拍 |