一段自定义DataTable代码

最新推荐文章于 2022-05-24 07:39:14 发布

若情水

最新推荐文章于 2022-05-24 07:39:14 发布

阅读量329

点赞数

分类专栏： asp.net 文章标签： string path sql

本文链接：https://blog.csdn.net/ruoqingshui/article/details/6442672

版权

asp.net 专栏收录该内容

42 篇文章 1 订阅

订阅专栏

DataTable sourse = new DataTable();
sourse.Columns.Add(new DataColumn("TypeID"));
sourse.Columns.Add(new DataColumn("TypeName"));
sourse.Columns.Add(new DataColumn("pic"));
string sqltype = "select distinct TypeID from Cartoon_Pic";
DataTable dttype = DataAccess.GetDataTable(sqltype);
for (int i = 0; i < dttype.Rows.Count; i++)
{
 string typeid = dttype.Rows[i]["TypeID"].ToString();
 string path = PubMethod.GetPath("72");
 string sql = "select top 1 a.TypeID,b.TypeName,'" + path + "'+b.TypeName+'/'+a.Pic as pic from Cartoon_Pic as a,Cartoon_Type as b where a.TypeID='" + typeid + "' order by a.SerialNum asc";
 DataTable dt = DataAccess.GetDataTable(sql);
 if (dt.Rows.Count > 0)
 {
 DataRow dr = sourse.NewRow();
 dr["TypeID"] = dt.Rows[0]["TypeID"].ToString();
 dr["TypeName"] = dt.Rows[0]["TypeName"].ToString();
 dr["pic"] = dt.Rows[0]["pic"].ToString();
 sourse.Rows.Add(dr);
 }
}