SQL数据库中返回指定值的实现方法

最近在用VS2010做服务器，所以把一些程序整出来和大家分享，也为以后自己总结储备资料。如果有问题，欢迎留言讨论！           

            SqlConnection cnn1 = new SqlConnection();

            cnn1.ConnectionString = @"Data Source=477E67263580491\SQLEXPRESS;Initial  Catalog=happy_database;Integrated Security=True";

            cnn1.Open();      

 

            SqlDataAdapter adp = new SqlDataAdapter("select socket_1 From socket_1 where id1 = "+cmb.Text , cnn1);

            DataTable dt = new DataTable();

            DataSet ds = new DataSet();

            adp.Fill(ds);

            string vv=ds.Tables[0].Rows[0]["socket_1"].ToString();

            ///string val = ds.Tables[0].Rows[第几行]["列名"].ToString();

            MessageBox.Show( vv);

            cnn1.Close();