连接数据库方法

        连接数据库可以在控制面板中直接添加数据源，也可以在VS2008中选择“数据”----“添加新数据源”。连接SQL代码如下：

            DataSet ds = new DataSet();
            string consqlserver = "Data Source =.\\sqlexpress;Initial            

            Catalog=SqltestLogin(数据库名称);Integrated Security = True";
            string sql = "select * from LoginTable（数据库中的表）";     //定义连接数据源

           //定义连接对象
            SqlConnection con = new SqlConnection(consqlserver);
            SqlDataAdapter da = new SqlDataAdapter(sql,con);

            try
            {
                da.Fill(ds);     //填充数据
                if(ds.Tables[0].Rows.Count>1)
                {
                    dataGridView1.DataSource = ds.Tables[0];
                }
            }

            catch(Exception ex)    //如果有错误执行错误处理；
            {
                throw new Exception(ex.ToString());
            }
            finally
            {
                con.Close();   //关闭连接
                con.Dispose();//释放连接
                da.Dispose();
            }

连接Access数据库代码如下：

           DataSet ds = new DataSet();
            string strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +            

            Application.StartupPath + "\\DB_Test.mdb";
            string sql = "select * from table1";
            System.Data.OleDb.OleDbConnection con = new OleDbConnection(strFilePath);
            System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter(sql, con);

            try
            {
                da.Fill(ds);
                if (ds.Tables[0].Rows.Count > 1)
                {
                    dataGridView1.DataSource = ds.Tables[0];
                }
            }

            catch (Exception ex)    //如果有错误执行错误处理；
            {
                throw new Exception(ex.ToString());
            }
            finally
            {
                con.Close();   //关闭连接
                con.Dispose();//释放连接
                da.Dispose();
            }