现在已经从数据库中把数据取出来然后放在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对象,然后就可以了;
}
}
dt =
dsData.Tables[0];
=》
- C# code
dt = dsData.Tables[0];
for(int i=0;i<dt.Rows.Count;i++)
{
MessageBox.Show(string.Format("ID:{0},GroupName:{1},Time:{2}",dt.Rows["ID"],dt.Rows["GroupName"],dt.Rows["Time"]));
}
//dt is a datatable
for (int i = 0; i < dt.Rows.Count;
i++) { DataRow dr = dt.Rows;
for (int j = 0; j < dr.ItemArray.Length; j++)
Console.Write(dr[j]); Console.WriteLine();
}
for(int i=0;i { DataRow
dr =dt.NewRow(); dr[0]=ds1.Tables[0].Rows["字段"].ToString(); dr[1]=ds1.Tables[0].Rows["字段"].ToString(); dr[2]=ds1.Tables[0].Rows["字段"].ToString(); dt.Rows.Add(dr); }
|
|