如何利用AccessDataSource控件给mdb数据库插入数据？
我想把textbox1和textbox2的内容通过Button1和AccessDataSource提交到mdb数据库中A表中o、p 2个列里，应该怎么做？请各位指点。
谢谢
问题点数：100、回复次数：13Top
1 楼zahuifan（杂烩饭）回复于 2006-07-01 10:41:00 得分 0
AccessDataSource? 是VS2005吧？对不起，俺也不熟，帮不了你了。不过你可以参考VS2005自带的例子呀。在.Net 2.0 Framwork 的SDK文件夹下。如果找不到，是因为你没装。你将安装光盘放在光驱里，看看是不是没装示例文件Top
2 楼Knight94（愚翁）回复于 2006-07-01 10:55:45 得分 0
参看
http://msdn2.microsoft.com/zh-cn/library/system.web.ui.webcontrols.accessdatasource.aspxTop
3 楼myminimouse（坚决不用baidu）回复于 2006-07-01 15:50:09 得分 0
jfTop
4 楼cainiaoxuefei（萍水相逢,尽是他人之妻）回复于 2006-07-01 19:21:36 得分 0
各位 顶者有分！Top
5 楼xiaoge22275（对ASP又爱又恨）回复于 2006-07-01 19:54:15 得分 0
至少要在配置数据源那里有个高级选项,把"update"和"delete"自动生成功能选上.
与DataView绑定时就自动可以完成你要的功能了,与其他控件绑定,如何自动完成还不知道呢.
关注~!Top
6 楼cainiaoxuefei（萍水相逢,尽是他人之妻）回复于 2006-07-02 09:58:39 得分 0
upTop
7 楼truelove12（结贴者寥寥无几,心寒ing...）回复于 2006-07-02 10:35:12 得分 0
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="gridview2.aspx.vb" Inherits="gridview2" %>
<!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:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
CellSpacing="1" DataKeyNames="id" DataSourceID="userinfodatasource" ForeColor="#333333"
GridLines="None">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="id" HeaderText="编号" InsertVisible="False" ReadOnly="True"
SortExpression="id" />
<asp:TemplateField HeaderText="姓名" SortExpression="usr">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("usr") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("usr") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="insert_tb_usr" runat="server" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="密码" SortExpression="pwd">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("pwd") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("pwd") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="insert_tb_pwd" runat="server" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<FooterTemplate>
<asp:button id="btn_add" runat="server" Text="提交" OnClick="add_click" />
<asp:button id="btn_cancel" runat="server" Text="放弃" OnClick="cancle_click" />
</FooterTemplate>
</asp:TemplateField>
</Columns>
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<EditRowStyle BackColor="#999999" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
<asp:AccessDataSource ID="userinfodatasource" runat="server" ConflictDetection="CompareAllValues"
DataFile="~/App_Data/db.mdb" DeleteCommand="DELETE FROM [userinfo] WHERE [id] = ? AND [usr] = ? AND [pwd] = ?"
InsertCommand="INSERT INTO [userinfo] ([usr], [pwd]) VALUES (?, ?)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [userinfo]"
UpdateCommand="UPDATE [userinfo] SET [usr] = ?, [pwd] = ? WHERE [id] = ? AND [usr] = ? AND [pwd] = ?">
<DeleteParameters>
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_usr" Type="String" />
<asp:Parameter Name="original_pwd" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="usr" Type="String" />
<asp:Parameter Name="pwd" Type="String" />
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_usr" Type="String" />
<asp:Parameter Name="original_pwd" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="usr" Type="String" />
<asp:Parameter Name="pwd" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
<br />
<asp:Button ID="Button1" runat="server" Text="添加数据" /></div>
</form>
</body>
</html>
Top
8 楼truelove12（结贴者寥寥无几,心寒ing...）回复于 2006-07-02 10:35:25 得分 0
Partial Class gridview2
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Sub add_click(ByVal sender As Object, ByVal e As EventArgs)
Dim usr As String = CType(GridView1.FooterRow.FindControl("insert_tb_usr"), TextBox).Text
Dim pwd As String = CType(GridView1.FooterRow.FindControl("insert_tb_pwd"), TextBox).Text
userinfodatasource.InsertParameters("usr").DefaultValue = usr
userinfodatasource.InsertParameters("pwd").DefaultValue = pwd
userinfodatasource.Insert()
End Sub
Sub cancle_click(ByVal sender As Object, ByVal e As EventArgs)
GridView1.ShowFooter = False
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
GridView1.ShowFooter = True
End Sub
End Class
Top
9 楼longzhongyang（）回复于 2006-07-02 11:27:52 得分 0
ssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssTop
10 楼cainiaoxuefei（萍水相逢,尽是他人之妻）回复于 2006-07-03 21:33:56 得分 0
给个C#代码？Top
11 楼truelove12（结贴者寥寥无几,心寒ing...）回复于 2006-07-03 23:00:17 得分 0
晕.后代码就那么几句,很通用的.
UI界面的内容都是一样的啊.
哎,哪有不学习直接要代码的?
Top
12 楼fengyeng（在城里飘～～～～）回复于 2006-07-04 12:05:17 得分 0
upTop
13 楼cainiaoxuefei（萍水相逢,尽是他人之妻）回复于 2006-07-06 15:15:59 得分 0
upTop
