【datatable】DataTable多列合并问题轻松搞定-合并列

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【DataTable多列合并问题轻松搞定】，下面是详细的讲解！

DataTable多列合并问题轻松搞定

#region 根据动态生成的数据库表名，从该表中选出QuestionId，ChapterId，QuestionTypeId，Point,不包括难度等级约束
/// <summary>
/// 根据动态生成的数据库表名，从该表中选出QuestionId，ChapterId，QuestionTypeId，Point,
/// Degree,Fraction,QuestioinContent,IsValid等内容,不包括难度等级约束
/// </summary>
/// <param name="strDataTableName"></param>
/// <returns></returns>
public DataTable BindQuestion(string strTableName,string strChapterName,string strQuestionTypeName)
{
try
{
DataTable dt=new DataTable ();
if (strQuestionTypeName !="论述题" && strQuestionTypeName !="案例分析题")
{
strsql="select * from " + strTableName + " where ChapterId=@chapterid and QuestionTypeId=@questiontypeid";
}
else
{
strsql="select QuestionId,ChapterId,QuestionTypeId,Point,Degree,Fraction,QuestionContent,cast(Answer1 as nvarchar(4000)) + cast(Answer2 as nvarchar(4000)) + cast(Answer3 as nvarchar(4000)) + cast(Answer4 as nvarchar(4000)) + cast(Answer5 as nvarchar(4000)) + cast(Answer6 as nvarchar(4000)) AS CorrectAnswer,IsValid from " + strTableName + " where ChapterId=@chapterid and QuestionTypeId=@questiontypeid";
}
//strsql="select * from " + strTableName + " where ChapterId=@chapterid and QuestionTypeId=@questiontypeid";
SqlParameter[] paras=new SqlParameter[]{
new SqlParameter("@chapterid",strChapterName),
new SqlParameter("@questiontypeid",strQuestionTypeName)
};
dt=sqlHelper.ExecuteQuery(strsql,paras,CommandType.Text);
return dt;
}
catch
{
throw new Exception("从动态生成的数据库表中获取QuestionId，ChapterId，QuestionTypeId，Point失败（不包括难度等级）");
}
finally
{
sqlHelper.Close();
}
}
#endregion

关于DataTable多列合并问题轻松搞定的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细