28-12-2006, 02:21
|
|
|
חבר מתאריך: 08.12.06
הודעות: 47
|
|
שאלה בארגון טבלה
שלום
יש לי בעיה בעיצוב טבלה
יש לי מסד נתונים SQL ודף ASPX
אני קורא לנתונים מהמסד ומציג אותם בדף
אבל כשאני מציג אותם הנתונים מסתדרים בטור אחד ואני רוצה לשנות זאת לשני טורים
זה הקוד
תודה
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<HTML>
<script language="VB" runat="server">
sub Page_Load(obj as Object, e as EventArgs)
'set up connection
dim myConnection as new OleDbConnection _
("Provider=sqloledb;Data Source=sex;Initial Catalog=asian;User Id=toy;Password=toy;")
'open connection
dim myCommand as new OleDbDataAdapter _
("SELECT * FROM asian", myConnection)
'fill dataset
dim ds as DataSet = new DataSet()
myCommand.Fill(ds, "asian")
'select data view and bind to server control
DataGrid1.DataSource = ds
DataGrid1.DataMember = "asian"
DataBind()
end sub
sub DataGrid1_Edit(obj as object, e as DataGridCommandEventArgs)
DataGrid1.EditItemIndex = e.Item.ItemIndex
DataGrid1.DataBind()
end sub
sub DataGrid1_Update(obj as object, e as DataGridCommandEventArgs)
'do updates
DataGrid1.DataBind()
end sub
sub DataGrid1_Cancel(obj as object, e as DataGridCommandEventArgs)
DataGrid1.EditItemIndex = -1
DataGrid1.DataBind()
end sub
sub DataGrid1_SortCommand(obj as Object, _
e as DataGridSortCommandEventArgs)
' sort the data using the SortField property
' of the eventargs
DataGrid1.DataBind()
End Sub
sub DataGrid1_PageIndexChanged(obj as Object, e as DataGridPageChangedEventArgs)
DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataBind()
end sub
</script>
<HEAD>
<TITLE>
</TITLE>
</HEAD>
<script language="JavaScript">
document.linkColor="blue"
</script>
<script language="JavaScript">
document.vlinkColor="blue"
</script>
<BODY bgcolor="black">
<center>
</a>
<table bgcolor="gray" width="705" height="6" border="3" cellspacing="0" cellpadding="1" align="center">
<tr><td style="background='gray'; font-size:16px; cursor:hand" onmouseover="this.style.background='#3366CC'"
onmouseout="this.style.background='gray'"><center><a href="index.asp">תפריט ראשי</td>
<td style="background='gray'; font-size:16px; cursor:hand" onmouseover="this.style.background='#3366CC'"
onmouseout="this.style.background='gray'"><center></td></tr>
<center>
<form runat="server">
<aspataGrid id="DataGrid1" runat="server"
BorderColor="gray"
GridLines="horizontal"
cellpadding="5"
cellspacing="0"
width="705"
Font-NameFont-Names="david"
Font-Size="14pt"
ShowFooter="false"
HeaderStyle-BackColor="gray"
FooterStyle-BackColor="black"
ItemStyle-BackColor="black"
AlternatingItemStyle-Backcolor="black"
AutoGenerateColumns="false"
AllowSorting="true"
OnEditCommand="DataGrid1_Edit"
OnCancelCommand="DataGrid1_Cancel"
OnUpdateCommand="DataGrid1_Update"
AllowPaging="true"
PageSize="8"
PagerStyle-Mode=NumericPages
PagerStyle-PageButtonCount="2"
OnPageIndexChanged="DataGrid1_PageIndexChanged">
<Columns>
<asp:TemplateColumn HeaderText="אסיאתיות">
<ItemTemplate >
<%# Container.DataItem("link") %>
<%# Container.DataItem("pic") %>
<%# Container.DataItem("date") %>
<%# Container.DataItem("category") %>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</aspataGrid>
</form>
</HTML>
|