Sql

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>");
            }
        }