声明的变量ID2同时会有多个值 但只能取一个值
string ConnSql2 = System.Configuration.ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
OleDbConnection Conn2 = new OleDbConnection(ConnSql2);
Conn2.Open();
string SelectSql1 = "select [user id] from [connection zp] where [companyname] ='" + id1 + "'";
OleDbCommand cmd1 = new OleDbCommand(SelectSql1, Conn2);
cmd1.ExecuteNonQuery();
OleDbDataReader dr1 = cmd1.ExecuteReader();
if (dr1.Read())
{
string id2 = dr1["user id"].ToString().Trim();
string ConnSql5 = System.Configuration.ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
OleDbConnection Conn5 = new OleDbConnection(ConnSql5);
Conn5.Open();
string cmdstr5 = "select * from [users] where [ID] =" + id2 + "";
OleDbDataAdapter sda5 = new OleDbDataAdapter(cmdstr5, Conn5);
DataSet ds = new DataSet();
sda5.Fill(ds, "users");
GridView1.DataSource = ds.Tables["users"];
GridView1.DataKeyNames = new string[] { "ID" };
GridView1.DataBind();
Conn5.Close();
GridView1.Visible = true;
dr1.Close();
}