当前位置:编程学习 > C#/ASP.NET >>

谁能给个asp.net(c#)+mysql的实例

由于mysql的共享性,本人想学习mysql,

谁能给个asp.net(c#)+mysql的实例?

只要.net利用odbc驱动连接mysql的实例,不要php的,有的给个,谢谢!

邮箱发至270146689@qq.com

答案:public void getCheckListSubmit()
{
string _conStr = "................";//连接字符串
OdbcConnection _odbcCon = new OdbcConnection(_conStr);
_odbcCon.Open();

OdbcTransaction trans = _odbcCon.BeginTransaction(IsolationLevel.ReadCommitted);
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = trans.Connection;
cmd.Transaction = trans;

string sqlStr = "";
try
{
sqlStr = ".................";

cmd.CommandText = sqlStr;
cmd.ExecuteNonQuery();

sqlStr2 = ".................";
cmd.CommandText = sqlStr2;
cmd.ExecuteNonQuery();

}
catch
{
trans.Rollback();
hidsysMsg.Value = "Insert Failed";
_odbcCon.Close();
return;
}
trans.Commit();
hidsysMsg.Value = "Insert Succeeded";
_odbcCon.Close();

}

上一个:C语言和C++语言和C#语言之间的区别
下一个:我以前没学过任何语言也没基础,想问下C语言和C++,C#,JAVA四种语言学习的话最好先学哪种

CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,