This Is A FineDay

BlogJava :: 首頁 :: 新隨筆 :: 聯系 :: 聚合

:: 管理 ::

93 隨筆 :: 0 文章 :: 69 評論 :: 0 Trackbacks

<

2008年9月

>

日

一

二

三

四

五

六

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

1

2

3

4

5

6

7

8

9

10

11

常用鏈接

留言簿(2)

我參與的團隊

鄭州Java小組(0/0)

隨筆分類

隨筆檔案

友情連接

__sunking的專欄
lewang的博客(En)
臨海觀潮
鄭州java小組

搜索

閱讀排行榜

評論排行榜

dotnet&mysql

?

using?System;

using?System.Data;

using?System.Configuration;

using?System.Collections;

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?MySql.Data.MySqlClient;

public ?partial? class ?news?:?System.Web.UI.Page

{

?

???? protected ? void ?Page_Load(object?sender,?EventArgs?e)

???? {

?????????DataTable????dt? = ? new ?DataTable();

????????string?connStr? = ?String.Format( " server={0};user?id={1};?password={2};?database=test;?pooling=false " ,

???????????????? " 127.0.0.1 " ,? " root " ,? " 123 " );

????????MySqlConnection?conn? = ? new ?MySqlConnection(connStr);

????????conn.Open();

????????MySqlDataAdapter?msda? = ? null ;

????????MySqlCommandBuilder?cb? = ? null ;

???????? try

???????? {

???????????? // 查詢

????????????msda? = ? new ?MySqlDataAdapter( " select?*?from?test " ,?conn);

????????????cb? = ? new ?MySqlCommandBuilder(msda);???

????????????msda.Fill(dt);

????????}

???????? catch ?(MySqlException?ex)

???????? {

????????????System.Console.WriteLine( " Failed?to?populate?mysql?data:? " ? + ?ex.Message);

????????}

???????? finally

???????? {

???????????? if ?(conn? != ? null )?conn.Close();

????????}

???????? // 更新

????????conn.Open();

????????DataRow?row1? = ?dt.Rows[ 0 ];

????????row1[ " name " ]? = ? " 00 " ;

????????row1[ " password " ]? = ? " 00 " ;

????????msda.Update(dt);

????????dt.AcceptChanges();

????????conn.Close();

???????? // 新增

????????conn.Open();

????????DataRow?row2? = ?dt.NewRow();

????????row2[ " id " ]? = ? 6 ;

????????row2[ " name " ]? = ? " 6 " ;

????????row2[ " password " ]? = ? " 6 " ;

????????dt.Rows.Add(row2);

????????msda.Update(dt);

????????dt.AcceptChanges();

????????conn.Close();

???????? // 刪除

????????conn.Open();

????????DataRow?row3? = ?dt.Rows[ 1 ];

????????row3.Delete();

????????msda.Update(dt);

????????dt.AcceptChanges();

????????conn.Close();

????????

???????? // 填充頁面

???????? this .DataList1.DataSource? = ?dt.DefaultView;

???????? this .DataList1.DataBind();

????}

??

}

posted on 2008-09-23 23:59 Peter Pan 閱讀(197) 評論(0) 編輯收藏所屬分類: DotNet

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理

This Is A FineDay

常用鏈接

留言簿(2)

我參與的團隊

隨筆分類

隨筆檔案

友情連接

搜索

最新隨筆

最新評論

閱讀排行榜

評論排行榜