很简单的一个功能,提交按钮保存文本框中内容到数据库,可是我太笨了,看了2月书了,自己一操作还是不会,贴出代码,求指点,谢谢了<%@ Page Language="C#" AutoEventWireup="true" CodeFile="1.aspx.cs" Inherits="_1" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Label ID="Label1" runat="server" Text="姓名"></asp:Label>
<br />
<asp:Button ID="Button1" runat="server" Text="提交" OnCommand="InsertCommand" />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
onselecting="SqlDataSource1_Selecting" SelectCommand="SELECT * FROM [1]"
InsertCommand="INSERT 1(name) VALUE (@name)"
>
<InsertParameters>
<asp:ControlParameter ControlID="TextBox1" Name="name" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>请问哪里错了?正确的做法如何写呢?另外想找个师傅,本人28岁了...
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Label ID="Label1" runat="server" Text="姓名"></asp:Label>
<br />
<asp:Button ID="Button1" runat="server" Text="提交" OnCommand="InsertCommand" />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
onselecting="SqlDataSource1_Selecting" SelectCommand="SELECT * FROM [1]"
InsertCommand="INSERT 1(name) VALUE (@name)"
>
<InsertParameters>
<asp:ControlParameter ControlID="TextBox1" Name="name" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>请问哪里错了?正确的做法如何写呢?另外想找个师傅,本人28岁了...
解决方案 »
- 怎么通过客户端去获取服务器端的盘文件?
- 奇怪的url重写问题,大家帮忙看一下,重写后的样式问题
- 关于js的2级联动问题!!!!!!!!!!!!!!
- showModalDialog传值的问题
- 急需Crystal Reports水晶报表中的一个jar包!!!
- 难题,望高手进入!分不够说再加
- 用.net作文件下载,中文名限制长度,如何处理,急!!!!!!!!!在线等。等思归大哥。
- 在VS2005 GRIDVIEW 不能编辑
- RequiredFieldValidator使其出现提示时是弹出框,就象<script>的弹出对话框一样的,要设置哪个属性?
- 怎样用DirectoryInfo过滤我想要得文件格式,例如*.jpg *.gif?
- 有经验的高手帮我看看我的想法能否实现
- DropdownList 绑定Sqldatasource 后再添加一行值(--请选择--)如何
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.insert.aspx也就是在网页前面加上
<script runat="server">
private void InsertShipper (object source, EventArgs e) {
SqlDataSource1.Insert();
}
</script>在按钮里加上onclick="InsertShipper"就应该可以了。
当然你可以把函数都改成InsertName。
试一下吧!
ASP.NET 2.0数据教程
<script runat="server">
private void InsertShipper (object source, EventArgs e) {
SqlDataSource1.Insert();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title></head>
<body>
<form id="form1" runat="server">
<div>
<table >
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="标题:"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="2">
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"
ReadOnly="True" SortExpression="id" />
<asp:BoundField DataField="title" HeaderText="title" SortExpression="title" />
</Columns>
</asp:GridView>
<asp:sqldatasource
id="SqlDataSource1"
runat="server"
connectionstring="<%$ ConnectionStrings:ConnectionString %>"
selectcommand="SELECT * FROM [919]"
insertcommand="insert (title) values (@title)"
>
<InsertParameters>
<asp:FormParameter Name="title" FormField="TextBox1" />
</InsertParameters>
</asp:sqldatasource>
</td>
</tr>
</table>
<br />
<asp:button
id="Button1"
runat="server"
text="保存到数据库"
onclick="InsertShipper" /> </div>
</form>
</body>
</html>提示:第6行有语法错误行 6: SqlDataSource1.Insert();