ACCESS SQL连接代码

最新推荐文章于 2025-05-09 13:03:36 发布

原创最新推荐文章于 2025-05-09 13:03:36 发布 · 1.1k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#access #sql #dataset #string #任务 #数据库

C#语言同时被 2 个专栏收录

48 篇文章

订阅专栏

数据库

7 篇文章

订阅专栏

本文提供了一个SQL Server和Access数据库的操作实例，包括连接数据库、执行查询并展示查询结果等步骤。通过示例展示了如何使用C#进行数据库操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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();