110,534
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="GridView6" runat="server" Width="100%" AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3">
<Columns>
<asp:TemplateField HeaderText="综合题">
<ItemTemplate>
<table id="Table7" cellspacing="1" cellpadding="1" width="100%" align="center" border="0">
<tr>
<td>
<asp:Label id="Label24" runat="server" Text='<%# Container.DataItemIndex+1 %>'>
</asp:Label>
<asp:Label id="Label25" runat="server" Text='<%# Eval("Title","、{0}") %>'>(报错的地方)
</asp:Label>
<asp:TextBox id="txtAnswer1" runat="server" Width="100%" TextMode="MultiLine"></asp:TextBox>
<asp:Label id="Label26" runat="server" Text='<%# Eval("ID") %>' Visible="False">
</asp:Label>
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
SqlParameter[] Params6 = new SqlParameter[2];
Params6[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号
Params6[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "综合题"); //题目类型
DataSet ds6 = DB.GetDataSet("Proc_PaperDetail", Params6);
GridView6.DataSource = ds6;
GridView6.DataBind();
public DataSet GetDataSet(string ProcName, SqlParameter[] Params)
{
Open();
SqlCommand Cmd = CreateCommand(ProcName, Params);
SqlDataAdapter adapter = new SqlDataAdapter(Cmd);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
Close();
return dataset;
}
Params6[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID);
Params6[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "综合题");
DataSet ds6 = DB.GetDataSet("Proc_PaperDetail", Params6);
这里是调用了存储过程,先是找到一张表,该表是一张试卷中所有题目的汇总,字段有试卷编号、题目类型type和标题ID,然后根据题目类型type和标题ID来找到每种题型各自的表单,里面字段有ID、CourseID、Title、Answer等。
private SqlCommand CreateCommand(string ProcName, SqlParameter[] Prams)
{
Open();
SqlCommand Cmd = new SqlCommand(ProcName, Connection);
Cmd.CommandType = CommandType.StoredProcedure;
if (Prams != null)
{
foreach (SqlParameter Parameter in Prams)
Cmd.Parameters.Add(Parameter);
}
return Cmd;
}