就是要改变前台SqlDataSource InsertCommand所产生的sql 语句,想加个字段
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SelClassConnectionString %>"
InsertCommand="INSERT INTO [zjut_examClassTable] ([examDate] , [examTime], [examPlace],[examDiffType],[studentNumb],[re],[examId]) VALUES (@examDate, @examTime, @examPlace, @examDiffType, @studentNumb, @re,@examId) "
<InsertParameters>
<asp:Parameter Name="examDate" />
<asp:Parameter Name="examTime" />
<asp:Parameter Name="examPlace" />
<asp:Parameter Name="examDiffType" />
<asp:Parameter Name="studentNumb" />
<asp:Parameter Name="re" /> <asp:Parameter Name="examId" /> (这个属性)
</InsertParameters>
</asp:SqlDataSource>
我想在 SqlDataSource插入一条语句时,examId 的值有后台程序来赋值
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SelClassConnectionString %>"
InsertCommand="INSERT INTO [zjut_examClassTable] ([examDate] , [examTime], [examPlace],[examDiffType],[studentNumb],[re],[examId]) VALUES (@examDate, @examTime, @examPlace, @examDiffType, @studentNumb, @re,@examId) "
<InsertParameters>
<asp:Parameter Name="examDate" />
<asp:Parameter Name="examTime" />
<asp:Parameter Name="examPlace" />
<asp:Parameter Name="examDiffType" />
<asp:Parameter Name="studentNumb" />
<asp:Parameter Name="re" /> <asp:Parameter Name="examId" /> (这个属性)
</InsertParameters>
</asp:SqlDataSource>
我想在 SqlDataSource插入一条语句时,examId 的值有后台程序来赋值
protected void SqlDataSource1_Inserting(object sender, SqlDataSourceCommandEventArgs e)
{
e.Command.Parameters["examId"].Value = examId2;
}
但提示
此 SqlParameterCollection 中未包含带有 ParameterName“examId”的 SqlParameter。
protected void SqlDataSource1_Inserting(object sender, SqlDataSourceCommandEventArgse)
行 55: {
行 56: e.Command.Parameters["examId"].Value = examId2;
行 57: }
行 58: protected void SqlDataSource1_Init(object sender, EventArgs e)