using System.Data.OleDb; using MySql.Data.MySqlClient; using System.Data; using System.Data.SqlClient; void LinkMySql() { string str = "Server=localhost;Database=test;Uid=root;Pwd=zz;"; MySqlConnection con = new MySqlConnection(str); try { con.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = con; cmd.CommandText = "ProcTest1"; cmd.CommandType = CommandType.StoredProcedure; MySqlDataReader dr = cmd.ExecuteReader(); while(dr.Read()) { Response.Write(dr["c1"].ToString()+"<br>"); } Response.Write("ok"); con.Close(); } catch(Exception ee) { Response.Write(ee.ToString()); } finally { con.Close(); } } void LinkSqlServer() { string str = "server='(local)';databse='mytable';uid='sa';pwd='sa'"; SqlConnection con = new SqlConnection(str); try { con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from t1",con); SqlCommand cmd = new SqlCommand("insert into t1", con); con.Close(); } catch(Exception ee) { } } void LinkAccess() { string str = "provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + Server.MapPath("access.mdb") + ""; OleDbConnection con = new OleDbConnection(str); try { con.Open(); con.Close(); } catch (Exception ee) { Response.Write("<script>alert('连接失败');</script>"); } }