遍历datagrid
foreach(DataGridItem mydr in dg_browse.Items)
{
if(((CheckBox)(mydr.Cells[0].Controls[1])).Checked)
{
mydb.asSQLString = ls_sql + mydr.Cells[1].Text + "'";
mydt = mydb.SelectDB().Tables["MyData"];
if(mydt.Rows.Count == 0)
{
continue;
}
//写出数据
data +="<tr>";
foreach (DataColumn column in mydt.Columns)
{
//data += mydt.Rows[0][column].ToString() + ",";
string strColumnvalue = string.Empty;
try
{
strColumnvalue = Convert.ToDateTime(mydt.Rows[0][column].ToString()).ToShortDateString();
}
catch
{
strColumnvalue = mydt.Rows[0][column].ToString();
}
data += "<td>" + strColumnvalue + "</td>";
}
//data += "\n";
data += "</tr>";
li_cnt ++ ;
}
}
{
if(((CheckBox)(mydr.Cells[0].Controls[1])).Checked)
{
mydb.asSQLString = ls_sql + mydr.Cells[1].Text + "'";
mydt = mydb.SelectDB().Tables["MyData"];
if(mydt.Rows.Count == 0)
{
continue;
}
//写出数据
data +="<tr>";
foreach (DataColumn column in mydt.Columns)
{
//data += mydt.Rows[0][column].ToString() + ",";
string strColumnvalue = string.Empty;
try
{
strColumnvalue = Convert.ToDateTime(mydt.Rows[0][column].ToString()).ToShortDateString();
}
catch
{
strColumnvalue = mydt.Rows[0][column].ToString();
}
data += "<td>" + strColumnvalue + "</td>";
}
//data += "\n";
data += "</tr>";
li_cnt ++ ;
}
}