菜鸟求解答

最新推荐文章于 2024-11-07 08:51:26 发布

jiang19880823

最新推荐文章于 2024-11-07 08:51:26 发布

阅读量313

点赞数 1

文章标签： exception database server c# cmd

本文链接：https://blog.csdn.net/jiang19880823/article/details/6500705

版权

刚学C# 有很多不懂的地方希望高手帮忙解答：

SqlConnection conn = new SqlConnection("server=192.168.0.46;database=pubs;User Id=sa;pwd=123456");
            SqlCommand cmd = new SqlCommand("SELECT * FROM employee", conn);
            try
            {
                conn.Open();

                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    Console.WriteLine("First Name: {0}, Last Name: {1}", reader.GetString(0), reader.GetString(1));
                }

                reader.Close();
                conn.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine("Exception Occured -->> {0}", e);
            }