连接数据库

web.config

 

<configuration>

    <appSettings>

      <add key="ConnectionString" value="server=localhost;uid=sa;pwd=;database=MSystem"/>

    </appSettings>

    <connectionStrings/>

 

cs中：

private static string connectionString =ConfigurationManager.AppSettings["ConnectionString"];

 

 

 

或者：

SqlConnection con = new SqlConnection("server=.;database=FUSU;uid=sa;pwd=;");

/****************

con.Open();

        SqlCommand cmd = new SqlCommand("select count(*) from [Users] where [ID] =" + UID + "", con);

        int count = Convert.ToInt32(cmd.ExecuteScalar());

        con.Close();

        if (count > 0) return true;

        else return false;

*/

 

 

SqlDataAdapter sda = new SqlDataAdapter("select * from [Users]", con);

        DataSet ds = new DataSet();

        sda.Fill(ds, "Users");

        return ds.Tables["Users"];