在 Net使用mysql数据库(c#)

2023-09-16 11:05:06 终极管理员知识笔记 51阅读

埃尔瓦农关于MySQLWenn die Datenbank，Scheint zu sagenJava，JSP或服务器端编程语言（Professional Hypertext Preprocessor的缩写）的100 . eigen tlich knnen all Verfahren genutz werden。关于关系型数据库数据库密歇根州贝努岑市的所有课程。关于SQLBereitgestelltODBC驱动请原谅。京东商城丁.网。它的名字叫：MySQLDriverCS.dll .你住在Komponenten.net的郊区，但你觉得这件作品怎么样(_)！这是一个奇迹关于MySQLDriverCSErstellen einer datenbankverknpfungMySQLConnectionconn=new MySQL connection(newmysql connectionstring(' localhost ' ' test ' ' root ' ').AsString)；conn . open()；当您使用Visual Studio.net时，请使用代码关于MysqldriversSie knnen sehen关于MysqldriversAlles im Namensraum .下面是sind common :1 MySQL command cmd 2 cmd=1)' new MySQL driver cs .MySQL command(' droptableifexiststest . mysqldrivercs _ test 'conn)；3cmd .ExecuteNonQuery()；4cmd .提供();567cmd=newMySQLDriverCS .MySQL command(' createtabletest . mysqldrivercs _ test ')(' 8 ' settingidinyint(3)unsignedNOTNULLauto _ increment '9

)">"SettingValue text, "+
10    "PRIMARY KEY  (SettingID), UNIQUE KEY SettingID(SettingID),  KEY SettingID_2 (SettingID))"+
11    " TYPE=MyISAM COMMENT='MySQL test table'",conn);
12
13   cmd.ExecuteNonQuery();
14   cmd.Dispose();
15
下面是insert:

string Value = "Value";
   int SettingID = 1;


   new MySQLInsertCommand(conn,
    new object[,] {{"SettingID",SettingID},{"SettingValue",Value}},
    "mysqldrivercs_test"
    );

下面是update

   Value = "Value2";
   new MySQLUpdateCommand(conn,
    new object[,] {{"SettingValue",Value}},
    "mysqldrivercs_test",
    new object[,] {{"SettingID","=",SettingID}},
    null
    );

下面是select

   DataTable dt = new MySQLSelectCommand(conn,
    new string[] {"SettingID","SettingValue"},
    new string[] {"mysqldrivercs_test"},
    new object[,] {{"SettingID","=",SettingID}},
    null,
    null
    ).Table;
   string storedValue = dt.Rows[0]["SettingValue"].ToString();


   下面是delete
   new MySQLDeleteCommand(conn,"mysqldrivercs_test",new object[,] {{"SettingID","=",SettingID}},null);

关闭链接:

    conn.Close();

怎么样,很方便吧!

标签：