aspx.net的代码
<asp:FormView ID="FormView1" DataKeyNames="xxid" DefaultMode="Edit" AllowPaging="true" runat="server" DataSourceID="SDSxxid" >
<EditItemTemplate>
<a href="Default.aspx">首页</a> > <a href="">投稿</a> > 新文章
<h2>建立新文章</h2>
<asp:ValidationSummary ID="ValidationSummary1" runat="server"></asp:ValidationSummary>
<fieldset>
<asp:Label ID="Label1" AssociatedControlID="Title" runat="server">标题:</asp:Label>
<asp:TextBox ID="Title" runat="server" Text='<%#Bind("Title") %>'/>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="您没提供文章的标题。" ControlToValidate="Title">*</asp:RequiredFieldValidator>
</fieldset>
<fieldset>
<asp:Label ID="LAAuthor" AssociatedControlID="Author" runat="server">作者:</asp:Label>
<asp:TextBox ID="Author" runat="server" Text='<%#Bind("Author")%>'/>
<asp:RequiredFieldValidator ID="Re" runat="server" ErrorMessage="您没填写作者." ControlToValidate="Author">*</asp:RequiredFieldValidator>
</fieldset>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
在asp.net的cs中的代码
//创建连接数据库对象
SqlConnection myconn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Math.mdf;Integrated Security=True;User Instance=True");
myconn.Open();
//创建SqlCommand对象
SqlCommand mycomd = new SqlCommand("StoredUpdateMytable", myconn);
mycomd.CommandType = CommandType.StoredProcedure;
//添加参数
SqlParameter[] prams=
{
new SqlParameter("@xxid",SqlDbType.Int,4),
new SqlParameter("@department",SqlDbType.Text,2147483647),
new SqlParameter("@Author",SqlDbType.NChar,10),
new SqlParameter("@Title",SqlDbType.Text,2147483647),
new SqlParameter("@Mathcontent",SqlDbType.Text,2147483647),
new SqlParameter("@pic",SqlDbType.NChar,10),
new SqlParameter("@Date",SqlDbType.NChar,10),
new SqlParameter("@link",SqlDbType.NChar,10)
};
//给参数赋值
prams[0].Value = department.SelectedValue;
prams[1].Value=Author.Text;
prams[2].Value=Title.Text;
prams[3].Value=Mathcontent.Text;
prams[4].Value="pic.Text";
prams[5].Value=System.DateTime.Now.ToString();
prams[6].Value="sdLinkButton";
prams[7].Value =xxid.Value;
foreach(SqlParameter parameter in prams)
{
mycomd.Parameters.Add(parameter);
}
为什么提示没有department,Author等已绑定数据的控件呢????????????
<asp:FormView ID="FormView1" DataKeyNames="xxid" DefaultMode="Edit" AllowPaging="true" runat="server" DataSourceID="SDSxxid" >
<EditItemTemplate>
<a href="Default.aspx">首页</a> > <a href="">投稿</a> > 新文章
<h2>建立新文章</h2>
<asp:ValidationSummary ID="ValidationSummary1" runat="server"></asp:ValidationSummary>
<fieldset>
<asp:Label ID="Label1" AssociatedControlID="Title" runat="server">标题:</asp:Label>
<asp:TextBox ID="Title" runat="server" Text='<%#Bind("Title") %>'/>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="您没提供文章的标题。" ControlToValidate="Title">*</asp:RequiredFieldValidator>
</fieldset>
<fieldset>
<asp:Label ID="LAAuthor" AssociatedControlID="Author" runat="server">作者:</asp:Label>
<asp:TextBox ID="Author" runat="server" Text='<%#Bind("Author")%>'/>
<asp:RequiredFieldValidator ID="Re" runat="server" ErrorMessage="您没填写作者." ControlToValidate="Author">*</asp:RequiredFieldValidator>
</fieldset>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
在asp.net的cs中的代码
//创建连接数据库对象
SqlConnection myconn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Math.mdf;Integrated Security=True;User Instance=True");
myconn.Open();
//创建SqlCommand对象
SqlCommand mycomd = new SqlCommand("StoredUpdateMytable", myconn);
mycomd.CommandType = CommandType.StoredProcedure;
//添加参数
SqlParameter[] prams=
{
new SqlParameter("@xxid",SqlDbType.Int,4),
new SqlParameter("@department",SqlDbType.Text,2147483647),
new SqlParameter("@Author",SqlDbType.NChar,10),
new SqlParameter("@Title",SqlDbType.Text,2147483647),
new SqlParameter("@Mathcontent",SqlDbType.Text,2147483647),
new SqlParameter("@pic",SqlDbType.NChar,10),
new SqlParameter("@Date",SqlDbType.NChar,10),
new SqlParameter("@link",SqlDbType.NChar,10)
};
//给参数赋值
prams[0].Value = department.SelectedValue;
prams[1].Value=Author.Text;
prams[2].Value=Title.Text;
prams[3].Value=Mathcontent.Text;
prams[4].Value="pic.Text";
prams[5].Value=System.DateTime.Now.ToString();
prams[6].Value="sdLinkButton";
prams[7].Value =xxid.Value;
foreach(SqlParameter parameter in prams)
{
mycomd.Parameters.Add(parameter);
}
为什么提示没有department,Author等已绑定数据的控件呢????????????
<a href="Default.aspx">首页</a> > <a href="">投稿</a> > 新文章
<h2>建立新文章</h2>
<asp:ValidationSummary ID="ValidationSummary1" runat="server"></asp:ValidationSummary>
<fieldset>
<asp:Label ID="Label1" AssociatedControlID="Title" runat="server">标题:</asp:Label>
<asp:TextBox ID="Title" runat="server" Text='<%#Bind("Title") %>'/>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="您没提供文章的标题。" ControlToValidate="Title">*</asp:RequiredFieldValidator>
</fieldset>
<fieldset>
<asp:Label ID="LAAuthor" AssociatedControlID="Author" runat="server">作者:</asp:Label>
<asp:TextBox ID="Author" runat="server" Text='<%#Bind("Author")%>'/>
<asp:RequiredFieldValidator ID="Re" runat="server" ErrorMessage="您没填写作者." ControlToValidate="Author">*</asp:RequiredFieldValidator>
</fieldset>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
<%--列出栏目--%>
<fieldset>
<asp:Label ID="Label2" AssociatedControlID="department" runat="server">栏目:</asp:Label>
<asp:DropDownList ID="department" DataSourceID="selectdepartment" DataValueField="department" runat="server" DataTextField="department" >
</asp:DropDownList>
</fieldset>
<fieldset>
<asp:Label ID="Label3" AssociatedControlID="Mathcontent" runat="server">内容:</asp:Label>
<asp:TextBox ID="Mathcontent" runat="server" TextMode="MultiLine" Rows="20" Columns="120" Text='<%#Bind("Mathcontent")%>'/>
<%--<script type="text/javascript" src="widgEditor.js"></script>--%>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="您没提供内容。" ControlToValidate="Mathcontent">*</asp:RequiredFieldValidator>
</fieldset>
<asp:Button ID="btnCreateEntry" runat="server" Text="保存" OnClick="btnCreateEdit">
</asp:Button>
<asp:Button ID="btnCancel" runat="server" Text="取消" CausesValidation="False" OnClick="btnCancelNew">
</asp:Button>
<asp:HiddenField ID="xxid" runat="server" Value='<%#Bind("xxid")%>' />
</EditItemTemplate>
prams[1].Value=Author.Text;
prams[2].Value=Title.Text;
prams[3].Value=Mathcontent.Text;
prams[4].Value="pic.Text";
prams[5].Value=System.DateTime.Now.ToString();
prams[6].Value="sdLinkButton";
prams[7].Value =xxid.Value;
这部分提示找不到控件name
试试这个!!!