Sorting in Grid View - ASP.NET Discussion Boards

Okay this may be a stupid question, but how do you build an HTML page from within ASP.NET? I'm trying to build an ASPX page where someone can set a bunch of settings for how they'd like a web the page to look like. Then when they hit the submit button, ASP.NET makes the alterations to the page and then loads that newly altered page into the browser. I'd also like to be able to alter the script within the page as well.

Most (if not all) of the examples I've seen to this point are based on the idea of altering the already loaded page, like changing the label1.text = "This has been changed";

Is there a way to make alterations to a different page, and what do they call this? I've Googled a million things such as "building HTML in ASP.NET" and found nothing. This seems like a pretty common task.

Thanks, -=STZ=-

This looks like a typical case in which xsl transformation could work for you.
As I understand you want your webpage to get displayed according to some settings.

You can retrieve these settings in a dataset and create a xml file out of it.
Then you can use the xsl transform to transform this into HTML format.

The way you want to display the html will determine the logic in the xsl file.
I know I haven't included the actual code for you in this but hopes this helps you in some way Wink | ;)

Chinmay Vadhavkar
Tata Consultancy Services

Hi all,
i wants to down load video file and play it own browser i am geting media file from data base

<br />
con=new SqlConnection("server=hari; initial catalog=manoj;user id=sa;password=sa");<br />
cmd=new SqlCommand("select * from video where fileid='"+TextBox1.Text+"'",con);<br />
con.Open();<br />
dr=cmd.ExecuteReader();<br />
if(dr.Read())<br />
{<br />
string content=(string)dr["type"];<br />
FileInfo myfile=new FileInfo((string)dr["movename"]);<br />
int buffersize=Convert.ToInt32(dr["movelenth"]);<br />
Response.Clear();<br />
string str=myfile.Name;<br />
str=str.Replace("str",".resources");<br />
Response.AddHeader("Content-Disposition", "attachment; filename=" + str);               <br />
Response.AddHeader("content-Type",content);<br />
//Response.AddHeader("content-lenth",myfile.Length.ToString());<br />
Response.OutputStream.Write((byte[])dr["data"], 0, (int)dr["movlenth"]);<br />
Response.End();<br />
}<br />
else<br />
{<br />
Response.Write("No Such Media  Found");<br />
}<br />
con.Close();<br />
Response.End();<br />
<br />

with the above code i can get the file form data base & open it & save it also,

but i am not want to save that file & i wants to play only into my own browser.

how i can do this please give some example or idea (as soon as) Confused | :confused:

regard

khushak(manoj) OMG | :OMG:

Hi
How can we perform sorting in GridView While using SqlDataSource and AJAX.
I m using these and just write in Html Allow Sorting="True".But this doesnot work.
Can anybody give me code to perform sorting functionality.
Thanks in advance.

Kartik Rathi

U will also have to give the sortexpression to the bound and template column.
Use Atlas framework for using AJAX. Put the GridView inside an updatepanel and that will do the job
Here is a post showing how to add atlas control to your toolbox
http://vikramlakhotia.com/Post.aspx?postID=8

Hope this helps

Vikram Lakhotia

Still not got solution.
Can U explain This.

kartik rathi

Here is a code snippet of the code that works for sorting. Please change the Connection string and the querys. If you are using Atlas for ajax put the full thing inside the <atlas:updatepanel><contentpanel>. That will do the job.

Blush | :O

<asp:gridview id="GridView1" runat="server" allowpaging="True" allowsorting="True"
="" autogeneratecolumns="False" datakeynames="CategoryId" datasourceid="SqlDataSource1">
<columns>
<asp:commandfield showdeletebutton="True" showeditbutton="True">
<asp:boundfield datafield="CategoryId" headertext="CategoryId" insertvisible="False"
="" readonly="True" sortexpression="CategoryId">
<asp:boundfield datafield="Category" headertext="Category" sortexpression="Category">

