yavari
شنبه 16 اردیبهشت 1385, 15:24 عصر
سلام
دوست عزیز ، اینم کدم !
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="DefineSoftware.aspx.vb" Inherits="TinaTeam.DefineSoftware"%>
<%@ import namespace ="system.data.oledb" %>
<%@ import namespace ="system.data" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>DefineSoftware</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="Visual Basic .NET 7.1" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<script language="vb" runat="server">
Sub Pag_Load(ByVal src As Object, ByVal e As EventArgs)
If Not ispostback Then
bindListcontrol()
End If
End Sub
Sub bindListcontrol()
Dim Cnn As OleDbConnection
Dim OleAdapter As OleDbDataAdapter
Dim CnnStr, SqlStr As String
Dim Dset As New DataSet
Cnnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(".\data\tinateam.mdb")
sqlstr = "SELECT ID,Software,price,SummeryDes FROM Software ORDER BY Id"
cnn = New OleDbConnection(Cnnstr)
cnn.open()
OleAdapter = New OleDbDataAdapter(SqlStr, Cnn)
OleAdapter.fill(dset, "software")
repeater1.datasource = dset.tables("software")
repeater1.databind()
End Sub
</script>
<body>
<form runat="server">
<asp:Repeater ID=repeater1 Runat="server">
<HeaderTemplate ><table></table></HeaderTemplate>
<ItemTemplate ><tr>
<td><asp:Image Height=100 Width=100
img src='<%container.dataitem(".\header.jpg")%>' Runat="server"/>
</td><td>
شماره :
<asp:Button Text=<%# container.dataitem("id")%> Runat="server" /><br/>
خلاصه توضیحات : <b><i>
<%# container.dataitem("software")%></b></i><br/>
<b> قیمت :
<%# formatcurrency(container.dataitem("price"))%> Runat="server"/></b><br/>
</td></tr>
</ItemTemplate>
<footerTemplate ></table></footerTemplate>
</asp:Repeater>
</form>
</body>
</HTML>
ممنون میشم راهنمائیم کنید