ADO.net--杂七杂八（一）-优快云博客

本文介绍了一个使用C#连接SQL Server数据库并执行查询的例子。通过SqlConnection和SqlCommand对象建立连接并执行SQL语句，利用SqlDataAdapter填充DataSet，最后遍历数据并打印结果。

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

 private void BtnConnectDataBase_Click(object sender, RoutedEventArgs e)
        {
            string connectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=Easy5DB; User ID=easy5;Password=123456";
            using (SqlConnection sqlConnection = new SqlConnection(connectionString))
            {
                try
                {
                    sqlConnection.Open();
                    using (SqlCommand commnad = sqlConnection.CreateCommand())
                    {
                        try
                        {
                            string query = "select genreId, name from inventory.Genre order by genreId";
                            commnad.CommandText = query;
                            //-------------SqlDataReader
                            //SqlDataReader dataReader = commnad.ExecuteReader();
                            //while (dataReader.Read())
                            //{
                            //    Console.WriteLine("{0}-{1}", dataReader["genreId"], dataReader["name"]);
                            //}
                            //--------------SqlDataAdapter
                            SqlDataAdapter dataAdapeter = new SqlDataAdapter(commnad);
                            DataSet dataSet = new DataSet();
                            dataAdapeter.Fill(dataSet);
                            //dataSet.Tables
                            foreach (DataRow row in dataSet.Tables[0].Rows)
                            {
                                Console.WriteLine("{0}-{1}",row["genreId"],row["name"]);
                            }
                        }
                        catch (Exception commandError)
                        {
                            MessageBox.Show("执行Command失败:\n" + commandError.ToString());
                        }

                    }
                }
                catch (Exception openError)
                {
                    MessageBox.Show("打开数据库失败:\n" + openError.ToString());
                }
                finally
                {
                    sqlConnection.Close();
                }

            }
        }