<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:VikramConnectionString %>"
="" deletecommand="DELETE FROM [Category] WHERE [CategoryId] = @CategoryId" insertcommand="INSERT INTO [Category] ([Category]) VALUES (@Category)" selectcommand="SELECT [CategoryId], [Category] FROM [Category]" updatecommand="UPDATE [Category] SET [Category] = @Category WHERE [CategoryId] = @CategoryId">
<deleteparameters>
<asp:parameter name="CategoryId" type="Int32">

<updateparameters>
<asp:parameter name="Category" type="String">
<asp:parameter name="CategoryId" type="Int32">

<insertparameters>
<asp:parameter name="Category" type="String">

vikram lakhotia

I want to do sorting in Grid View with help of coding.This is my code
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
getdata()
End Sub

Public Function getdata() As DataSet
Dim adp As New SqlDataAdapter("select CategoryID,CategoryName,Description from categories order by CategoryName ASC", ConfigurationManager.ConnectionStrings("cn").ConnectionString)
Dim dt As New DataTable("categories")
adp.Fill(dt)
Dim dtrowcount As Integer = dt.Rows.Count
If dtrowcount > 0 Then
GridView1.DataSource = dt
GridView1.DataBind()
End If

End Function

Private Property GridViewSortDirection() As String
Get
Return IIf(ViewState("SortDirection") = Nothing, "DESC", ViewState("SortDirection"))
End Get
Set(ByVal value As String)
ViewState("SortDirection") = value
End Set
End Property

Private Property GridViewSortExpression() As String
Get
Return IIf(ViewState("SortExpression") = Nothing, String.Empty, ViewState("SortExpression"))
End Get
Set(ByVal value As String)
ViewState("SortExpression") = value
End Set
End Property

Private Function GetSortDirection() As String
Select Case GridViewSortDirection
Case "ASC"
GridViewSortDirection = "DESC"

Case "DESC"
GridViewSortDirection = "ASC"
End Select
Return GridViewSortDirection
End Function

Protected Function SortDataTable(ByVal datatable As DataTable, ByVal isPageIndexChanging As Boolean) As DataView
If Not datatable Is Nothing Then
Dim dataView As New DataView(datatable)
If GridViewSortExpression <> String.Empty Then
If isPageIndexChanging Then
dataView.Sort = String.Format("{0} {1}", GridViewSortExpression, GridViewSortDirection)
Else
dataView.Sort = String.Format("{0} {1}", GridViewSortExpression, GetSortDirection())
End If
End If
Return dataView
Else
Return New DataView()
End If
End Function

Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging
GridView1.DataSource = SortDataTable(GridView1.DataSource, True)
GridView1.PageIndex = e.NewPageIndex
GridView1.DataBind()

End Sub

Protected Sub GridView1_Sorting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSortEventArgs) Handles GridView1.Sorting
GridViewSortExpression = e.SortExpression
Dim pageIndex As Integer = GridView1.PageIndex
GridView1.DataSource = SortDataTable(GridView1.DataSource, True) GridView1.DataBind()
GridView1.PageIndex = pageIndex
End Sub

I had received an error on Bold line in gridview1_sorting procedure that Unable to cast system.data.dataset to system.data.dataview

Can any body give me solution.
Thanks in advance.

Kartik Rathi

Find an example at: http://www.programmingknowledge.com/dataGridSorting.aspx[^]

Thanks for your great help.

kartik rathi

hi I want to generate reports on asp.net,but problem is this ,suppose my database table having 20 colouns,and i have selected only 4 or 10 coloumns on runtime for reports, so how can i generate reports on the basis of thi ype of conditon,please help as soon as
thanks
Sniff | :^)

prabhakar dwivedi

What kind of reporting tool are you using? Or you are showing by HTML only?

Ram

hello,

I have to use the paypal and 2checkout.com for payment.

any body hav real time example code for it.

or anybody can tell me the steps for it.

thanx