亚洲av无码专区国产乱码在线观看 ,亚洲精品在线视频,亚洲国产精彩中文乱码AV

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 閱讀(196) 評論(0) 編輯收藏所屬分類: DotNet

新用戶注冊刷新評論列表


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




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

This Is A FineDay

常用鏈接

留言簿(2)

我參與的團隊

隨筆分類

隨筆檔案

友情連接

搜索

最新隨筆

最新評論

閱讀排行榜

評論排行榜