帮我纠正以下问题？ [英] Help me correct the following?
问题描述
有人能给我一个想法如何使这项工作？ 网络图片显示在下面的代码下方。 所有操作的sql都嵌入在代码中。 如果你觉得有能力并倾向于帮助我会感激不尽。
Can someone give me an Idea of how to make this work? The web image is shown below the code which follows. The sql for all operations is embedded in the code. If you feel capable and inclined to help I would be grateful.
<％@ Page Language =" VB" AutoEventWireup = QUOT假QUOT;的CodeFile = QUOT; Default.aspx.vb"继承= QUOT; _Default" ％>
<！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">
< asp：GridView ID =" GridView1" RUNAT = QUOT;服务器" AllowPaging = QUOT;真"
AllowSorting = QUOT;真"的AutoGenerateColumns = QUOT假QUOT;背景色= QUOT;＃DEBA84"
BORDERCOLOR ="＃DEBA84"边框= QUOT;无"边框宽度= QUOT; 1px的" CELLPADDING = QUOT; 3英寸
CELLSPACING = QUOT; 2英寸的DataSourceID = QUOT; SqlDataSource1"
EmptyDataText ="没有要显示的数据记录。
EnableModelValidation = QUOT;真"
style =" margin-left：6px; font-size：medium; margin-right：101px;"高度= QUOT; 631px"
Width =" 645px">
< Columns>
< asp：CommandField ButtonType =" Button"的ShowDeleteButton = QUOT;真"
ShowEditButton = QUOT;真" ShowSelectButton = QUOT;真" />
$
< asp：BoundField DataField =" FIRSTNAME"的HeaderText = QUOT; FIRSTNAME"
的SortExpression = QUOT; FIRSTNAME" />
$
< asp：BoundField DataField =" E_MAIL"的HeaderText = QUOT; E_MAIL"
的SortExpression = QUOT; E_MAIL" />
$
< asp：BoundField DataField =" LASTNAME"的HeaderText = QUOT; LASTNAME"
的SortExpression = QUOT; LASTNAME" />
$
< asp：BoundField DataField =" IDENTITY"的HeaderText = QUOT同一性QUOT;只读= QUOT;真"
的SortExpression = QUOT同一性QUOT; />
$
< /栏>
&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP; < FooterStyle BackColor ="＃F7DFB5"前景色= QUOT;＃8C4510" />
$
< HeaderStyle BackColor ="＃A55129"字体-粗体="真"前景色= QUOT;白色" />
$
< PagerStyle ForeColor ="＃8C4510" HorizontalAlign = QUOT;中心" />
$
< RowStyle BackColor ="＃FFF7E7"前景色= QUOT;＃8C4510" />
$
< SelectedRowStyle BackColor ="＃738A9C"字体-粗体="真"前景色= QUOT;白色" />
$
< / asp：GridView>
< asp：LinkButton ID =" INSERT" runat =" server"> ADDNEW< / asp：LinkButton>
< asp：SqlDataSource ID =" SqlDataSource1" RUNAT = QUOT;服务器"
ConnectionString ="<％$ ConnectionStrings：JulieDVDConnectionString1％>"
ProviderName ="<％$ ConnectionStrings：JulieDVDConnectionString1.ProviderName％>"
SelectCommand =" SELECT [E_MAIL]，[LASTNAME]，[FIRSTNAME]，[IDENTITY] FROM [REGIST]"
InsertCommand =" INSERT INTO [REGIST]（[E_MAIL]，[LASTNAME]，[FIRSTNAME]）VALUES（@ E_MAIL，@ LASTNAME，@ FIRSTNAME）"
DeleteCommand =" DELETE FROM [REGIST] WHERE [IDENTITY] = @ID"
UpdateCommand =" UPDATE [REGIST] SET [LASTNAME] = @LASTNAME，[FIRSTNAME] = @FIRSTNAME，[E_MAIL] = @E_MAIL WHERE [IDENTITY] = @IDENTITY
">
< DeleteParameters>
< asp：参数名称=" ID" />
$
< / DeleteParameters>
< InsertParameters>
< asp：Parameter Name =" E_MAIL"类型="字符串" />
$
< asp：Parameter Name =" LASTNAME"类型="字符串" />
$
< asp：Parameter Name =" FIRSTNAME" Type =" String" />
< / InsertParameters>
< UpdateParameters>&
< asp：Parameter Name =" LASTNAME" />
$
< asp：Parameter Name =" FIRSTNAME" />
$
< asp：Parameter Name =" E_MAIL" />
$
< asp：Parameter Name =" IDENTITY" />
$
< / UpdateParameters>
< / asp：SqlDataSource>
< div>
< / div>
< / form>
< / body>
< / html>
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!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">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" BackColor="#DEBA84"
BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3"
CellSpacing="2" DataSourceID="SqlDataSource1"
EmptyDataText="There are no data records to display."
EnableModelValidation="True"
style="margin-left: 6px; font-size: medium; margin-right: 101px;" Height="631px"
Width="645px">
<Columns>
<asp:CommandField ButtonType="Button" ShowDeleteButton="True"
ShowEditButton="True" ShowSelectButton="True" />
<asp:BoundField DataField="FIRSTNAME" HeaderText="FIRSTNAME"
SortExpression="FIRSTNAME" />
<asp:BoundField DataField="E_MAIL" HeaderText="E_MAIL"
SortExpression="E_MAIL" />
<asp:BoundField DataField="LASTNAME" HeaderText="LASTNAME"
SortExpression="LASTNAME" />
<asp:BoundField DataField="IDENTITY" HeaderText="IDENTITY" ReadOnly="True"
SortExpression="IDENTITY" />
</Columns>
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:LinkButton ID="INSERT" runat="server">ADDNEW</asp:LinkButton>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:JulieDVDConnectionString1 %>"
ProviderName="<%$ ConnectionStrings:JulieDVDConnectionString1.ProviderName %>"
SelectCommand="SELECT [E_MAIL], [LASTNAME], [FIRSTNAME], [IDENTITY] FROM [REGIST]"
InsertCommand="INSERT INTO [REGIST] ([E_MAIL], [LASTNAME], [FIRSTNAME]) VALUES (@E_MAIL, @LASTNAME, @FIRSTNAME)"
DeleteCommand="DELETE FROM [REGIST] WHERE [IDENTITY] = @ID "
UpdateCommand="UPDATE [REGIST] SET [LASTNAME] = @LASTNAME, [FIRSTNAME] = @FIRSTNAME, [E_MAIL] = @E_MAIL WHERE [IDENTITY] = @IDENTITY
">
<DeleteParameters>
<asp:Parameter Name="ID" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="E_MAIL" Type="String" />
<asp:Parameter Name="LASTNAME" Type="String" />
<asp:Parameter Name="FIRSTNAME" Type="String"/>
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="LASTNAME" />
<asp:Parameter Name="FIRSTNAME" />
<asp:Parameter Name="E_MAIL" />
<asp:Parameter Name="IDENTITY" />
</UpdateParameters>
</asp:SqlDataSource>
<div>
</div>
</form>
</body>
</html>
推荐答案
你究竟遇到什么问题？ 存储信息？ 将其拉出数据库？ 设置数据库？
What exactly are you having trouble with? Storing the information? Pulling it back out of the database? Setting up the database?
我可以尝试你的代码，但我不会测试它来查找错误。
I can try your code, but I'm not going to test it to find the errors.
这篇关于帮我纠正以下问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
