I have successfully built a form page to enter customer info into sqlserver
2000. I would now like to be able to pul it up and edit it in a Winows form
format rather than a datagrid. (Like asp) I have seen it on several
websites including Dell's checkout page. I have been looking for examples of
VB code to do this with no luck.
Here is my dataset and datalist with my feeble attempt at populating a
textbox. (The datalist works fine.) Can someone get me started or send me to
good code examples please?
<code>
<%@ Page Language="VB" Debug="true" ContentType="text/html"
ResponseEncoding="iso-8859-1" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server">
sub Page_Load(Sender as Object, e as EventArgs)
Dim objConn As SqlConnection = New SqlConnection("Data Source=localhost;" & _
"Integrated Security=true;UID=Newlogin;PWD=cool147;Initial Catalog=PLF")
dim objCmd as SqlDataAdapter = new SqlDataAdapter _
("select * from Customers where CustomerID like 28", objConn)
dim ds as dataset = new Dataset()
objCmd.Fill(ds, "Customers")
'select data view and bind to server control
MyDataList.DataSource = ds.Tables("Customers"). _
DefaultView
MyDataList.Databind()
objConn.close()
end sub
</Script>
<html>
<head>
</head>
<body>
<link REL="stylesheet" HREF="css/maincss.css" TYPE="text/css">
<form runat="server"><asp:DataList id="MyDataList" RepeatColumns="1"
Repeatdirection="Vertical"
runat="server">
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "FirstName") %>
<asp:TextBox id="firstname" value="<%# DataBinder.Eval(Container.DataItem,
"FirstName") %>"runat="server" />
<%# DataBinder.Eval(Container.DataItem, "LastName") %><br>
<%# DataBinder.Eval(Container.DataItem, "CompanyName") %><br>
<%# DataBinder.Eval(Container.DataItem, "Address1") %><br>
<%# DataBinder.Eval(Container.DataItem, "City") %>,
<%# DataBinder.Eval(Container.DataItem, "State") %>
<%# DataBinder.Eval(Container.DataItem, "ZipCode") %><br>
<%# DataBinder.Eval(Container.DataItem, "HomeNumber") %><br>
</ItemTemplate>
</asp:DataList>
</Form>
</code>