类型转换解决办法
类型转换
void load( DataTable dt)
{
DataSet ds = (DataSet)dt;
string subject = ds.Tables[0].Rows[0][ "subject "].ToString();
string fromaddress = ds.Tables[0].Rows[0][ "fromaddress "].ToString();
DateTime Date = Convert.ToDateTime(ds.Tables[0].Rows[0][ "Date "].ToString());
//string subject = dt.TableName[0][ "subject "].ToString();
//string fromaddress = dt.TableName[0].Rows[0][ "fromaddress "].ToString();
//DateTime Date = Convert.ToDateTime(dt.TableName[0].Rows[0][ "Date "].ToString());
string sql = "insert into email (headine,takenaem,postdate) value( ' " + subject + " ', ' " + fromaddress + " ', ' " + Date + " ') ";
SqlConnection con=new SqlConnection(ConfigurationManager.AppSettings[ "Connection String "].ToString());
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
}
方法的参数是传进来的是个DATETABLE类型.我现在想转成DATASET类型.然后来取值.但是 DataSet ds = (DataSet)dt; 这样不能转.请大家指点下!
------解决方案--------------------
DataSet ds = new DataSet();
ds.Tables.Add(dataTable);
void load( DataTable dt)
{
DataSet ds = (DataSet)dt;
string subject = ds.Tables[0].Rows[0][ "subject "].ToString();
string fromaddress = ds.Tables[0].Rows[0][ "fromaddress "].ToString();
DateTime Date = Convert.ToDateTime(ds.Tables[0].Rows[0][ "Date "].ToString());
//string subject = dt.TableName[0][ "subject "].ToString();
//string fromaddress = dt.TableName[0].Rows[0][ "fromaddress "].ToString();
//DateTime Date = Convert.ToDateTime(dt.TableName[0].Rows[0][ "Date "].ToString());
string sql = "insert into email (headine,takenaem,postdate) value( ' " + subject + " ', ' " + fromaddress + " ', ' " + Date + " ') ";
SqlConnection con=new SqlConnection(ConfigurationManager.AppSettings[ "Connection String "].ToString());
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
}
方法的参数是传进来的是个DATETABLE类型.我现在想转成DATASET类型.然后来取值.但是 DataSet ds = (DataSet)dt; 这样不能转.请大家指点下!
------解决方案--------------------
DataSet ds = new DataSet();
ds.Tables.Add(dataTable);