现在已经从数据库中把数据取出来然后放在datatable中 代码如下:
- C# code
System.Data.DataTable dt = new System.Data.DataTable();
string sql = "select [ID],[GroupName],[State],[Point],[Time] from OnOff ";
SqlConnection connection = null;
DataSet dsData = null;
try
{
connection = new SqlConnection(connnectionString);
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
SqlDataAdapter daAdapter = new SqlDataAdapter();
daAdapter.SelectCommand = command;
dsData = new DataSet();
daAdapter.Fill(dsData);
connection.Close();
}
catch (Exception ee)
{
MessageBox.Show("数据库连接失败 !" + ee.Message.ToString());
return;
}
dt = dsData.Tables[0];
我现在想遍历这个DataTable,可以一行一行取出来,应该怎么写?
希望高手指点!!最好能帮写下代码!!
感激不尽!!C# code
System.Data.DataTable dt = new System.Data.DataTable();
string sql = "select [ID],[GroupName],[State],[Point],[Time] from OnOff ";
SqlConnection connection = null;
DataSet dsData = null;
try
{
connection = new SqlConnection(connnectionString);
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
SqlDataAdapter daAdapter = new SqlDataAdapter();
daAdapter.SelectCommand = command;
dsData = new DataSet();
daAdapter.Fill(dsData);
connection.Close();
}
catch (Exception ee)
{
MessageBox.Show("数据库连接失败 !" + ee.Message.ToString());
return;
}
dt = dsData.Tables[0];
if(dt!=null)
{
foreach(DataRow dr in dt.Rows)
{
访问dr对象,然后就可以了;
}
}
联系客服