Mysql的connector/net5.0下载地址:
安装好以后,点属性,然后点查找目标,点向上一层目录,找到Binaries\.NET 2.0,然后将这个文件复制到你的工程目录下,一般这样的DLL文件会保存到bin目录下.
aspx页面UI层次的显示等就不讲解了，看看所谓的业务逻辑层的连接吧。。。。 procedure.cs类文件中： public void Delete_procedure() // “删除”的存储过程 { string str_orgid = Client_Str; // 获得orgid string myConn_str = WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ConnectionString; MySqlConnection myConn = new MySqlConnection(myConn_str); MySqlCommand myComm = new MySqlCommand("DELETEDB", myConn); // (Client_Str); // myComm.Connection = myConn; try { myComm.Connection.Open(); myComm.CommandType = CommandType.StoredProcedure; MySqlParameter myParameter; myParameter = new MySqlParameter("?m_orgid", MySqlDbType.String); myParameter.Value = str_orgid; myParameter.Direction = ParameterDirection.Input; myComm.Parameters.Add(myParameter); // myComm.CommandText = "DELETEDB"; // 存储过程名 // myComm.Parameters.Add("m_orgid", str_orgid); myComm.ExecuteNonQuery(); } catch { myComm.Connection.Close(); myComm.Dispose(); } finally { myComm.Connection.Close(); myComm.Dispose(); } }
数据库当然是要自己建立的，由于“删除”的这个存储过程比较简单，能让大家容易理解 这个存储过程就是实现统一删除每一个相关数据表中的一条记录，只用了传递ID这一个参数。 Mysql的简单存储过程： CREATE PROCEDURE `DELETEDB`( IN m_orgid char( 12)) BEGIN delete from hardwareinfo where orgid =m_orgid; delete from addressinfo where orgid =m_orgid; delete from netspeedinfo where orgid =m_orgid; delete from memoryinfo where orgid =m_orgid; delete from urlinfo where orgid =m_orgid; delete from urluserinfo where orgid =m_orgid; delete from orderinfo where orgid =m_orgid; delete from softinfo where orgid =m_orgid; delete from orginfo where orgid =m_orgid; delete from harddiskinfo where orgid =m_orgid; delete from hotfixinfo where orgid =m_orgid; delete from userinfo where orgid =m_orgid; delete from softuserinfo where orgid =m_orgid; delete from systeminfo where orgid =m_orgid; END
(方法2)ASP.NET如何调用MS_SQL的存储过程 今天是国庆假期的第2天(2007.10.2),看见一个不错的方法,特地转载过来,让大家更加了解存储过程; ) 后台代码：
protected void Button1_Click( object sender, EventArgs e) 
{ 
int rowsAffected; 
SqlParameter[] parameters = { new SqlParameter("@title",TextBox1.Text), new SqlParameter("@content", TextBox2.Text) 
}; sdh.RunProcedure("[AddNew]", parameters, out rowsAffected); Response.Write("OK!"); 
} /**/ /// <summary> /// 执行存储过程，返回影响的行数 /// </summary> /// <param name="storedProcName"> 存储过程名 </param> /// <param name="parameters"> 存储过程参数 </param> /// <param name="rowsAffected"> 影响的行数 </param> /// <returns></returns> public int RunProcedure( string storedProcName, IDataParameter[] parameters, out int rowsAffected) { using (SqlConnection connection = new SqlConnection(strConn)) { int result; connection.Open(); SqlCommand command = BuildIntCommand(connection, storedProcName, parameters); rowsAffected = command.ExecuteNonQuery(); result = ( int)command.Parameters["ReturnValue"].Value; // Connection.Close(); return result; } } create proc AddNew ( @title varchar( 50), @content varchar( 50) ) as insert into News values( @title, @content) 本文转自钢钢博客园博客，原文链接：http://www.cnblogs.com/xugang/archive/2007/09/06/884681.html，如需转载请自行联系原作者