以下是快速入门中的示例程序:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html><script language="C#" runat="server"> SqlConnection myConnection; void Page_Load(Object sender, EventArgs e) { myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated Security=SSPI"); if (!Page.IsPostBack) {
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles where type = 'business'", myConnection); DataSet ds = new DataSet();
myCommand.Fill(ds, "Titles"); MyDataList.DataSource=ds.Tables["Titles"].DefaultView;
MyDataList.DataBind();
} } void MyDataList_Select(Object sender, EventArgs e) { String title = MyDataList.DataKeys[MyDataList.SelectedItem.ItemIndex].ToString();
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles where title_id = '" + title + "'" , myConnection); DataSet ds = new DataSet();
myCommand.Fill(ds, "TitleDetails"); DataRowView rowview = ds.Tables["TitleDetails"].DefaultView[0]; DetailsImage.Src = "/quickstart/aspplus/images/title-" + rowview["title_id"] + ".gif";
DetailsPubId.InnerHtml = "<b>Publisher ID: </b>" + rowview["pub_id"].ToString() + "<br>";
DetailsTitleId.InnerHtml = "<b>Title ID: </b>" + rowview["title_id"].ToString() + "<br>";
DetailsType.InnerHtml = "<b>Category: </b>" + rowview["type"].ToString() + "<br>";
DetailsPrice.InnerHtml = "<b>Price: </b> $ " + rowview["price"].ToString() + "<p>";
PurchaseLink.InnerHtml = "<img border='0' src='/quickstart/aspplus/images/purchase_book.gif' >";
PurchaseLink.HRef="purchase.aspx?titleid=" + rowview["title_id"].ToString();
DetailsTitle.InnerHtml = rowview["title"].ToString(); DetailsImage.Visible = true;
}</script><body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0"> <form runat="server">
<table width="100%">
<tr>
<td width="50%"> <ASP:DataList id="MyDataList" OnSelectedIndexChanged="MyDataList_Select" DataKeyField="title_id" runat="server"> <ItemTemplate> <table cellpadding=10 style="font: 10pt verdana">
<tr>
<td valign="top">
<img align="top" width="25" border=1 src='<%# DataBinder.Eval(Container.DataItem, "title_id", "/quickstart/aspplus/images/title-{0}.gif") %>' runat="server"/>
</td>
<td valign="top">
<b>Title: </b>
<asp:linkbutton Text='<%# DataBinder.Eval(Container.DataItem, "title") %>' CommandName="Select" style="color:darkred" runat="server"/>
<br>
<b>Price: </b><%# DataBinder.Eval(Container.DataItem, "price", "$ {0}") %><br>
</td>
</tr>
</table> </ItemTemplate> </ASP:DataList> </td> <td valign="top" style="padding-top:15" width="50%">
<table cellpadding="5" width="100%" style="font: 10pt verdana">
<tr>
<td>
<img id="DetailsImage" visible="false" runat="server">
</td>
<td valign="top" width="400">
<div style="font: 12pt verdana;color:darkred">
<i><b><span id="DetailsTitle" runat="server"/></i></b><br>
</div>
<span id="DetailsTitleId" runat="server"/>
<span id="DetailsPubId" runat="server"/>
<span id="DetailsType" runat="server"/>
<span id="DetailsPrice" runat="server"/>
<a id="PurchaseLink" runat="server"/>
</td>
</tr>
</table>
</td> </tr>
</table>
</form></body>
</html>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html><script language="C#" runat="server"> SqlConnection myConnection; void Page_Load(Object sender, EventArgs e) { myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated Security=SSPI"); if (!Page.IsPostBack) {
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles where type = 'business'", myConnection); DataSet ds = new DataSet();
myCommand.Fill(ds, "Titles"); MyDataList.DataSource=ds.Tables["Titles"].DefaultView;
MyDataList.DataBind();
} } void MyDataList_Select(Object sender, EventArgs e) { String title = MyDataList.DataKeys[MyDataList.SelectedItem.ItemIndex].ToString();
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles where title_id = '" + title + "'" , myConnection); DataSet ds = new DataSet();
myCommand.Fill(ds, "TitleDetails"); DataRowView rowview = ds.Tables["TitleDetails"].DefaultView[0]; DetailsImage.Src = "/quickstart/aspplus/images/title-" + rowview["title_id"] + ".gif";
DetailsPubId.InnerHtml = "<b>Publisher ID: </b>" + rowview["pub_id"].ToString() + "<br>";
DetailsTitleId.InnerHtml = "<b>Title ID: </b>" + rowview["title_id"].ToString() + "<br>";
DetailsType.InnerHtml = "<b>Category: </b>" + rowview["type"].ToString() + "<br>";
DetailsPrice.InnerHtml = "<b>Price: </b> $ " + rowview["price"].ToString() + "<p>";
PurchaseLink.InnerHtml = "<img border='0' src='/quickstart/aspplus/images/purchase_book.gif' >";
PurchaseLink.HRef="purchase.aspx?titleid=" + rowview["title_id"].ToString();
DetailsTitle.InnerHtml = rowview["title"].ToString(); DetailsImage.Visible = true;
}</script><body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0"> <form runat="server">
<table width="100%">
<tr>
<td width="50%"> <ASP:DataList id="MyDataList" OnSelectedIndexChanged="MyDataList_Select" DataKeyField="title_id" runat="server"> <ItemTemplate> <table cellpadding=10 style="font: 10pt verdana">
<tr>
<td valign="top">
<img align="top" width="25" border=1 src='<%# DataBinder.Eval(Container.DataItem, "title_id", "/quickstart/aspplus/images/title-{0}.gif") %>' runat="server"/>
</td>
<td valign="top">
<b>Title: </b>
<asp:linkbutton Text='<%# DataBinder.Eval(Container.DataItem, "title") %>' CommandName="Select" style="color:darkred" runat="server"/>
<br>
<b>Price: </b><%# DataBinder.Eval(Container.DataItem, "price", "$ {0}") %><br>
</td>
</tr>
</table> </ItemTemplate> </ASP:DataList> </td> <td valign="top" style="padding-top:15" width="50%">
<table cellpadding="5" width="100%" style="font: 10pt verdana">
<tr>
<td>
<img id="DetailsImage" visible="false" runat="server">
</td>
<td valign="top" width="400">
<div style="font: 12pt verdana;color:darkred">
<i><b><span id="DetailsTitle" runat="server"/></i></b><br>
</div>
<span id="DetailsTitleId" runat="server"/>
<span id="DetailsPubId" runat="server"/>
<span id="DetailsType" runat="server"/>
<span id="DetailsPrice" runat="server"/>
<a id="PurchaseLink" runat="server"/>
</td>
</tr>
</table>
</td> </tr>
</table>
</form></body>
</html>
解决方案 »
- 怎么获取按下键盘的信息,比如在计算器中。我按下键盘的1、2、3……可以知道按下对应的数字键。
- C#连结InterBase数据库的问题??
- 时间加减问题 马上给分
- 菜鸟求助:c#写的视频程序,拷到别人机子上的exe文件打不开(该机器上有framework2.0)
- webservice怎么访问不了
- 为什么我用c#追加xml节点,这个xml文件一直没有反映呀,各位朋友帮忙看看,先谢谢各位了
- datagrid 删除记录出错?如何修改删除事件
- RichTextbox中内容选中一段然后撤销选中
- 关于DirectoryInfo的问题!
- 怎么没有人回答小弟的问题呀:(
- SQL语句中处理分号和的问题
- 给 qiuji(忆秋季)
不是我贴地不对啊,以前对asp不怎么了解
比较弱地问题啊!
望指点..
hehe
<asp:datalist id="DtLFeedback" runat="server" Width="100%" BorderColor="#999999" BorderStyle="None"
BackColor="White" CellPadding="3" GridLines="Vertical" BorderWidth="1px" RepeatColumns="1">
<SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#008A8C"></SelectedItemStyle>
<AlternatingItemStyle BackColor="Gainsboro"></AlternatingItemStyle>
<ItemStyle ForeColor="Black" CssClass="Grid" BackColor="#EEEEEE"></ItemStyle>
<ItemTemplate>
<b>
<%# DataBinder.Eval(Container, "DataItem.yhmc") %>
:</b>
<%# DataBinder.Eval(Container, "DataItem.FeedbackContent") %>
<%# DataBinder.Eval(Container, "DataItem.FeedBackTime") %>
</ItemTemplate>
</asp:datalist>
cs文件中 DtLFeedback.DataSource = mydv;
DtLFeedback.DataBind();