Hi! I'm a novice in asp .net
I've a SqlDataSource component on an Aspx page.
In the associated C# file, I would like to use datas from the query stored in the SqlDataSource component.
How to do this?
Thanxs :)
An example
<%@.PageLanguage="C#" %>
<%@.ImportNamespace="System.Data" %>
<!DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<scriptrunat="server">
protected void Page_Load(object sender, EventArgs e)
{
DataView dv = (DataView)SqlDataSource1.Select(new DataSourceSelectArguments());
DataTable dt = dv.Table;
// display table
bool pagesToDo = true;
int index = 0;
while (pagesToDo)
{
Table t = GetDisplayTable(dt);
t.CssClass = "PageBreakStyle";
Controls.Add(t);
int nextPageEndsAt = index + 10;
while (index < nextPageEndsAt && pagesToDo)
{
TableRow tr = new TableRow();
t.Rows.Add(tr);
foreach (DataColumn dc in dt.Columns)
{
TableCell tc = new TableCell();
tr.Cells.Add(tc);
tc.Text = dt.Rows[index][dc.ColumnName].ToString();
}
index++;
if (index == dt.Rows.Count)
{
pagesToDo = false;
break;
}
}
}
}
Table GetDisplayTable(DataTable dt)
{
Table t =newTable();
TableHeaderRow thr =newTableHeaderRow();
t.Rows.Add(thr);
foreach (DataColumn dcin dt.Columns)
{
TableHeaderCell thc =newTableHeaderCell();
thc.Text = dc.ColumnName;
thr.Cells.Add(thc);
}
return t;
}
</script>
<htmlxmlns="http://www.w3.org/1999/xhtml">
<headrunat="server">
<title>Untitled Page</title>
<styletype="text/css">
.PageBreakStyle
{
page-break-after:always;
}
</style>
</head>
<body>
<formid="form1"runat="server">
<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [ProductID], [ProductName] FROM [Products]"></asp:SqlDataSource>
</form>
</body>
</html>
|||Thanks, it works!
very cool man ^^
No comments:
Post a Comment