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

亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

Add/Delete/Update

系統(tǒng) 1994 0

首先是數(shù)據(jù)訪問層的代碼:

??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:?在此處添加構(gòu)造函數(shù)邏輯
?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 ???????????? // ?啟動(dòng)一個(gè)事務(wù)
?39 ????????????SqlTransaction?MyTrans? = ?MyConnection.BeginTransaction();
?40
?41 ???????????? // ?initialize?command?object
?42 ????????????MyCommand.Transaction? = ?MyTrans;
?43
?44 ???????????? try
?45 ???????????? {
?46 ???????????????? // ?進(jìn)行數(shù)據(jù)庫操作
?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 ???????????? // ?創(chuàng)建數(shù)據(jù)庫連接和命令的對(duì)象
?65 ????????????SqlConnection?myConnection? = ? new ?SqlConnection(ConfigurationSettings.AppSettings[ " ConnectionSqlServer " ]);
?66 ????????????
?67 ????????????SqlCommand?myCommand? = ? new ?SqlCommand(StrProcedure,?myConnection);
?68
?69 ???????????? // ?指明Sql命令的操作類型是使用存儲(chǔ)過程
?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 ???????????? // ?打開數(shù)據(jù)庫連接
?77 ???????????? if ?(myConnection.State == System.Data.ConnectionState.Closed)
?78 ???????????? {
?79 ????????????????myConnection.Open();
?80 ????????????}
?81
?82 ???????????? // ?啟動(dòng)一個(gè)事務(wù)
?83 ????????????SqlTransaction?MyTrans? = ?myConnection.BeginTransaction();
?84
?85 ???????????? // ?initialize?command?object
?86 ????????????myCommand.Transaction? = ?MyTrans;
?87
?88 ???????????? try
?89 ???????????? {
?90 ???????????????? // ?進(jìn)行數(shù)據(jù)庫操作
?91 ????????????????myCommand.ExecuteNonQuery();
?92 ????????????????MyTrans.Commit();
?93 ????????????}
?94 ???????????? catch
?95 ???????????? {
?96 ????????????????MyTrans.Rollback();
?97 ????????????}
?98 ???????????? finally
?99 ???????????? {
100 ???????????????? // ?關(guān)閉數(shù)據(jù)庫連接
101 ????????????????myConnection.Close();
102 ????????????} ????
103 ????????}
104
105 ???????? // ?2參數(shù)
106 ???????? public ? void ?NoReturnFunction( string ?StrParameter1,? string ?StrField1,? string ?StrParameter2,? string ?StrField2,? string ?StrProcedure)
107 ???????? {
108 ???????????? // ?創(chuàng)建數(shù)據(jù)庫連接和命令的對(duì)象
109 ????????????SqlConnection?myConnection? = ? new ?SqlConnection(ConfigurationSettings.AppSettings[ " ConnectionSqlServer " ]);
110 ????????????
111 ????????????SqlCommand?myCommand? = ? new ?SqlCommand(StrProcedure,?myConnection);
112
113 ???????????? // ?指明Sql命令的操作類型是使用存儲(chǔ)過程
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 ???????????? // ?打開數(shù)據(jù)庫連接
125 ???????????? if ?(myConnection.State == System.Data.ConnectionState.Closed)
126 ???????????? {
127 ????????????????myConnection.Open();
128 ????????????}
129
130 ???????????? // ?啟動(dòng)一個(gè)事務(wù)
131 ????????????SqlTransaction?MyTrans? = ?myConnection.BeginTransaction();
132
133 ???????????? // ?initialize?command?object
134 ????????????myCommand.Transaction? = ?MyTrans;
135
136 ???????????? try
137 ???????????? {
138 ???????????????? // ?進(jìn)行數(shù)據(jù)庫操作
139 ????????????????myCommand.ExecuteNonQuery();
140 ????????????????MyTrans.Commit();
141 ????????????}
142 ???????????? catch
143 ???????????? {
144 ????????????????MyTrans.Rollback();
145 ????????????}
146 ???????????? finally
147 ???????????? {
148 ???????????????? // ?關(guān)閉數(shù)據(jù)庫連接
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?窗體設(shè)計(jì)器生成的代碼
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?窗體設(shè)計(jì)器生成的代碼
?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 ???????????? // 設(shè)置當(dāng)前頁的索引
102 ????????????DataGrid1.CurrentPageIndex? = ?e.NewPageIndex;
103 ???????????? // 重新進(jìn)行數(shù)據(jù)綁定
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


更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主

微信掃碼或搜索：z360901061

微信掃一掃加我為好友

QQ號(hào)聯(lián)系： 360901061

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

【本文對(duì)您有幫助就好】元

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

發(fā)表我的評(píng)論
最新評(píng)論 總共0條評(píng)論
主站蜘蛛池模板： 麻豆精品一区二区三区免费 | 日韩欧美精品有码在线观看 | 性做久久久久久蜜桃花 | 日本在线亚州精品视频在线 | 日韩成人免费一级毛片 | 免费观看性欧美一级 | 亚洲精品区一区二区三区四 | 高清一区二区三区免费 | 在线免费不卡视频 | 99久久精品在免费线18 | 国产精品99精品久久免费 | 欧美精品亚洲网站 | 中文字幕久精品免费视频蜜桃视频 | 国产在线一区在线视频 | 亚洲小视频在线播放 | 亚洲男人的天堂在线视频 | 一级毛片成人免费看a | 特级aa一级欧美毛片 | jizzjiz熟丰满老妇日本 | 欧美另类色 | 天天做天天爱夜夜爽毛片毛片 | 91精品国产色综合久久不 | 欧美成人免费全网站大片 | 久久综合九色综合欧洲 | jizz国产精品免费麻豆 | 国内精品久久影视 | 久久久婷婷亚洲5月97色 | 337p欧美超大胆日本人术艺术 | 日本不卡毛片一二三四 | 一级有奶水毛片免费看 | 国产96福利视频在线观看 | 国产综合图区 | 欧美精品v国产精品v | 久操视频在线免费观看 | 欧美激情区 | 久久精品国产清自在天天线 | 香蕉视频精品 | 在线日本韩国 | 亚洲爱婷婷色婷婷五月 | 九九热视频在线播放 | 成人爽a毛片在线视频网站 成人爽视频 |