c#连接sqlserver数据库

 string strconn = "data source = (local);initial catalog = sxaic; user id = sa;password = 123456";
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = strconn;
            conn.Open();
            string sql = "select * from t_brand";
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql,conn);
            DataSet ds = new DataSet();
            sqlAdapter.Fill(ds,"t_brand");
            Label1.Text = ds.Tables[0].Rows[0]["brand"].ToString();
            conn.Close();