{"id":31,"date":"2008-04-14T12:23:48","date_gmt":"2008-04-14T12:23:48","guid":{"rendered":"http:\/\/tw.newtonstudio.com\/?p=31"},"modified":"2008-05-01T10:20:11","modified_gmt":"2008-05-01T10:20:11","slug":"aspnet-vb-%e7%94%a8usercontrol-%e5%bb%ba%e7%ab%8b%e5%bf%ab%e9%80%9f%e6%9f%a5%e8%a9%a2%e8%b3%87%e6%96%99","status":"publish","type":"post","link":"https:\/\/tw.newtonstudio.com\/?p=31","title":{"rendered":"ASP.NET (VB) \u7528UserControl \u5efa\u7acb\u5feb\u901f\u67e5\u8a62\u8cc7\u6599"},"content":{"rendered":"

UserControl\u662f .NET FRAMEWORK 2.0 \u975e\u5e38\u597d\u7528\u7684\u529f\u80fd,
\n\u4e00\u65e6\u7269\u4ef6\u5efa\u7acb\u4e4b\u5f8c, \u5305\u88dd\u8d77\u4f86. \u5c31\u53ef\u4ee5\u91cd\u8907\u4f7f\u7528.<\/p>\n

—<\/p>\n

testQuery.aspx<\/p>\n

—<\/p>\n

<%@ Page Language=”VB” %><\/p>\n

<%@ Register Src=”ucQueryCustomers.ascx” TagName=”ucQueryCustomers” TagPrefix=”uc1″ %><\/p>\n

<!DOCTYPE html PUBLIC “-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN” “http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd<\/a>“><\/p>\n

<script runat=”server”><\/p>\n

\u00a0\u00a0\u00a0 Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UcQueryCustomers1.Visible = True
\n\u00a0\u00a0\u00a0 End Sub<\/p>\n

\u00a0\u00a0\u00a0 ‘3, \u4f7f\u7528\u4e8b\u4ef6
\n\u00a0\u00a0\u00a0 Protected Sub UcQueryCustomers1_Selected(ByVal sender As Object, ByVal e As System.EventArgs)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TextBox1.Text = UcQueryCustomers1.CustomerID
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UcQueryCustomers1.Visible = False
\n\u00a0\u00a0\u00a0 End Sub
\n<\/script><\/p>\n

<html xmlns=”http:\/\/www.w3.org\/1999\/xhtml<\/a>” >
\n<head runat=”server”>
\n\u00a0\u00a0\u00a0 <title>Untitled Page<\/title>
\n<\/head>
\n<body>
\n\u00a0\u00a0\u00a0 <form id=”form1″ runat=”server”>
\n\u00a0\u00a0\u00a0 <div>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u8a02\u55ae<br \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <br \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Customer ID :
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:TextBox ID=”TextBox1″ runat=”server”><\/asp:TextBox>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Button ID=”Button1″ runat=”server” OnClick=”Button1_Click” Text=”…” \/><br \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <br \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <uc1:ucQueryCustomers ID=”UcQueryCustomers1″ runat=”server” Visible=”false” OnSelected=”UcQueryCustomers1_Selected” \/>
\n\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0 <\/div>
\n\u00a0\u00a0\u00a0 <\/form>
\n<\/body>
\n<\/html><\/p><\/blockquote>\n

———<\/p>\n

(User Control: UcQueryCustomers1.ascx)<\/p>\n

———<\/p>\n

<%@ Control Language=”VB” ClassName=”ucQueryCustomers” %><\/p>\n

<script runat=”server”><\/p>\n

\u00a0\u00a0\u00a0 Public ReadOnly Property CustomerID() As String
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Get
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Return GridView1.SelectedValue
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Get
\n\u00a0\u00a0\u00a0 End Property
\n\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0 ‘1, \u5c0d\u5916\u5ba3\u544a\u4e8b\u4ef6
\n\u00a0\u00a0\u00a0 Public Event Selected As EventHandler
\n\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0 ‘2, \u5728\u6b63\u78ba\u6642\u9593\u9ede\u89f8\u767c\u4e8b\u4ef6\u7d66\u5916\u754c
\n\u00a0\u00a0\u00a0 Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 RaiseEvent Selected(sender, e)
\n\u00a0\u00a0\u00a0 End Sub
\n<\/script><\/p>\n

<div>
\n\u00a0\u00a0\u00a0 \u67e5\u8a62 :
\n\u00a0\u00a0\u00a0 <asp:TextBox ID=”TextBox1″ runat=”server”><\/asp:TextBox>
\n\u00a0\u00a0\u00a0 <asp:Button ID=”Button1″ runat=”server” Text=”\u67e5\u8a62” \/><br \/>
\n\u00a0\u00a0\u00a0 <asp:GridView ID=”GridView1″ runat=”server” AllowPaging=”True” AutoGenerateColumns=”False”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CellPadding=”4″ DataKeyNames=”CustomerID” DataSourceID=”SqlDataSource1″ EmptyDataText=”There are no data records to display.”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ForeColor=”#333333″ GridLines=”None” OnSelectedIndexChanged=”GridView1_SelectedIndexChanged”>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <FooterStyle BackColor=”#1C5E55″ Font-Bold=”True” ForeColor=”White” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Columns>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:CommandField ShowSelectButton=”True” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:BoundField DataField=”CustomerID” HeaderText=”CustomerID” ReadOnly=”True” SortExpression=”CustomerID” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:BoundField DataField=”ContactTitle” HeaderText=”ContactTitle” SortExpression=”ContactTitle” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:BoundField DataField=”CompanyName” HeaderText=”CompanyName” SortExpression=”CompanyName” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:BoundField DataField=”ContactName” HeaderText=”ContactName” SortExpression=”ContactName” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Columns>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <RowStyle BackColor=”#E3EAEB” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <EditRowStyle BackColor=”#7C6F57″ \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <SelectedRowStyle BackColor=”#C5BBAF” Font-Bold=”True” ForeColor=”#333333″ \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <PagerStyle BackColor=”#666666″ ForeColor=”White” HorizontalAlign=”Center” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <HeaderStyle BackColor=”#1C5E55″ Font-Bold=”True” ForeColor=”White” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <AlternatingRowStyle BackColor=”White” \/>
\n\u00a0\u00a0\u00a0 <\/asp:GridView>
\n\u00a0\u00a0\u00a0 <asp:SqlDataSource ID=”SqlDataSource1″ runat=”server” ConnectionString=”<%$ ConnectionStrings:NorthwindConnectionString1 %>”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DeleteCommand=”DELETE FROM [Customers] WHERE [CustomerID] = @CustomerID” InsertCommand=”INSERT INTO [Customers] ([CustomerID], [ContactTitle], [CompanyName], [ContactName]) VALUES (@CustomerID, @ContactTitle, @CompanyName, @ContactName)”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ProviderName=”<%$ ConnectionStrings:NorthwindConnectionString1.ProviderName %>”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SelectCommand=”SELECT [CustomerID], [ContactTitle], [CompanyName], [ContactName] FROM [Customers] WHERE ([CompanyName] LIKE ‘%’ + @CompanyName + ‘%’)”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UpdateCommand=”UPDATE [Customers] SET [ContactTitle] = @ContactTitle, [CompanyName] = @CompanyName, [ContactName] = @ContactName WHERE [CustomerID] = @CustomerID”>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <DeleteParameters>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Parameter Name=”CustomerID” Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/DeleteParameters>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <UpdateParameters>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Parameter Name=”ContactTitle” Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Parameter Name=”CompanyName” Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Parameter Name=”ContactName” Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Parameter Name=”CustomerID” Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/UpdateParameters>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <SelectParameters>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:ControlParameter ControlID=”TextBox1″ Name=”CompanyName” PropertyName=”Text”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/SelectParameters>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <InsertParameters>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Parameter Name=”CustomerID” Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Parameter Name=”ContactTitle” Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Parameter Name=”CompanyName” Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <asp:Parameter Name=”ContactName” Type=”String” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/InsertParameters>
\n\u00a0\u00a0\u00a0 <\/asp:SqlDataSource>
\n<\/div><\/p><\/blockquote>\n

—————-<\/p>\n

\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

UserControl\u662f .NET FRAMEWORK 2.0 \u975e\u5e38\u597d\u7528\u7684\u529f\u80fd, \u4e00\u65e6\u7269\u4ef6\u5efa\u7acb\u4e4b\u5f8c, \u5305\u88dd\u8d77\u4f86 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-31","post","type-post","status-publish","format-standard","hentry","category-net-framework-aspx"],"_links":{"self":[{"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts\/31","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=31"}],"version-history":[{"count":0,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts\/31\/revisions"}],"wp:attachment":[{"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}