用dataset实现 foreach(datarow row in dataset.tables[0].rows) { if(row["某列"].tostring!=textbox1.text) { foreach(datacolumn col in dataset.columns { textbox2.text=textbox2.text+row[col.name].tostring(); } } }
foreach(datarow dr in dataset.tables[""].rows) { st=""; if(!dr[""].ToString.Equals(textbox1.text.Trim())) { foreach(datacolumn col in dataset.columns) { str=str+dr[col.name].tostring(); } } }
string cmd = "select * from iis "; SqlCommand sql = new SqlCommand(cmd);//连接数据库 sql.Connection = new SqlConnection("Data Source=192.168.33.5;Initial Catalog=xiaojie;Persist Security Info=True;User ID=xiaojie;Password=123456"); //try { sql.Connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(); DataSet DS = new DataSet();//将数据库数据存放在内存 adapter.SelectCommand = sql; adapter.Fill(DS); //dataGridView1.DataSource = DS.Tables[0]; foreach (DataRow row in DS.Tables[0].Rows) { if (row["ip"].ToString()!= textBox1.Text) { foreach (DataColumn col in DataSet.columns) { textBox2.Text = textBox2.Text + row[col.Namespace].ToString(); }请高手们帮忙看看修改下DataSet.columns这句有错误,估计是我前面连接数据库有问题,数据是能够存放在DS中的,本人菜鸟刚学希望各位能帮忙修改下。
foreach(datarow row in dataset.tables[0].rows)
{
if(row["某列"].tostring!=textbox1.text)
{
foreach(datacolumn col in dataset.columns
{
textbox2.text=textbox2.text+row[col.name].tostring();
}
}
}
{
st="";
if(!dr[""].ToString.Equals(textbox1.text.Trim()))
{
foreach(datacolumn col in dataset.columns)
{
str=str+dr[col.name].tostring();
}
}
}
SqlCommand sql = new SqlCommand(cmd);//连接数据库
sql.Connection = new SqlConnection("Data Source=192.168.33.5;Initial Catalog=xiaojie;Persist Security Info=True;User ID=xiaojie;Password=123456");
//try
{
sql.Connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet DS = new DataSet();//将数据库数据存放在内存
adapter.SelectCommand = sql;
adapter.Fill(DS);
//dataGridView1.DataSource = DS.Tables[0];
foreach (DataRow row in DS.Tables[0].Rows)
{
if (row["ip"].ToString()!= textBox1.Text)
{
foreach (DataColumn col in DataSet.columns)
{
textBox2.Text = textBox2.Text + row[col.Namespace].ToString();
}请高手们帮忙看看修改下DataSet.columns这句有错误,估计是我前面连接数据库有问题,数据是能够存放在DS中的,本人菜鸟刚学希望各位能帮忙修改下。