ÓÂÆø

ÔÚC#ÖÐÁ¬½ÓAccessÊý¾Ý¿âµÄÓï¾ä£¨²»ÓÃÐÞ¸ÄwebÅäÖÃÎļþ£©

public static string myStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|myaDB.mdb;User Id=;Password=;";
        public static OleDbConnection GetConnection()
        {
            OleDbConnection myConn = new OleDbConnection(myStr);
            return myConn;
        }
        using (OleDbConnection conn = new OleDbConnection (myStr ))
       {

                OleDbCommand cmd = new OleDbCommand ();
                cmd.Connection = conn;
                cmd.CommandText = "select userid  from userinfo where username=@name and roleid=5";
                cmd.Parameters.Add(new OleDbParameter("@name", Name));
                conn.Open();

       }

//=======================================================================================

Á¬½ÓSql Server2005Êý¾Ý¿âµÄ·½Ê½£¨ÐÞ¸ÄwebÅäÖÃÎļþ£©

1¡¢

 <connectionStrings>
    <add name="Á¬½Ó×Ö·û´®Ãû³Æ" connectionString="Data Source=»úÆ÷Ãû»òipµØÖ·;Initial Catalog=Êý¾Ý¿âÃû;User ID=Óû§Ãû;Password=ÃÜÂë"/>
  </connectionStrings>
  
 

2¡¢ÔÚÀàÎļþÖÐÁ¬½ÓÊý¾Ý¿â

        static string strconn = ConfigurationManager.ConnectionStrings["webÅäÖÃÎļþÖж¨ÒåµÄÁ¬½Ó×Ö·û´®Ãû"].ConnectionString;

        using (SqlConnection conn = new SqlConnection(strconn))
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = "select userid  from userinfo where username=@name and roleid=5";
                cmd.Parameters.Add(new SqlParameter("@name", Name));
                conn.Open();

                using (SqlDataReader sdr = cmd.ExecuteReader())
                {
                    while (sdr.Read())
                    {
                        adminid = Convert.ToInt32(sdr["userid"]);

                        first.Add(new AdminInfo(adminid));
                    }

                }

            }
            return adminid;

=============================¹¤×÷Ò»¶Îʱ¼äÁË£¬¼Ç¼һЩ³£ÓõÄÓï¾ä¿ÉÒÔ·½±ãʹÓÃ====