string connectionString = @"Server=210.26.96.131; DATABASE=lnqGarbageSorting; UID=IOT1804; PWD = Intelligentize19916";

SqlConnection conn = new SqlConnection(connectionString);

conn.Open();

string strSql = "SELECT * FROM 用户管理系统"; //要执行的SQL语句

SqlCommand cmd = new SqlCommand(strSql, conn);

SqlDataAdapter da = new SqlDataAdapter(cmd); //创建DataAdapter数据适配器实例

DataTable dt = new DataTable("tablename");//创建DataSet实例

da.Fill(dt);//使用DataAdapter的Fill方法(填充)

dataGridView1.DataSource = dt.DefaultView;

conn.Close();//关闭数据库

服务器名称和数据库名称改了就可以了哦

string connectionString = @"Server=210.26.96.131; DATABASE=lnqGarbageSorting; UID=IOT1804; PWD = Intelligentize19916