ASP.NET

blurMember21-Aug-06 15:55

blurMember

21-Aug-06 15:55

In the past, in .Net 1.1 I have a datagrid and I binded my data using datatable, dataset etc. I have set earlier

public string strAbsent = "A";

In some column the output will show A in red colour in the datagrid.

Now, I am migrating the project to .Net 2.0. I have a gridview and I binded my data using datatable, dataset etc.

But it appears that the output A is no longer in red colour but instead it shows exactly the html tags:

A

thanks in advance. Much appreciated.

vik2021-Aug-06 3:31

21-Aug-06 3:31

You will have to use HTMLEncaode=false
Here is a post telling the reason
http://vikramlakhotia.com/Post.aspx?postID=5

Vikram Lakhotia

blurMember21-Aug-06 15:56

blurMember

21-Aug-06 15:56

How can i set htmlencode="False" when im not using any boundcolumns?
Is there any way to set A to red colour.

thanks in advance. Much appreciated.

vik2021-Aug-06 18:34

Re: Why cant I do this in .Net 2.0? [modified]

21-Aug-06 18:34

u can use Item Style template to give it colour.

Vikram

blurMember22-Aug-06 8:09

blurMember

22-Aug-06 8:09

Sorry maybe I did not explain clearly.

The above html tags was from the codebehind. how can I edit the item-template when I would not know where the letter A will appear in the gridview.

------------------------
| |A | | | | | | |
| | | A| | | | | |
| | | | | | | | |
|__|__| A|__|__|__|

Some other letter will appear at the blank cells in the gridview. My purpose is to highlight to user, A with red colour so it catch reader eyes to notice the number of As.

-- modified at 14:10 Tuesday 22nd August, 2006

thanks in advance. Much appreciated.

Creating a HTML page from ASP.NET

whozurmommy20-Aug-06 21:54

whozurmommy

20-Aug-06 21:54

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=-

Re: Creating a HTML page from ASP.NET

ChinmayV21-Aug-06 1:42

ChinmayV

21-Aug-06 1:42

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

Down load video file from data base & play it in own browser

kushak_manoj20-Aug-06 21:32

kushak_manoj

20-Aug-06 21:32

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:

Sorting in Grid View using AJAX

Kartik Rathi20-Aug-06 21:17

Re: Sorting in Grid View using AJAX

20-Aug-06 21:17

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

vik2021-Aug-06 3:34

Re: Sorting in Grid View using AJAX

21-Aug-06 3:34

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

Kartik Rathi22-Aug-06 1:03

Re: Sorting in Grid View using AJAX

22-Aug-06 1:03

Still not got solution.
Can U explain This.

kartik rathi

vik2022-Aug-06 1:19

22-Aug-06 1:19

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

Sorting in Grid View

Kartik Rathi20-Aug-06 21:13

postmaster@programmingknowledge.com

20-Aug-06 21:13

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

Re: Sorting in Grid View

postmaster@programmingknowledge.com21-Aug-06 1:20

21-Aug-06 1:20

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

Re: Sorting in Grid View

Kartik Rathi21-Aug-06 22:59

payment using paypal and 2checkout.com.

21-Aug-06 22:59

Thanks for your great help.

kartik rathi

ASP.Net Reports

prabhakar dwivedi20-Aug-06 21:06

prabhakar dwivedi

20-Aug-06 21:06

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

Re: ASP.Net Reports

Ramasubramaniam21-Aug-06 3:50

Ramasubramaniam

21-Aug-06 3:50

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

Ram

Amit Agarrwal20-Aug-06 20:39

Amit Agarrwal

20-Aug-06 20:39

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

Christian Graus20-Aug-06 20:49

Christian Graus

20-Aug-06 20:49

www.paypal.com has all the info you need.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Amit Agarrwal20-Aug-06 21:15

Amit Agarrwal

20-Aug-06 21:15

I have seen the paypal.com before this too and i hav dowload the SDk too for paypal.

but not getting the how to configure and how to send the variable from my iste to paypal and how to recieve the variables.

waiting for the reply

thanx

Christian Graus20-Aug-06 21:37

Christian Graus

20-Aug-06 21:37

Which part of the explanation on the paypal site are you having trouble with ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

seee sharp20-Aug-06 21:46

seee sharp

20-Aug-06 21:46

Have you tried Paypal support?

- ashish