ACCESS SQL连接代码

来源：互联网发布：华为用户数据分区破坏编辑：程序博客网时间：2024/06/07 00:48

SQL:

string strConnection = "uid=sa;pwd=123;";

//账户，密码
strConnection += "Initial Catalog=master;Server=TSINNFENG;";

//表分类，服务器名
SqlConnection objConnection = new SqlConnection(strConnection);

            //生成连接对象
            //Data Source=TSINNFENG;Initial Catalog=master;Integrated Security=True
            string strCmd = "select * from student";
            objConnection.Open();
            SqlDataAdapter myCmd = new SqlDataAdapter(strCmd, strConnection);
            DataSet myDataSet = new DataSet();
            myCmd.Fill(myDataSet, "student");
            dataGridView1.DataSource = myDataSet.Tables["student"];
            objConnection.Close();

ACCESS:

//连接数据库
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";//access2007为Microsoft.ACE.OLEDB.12.0;

            string CurrPath = System.Environment.CurrentDirectory.ToString() + @"/database/plan.mdb";//access2007为plan.accdb
            strConnection += "Data Source =" + CurrPath;
            string weekDayStr = System.DateTime.Now.DayOfWeek.ToString();
            //MessageBox.Show(weekDayStr);
            string strCmd = "SELECT * FROM WeekDay WHERE WkDay=" + "'" + weekDayStr + "'";
            //OleDbDataAdapter myCommand = new OleDbDataAdapter(strCmd, strConnection);
            //DataSet myDataSet=new DataSet();
            //myCommand.Fill(myDataSet,"WeekDay");
            //dataGridView1.DataSource = myDataSet.Tables["WeekDay"];
            //richTextBox1.Text = myDataSet
            //MessageBox.Show(myDataSet.ToString());
            OleDbConnection myConn = new OleDbConnection(strConnection);
            myConn.Open();
            //把数据库一行一行的读出
            OleDbCommand sqlcmd = new OleDbCommand(strCmd, myConn);
            OleDbDataReader Odr = sqlcmd.ExecuteReader();
            int cols = Odr.FieldCount;
            object[] values = new object[cols];
            string labelStr = "";
            while (Odr.Read())
            {
                Odr.GetValues(values);
                for (int i = 0; i < values.Length; i++)//读取列数
                {
                    //labelStr += values[i].ToString();
                    //MessageBox.Show(values[i].ToString());
                    if (i == 0)
                    {
                        labelStr += "今天是：" + values[i].ToString() + "/n/n" + "今日任务：/n/n";
                    }
                    if (i == 1)
                    {
                        labelStr += "上午任务：" + values[i].ToString() + "/n";
                    }
                    if (i == 2)
                    {
                        labelStr += "中午任务：" + values[i].ToString() + "/n";
                    }
                    if (i == 3)
                    {
                        labelStr += "下午任务：" + values[i].ToString() + "/n";
                    }
                    if (i == 4)
                    {
                        labelStr += "晚上任务：" + values[i].ToString() + "/n";
                    }
                }
                labelStr += "/n";
            }
            Odr.Close();
            //按行读取数据库结束
            myConn.Close();