Adding Concatenated Column to DataTable [modified] - ASP.NET Discussion Boards

Christian Graus23-Feb-09 9:07

23-Feb-09 9:07

I would say you need a subfolder ( www.mysite.com/users for example ) and use URL rewriting to redirect John9878,aspx to redirect to a standard page which takes that name as a parameter and looks it up in the database.

Christian Graus

Driven to the arms of OSX by Vista.

Re: Creating aspx Page Dynamically

Colin Angus Mackay23-Feb-09 9:10

Colin Angus Mackay

23-Feb-09 9:10

Amandeep Singh Bhullar wrote:
Hi, my requirements are same as of CodeProject.com. I want to create a page(aspx) for every user who register on my website. Same as CodeProject.com creates a new pages when one writes a article.

I don't think it does. It just looks like it does. It is just a page backed by a database and to make nice URLs you can create an HttpModule or HttpHandler that examines the URL from the browser and translates it to an internal value that then renders the page. As far as the outside world is concerned it looks like a new page file has been created.

URLs just look like file paths because originally they were just file paths in the server. These days a URL can refer to anything. Look at ASP.NET MVC routing to see some powerful stuff done with URLs.

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

Re: Creating aspx Page Dynamically

Aman Bhullar23-Feb-09 19:13

Aman Bhullar

23-Feb-09 19:13

Colin Angus Mackay wrote:
I don't think it does. It just looks like it does.

Check it out(Just For Example)
http://www.codeproject.com/KB/miscctrl/vbnet-multitab-browser.aspx

This URL depicts that it is a new page. Also this page is indexed in Search Engine. If it is simple URL rewriting, then how Search engine index it.
Same is the case with all articles

Re: Creating aspx Page Dynamically

Colin Angus Mackay23-Feb-09 21:04

Colin Angus Mackay

23-Feb-09 21:04

Amandeep Singh Bhullar wrote:
then how Search engine index it.

Because the search engine doesn't know how the page got rendered. It doesn't care how it got rendered. It just has a rendered page at a specific URL that it can put in its cache.

The website I've been working on the last few months has about a dozen page templates (all aspx files) but if you were to look at it in a search engine you'd see hundreds of "pages" on the site. All that information is in the database, not in files.

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

Re: Creating aspx Page Dynamically [modified]

Kariem Soudy23-Feb-09 20:56

Kariem Soudy

23-Feb-09 20:56

consider using ASP.NET MVC or just use HttpHandlers

see this article

http://msdn.microsoft.com/en-us/library/ms972953.aspx[^]

Web Developer

modified on Tuesday, February 24, 2009 3:11 AM

GridView Row not collapsing while clicking on any node on the treeview

meeram39523-Feb-09 5:05

meeram395

23-Feb-09 5:05

I have a treeview in the lefthand side of my aspx page. When I clicked on any of the nodes, there will be a grid showing the details on the right hand side. There is an edit button also for each row for editing the details. Everything is working perfectly fine.

The issue: if I clicked on the Edit link, Update and Cancel button will apppear in the Grid. And without performing any updating(means without doing any edit), if I clicked on the left hand side of any other node, corresponding details will appear in the Grid without collapsing the row. if I code as below, update event itself is not firing.

if (GridView1.EditIndex >= 0)
            GridViewEditIndex = -1;

Anybody have any idea why it is happening? How can make the row collapsible even though the Update and Cancel button in the Grid is open in GridRow? Please help. Please let me know if I need to provide more info.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Parser Error Message: Child nodes not allowed.

khuzwayom23-Feb-09 4:55

khuzwayom

23-Feb-09 4:55

Hi Everyone

I have an application that is running fine on my development and QA environment but it's giving me problems on production. I get an error "Child nodes not allowed"
on thi sline "<providerOption name="CompilerVersion" value="v3.5"/>;"

Parser Error Message: Child nodes not allowed.
Line 126: compilers
Line 127: compiler language="c#;cs;csharp" extension=".cs" warninglevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
Line 128: provideroption name="CompilerVersion" value="v3.5"
Line 129: provideroption name="WarnAsError" value="false"
Line 130: compiler

So I would like assistance at what is the cause and how to solve this problem.

Thank you

Mpumelelo Khuzwayo

Adding Concatenated Column to DataTable [modified]

Steve Skelton23-Feb-09 4:51

Steve Skelton

23-Feb-09 4:51

This should be a common need but I haven't found a method so far. What i want to do is, in a result from a SQL Query, define some columns to be, say, Full Name on load to the datagrid rather than 3 cols for first, mid and last name. so, no joins, just select from db, manipulate data, bind to datagrid.

Currently i am using DataTable as I only need read-only to the data. this code looks like it might work:

Dim resultsDataSet As New DataTable()

Dim FullName() As DataColumn = { _
resultsDataSet.Columns("FIRST_NAME"), _
resultsDataSet.Columns("MID_NAME"), _
resultsDataSet.Columns("LAST_NAME")}

Dim myDataAdapter As SqlDataAdapter = New SqlDataAdapter(cmd)
myDataAdapter.Fill(resultsDataSet)

DisplayResults.DataSource = resultsDataSet
resultsDataSet.Columns.Add(FullName(2))
DisplayResults.DataBind()

But I get the error "'column' argument cannot be null." when i try to load the datagrid. also, i don't know what i should but in the declared array FullName() during bind - 2 is a guess based on the fact that there are 3 columns defined for this one. In addition, it's *OK* to have the new table be null if First, Mid and Last (name) is in fact not given in the data source.

TIA

Issue resolved - I did the concatenated table in the db instead.

modified on Monday, February 23, 2009 11:03 AM

Re: Adding Concatenated Column to DataTable

ToddHileHoffer23-Feb-09 5:08

ToddHileHoffer

23-Feb-09 5:08

FYI if you are doing read only, the sqldatareader is more efficient. Especially for larger result sets.

I didn't get any requirements for the signature

Re: Adding Concatenated Column to DataTable

Steve Skelton23-Feb-09 5:10

Steve Skelton

23-Feb-09 5:10

i suppose you mean to replace

New SqlDataAdapter(cmd)

with New SqlDataReader(cmd)

Re: Adding Concatenated Column to DataTable

ToddHileHoffer23-Feb-09 5:19

ToddHileHoffer

23-Feb-09 5:19

Something like this...

string queryString =
"Put your sql here and use parameters if necessary";

using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlCommand command =
new SqlCommand(queryString, connection);
connection.Open();

SqlDataReader reader = command.ExecuteReader();

DisplayResults.DataSource = reader;

DisplayResults.DataBind();

// Call Close when done reading.
reader.Close();
}

I didn't get any requirements for the signature

Re: Adding Concatenated Column to DataTable

Steve Skelton23-Feb-09 5:25

Steve Skelton

23-Feb-09 5:25

thanks - i'm new to all this and it's good to be reminded of when to use what in the ADO.NET world.

ASP.NET application load

alexfromto23-Feb-09 3:50

alexfromto

23-Feb-09 3:50

Hi all.

I have .NET web application, which gives user overall sales performans and uses iframe to load some detailed sales data. Because of that iframe design the applicaion is loaded slower at first run (I guess it has to load 2 pages: the main and the iframe page). The question I have is: If I increase memory on my server will the application run faster?

Thanks.

Alex.

Re: ASP.NET application load

ToddHileHoffer23-Feb-09 4:09

ToddHileHoffer

23-Feb-09 4:09

alexfromto wrote:
The question I have is: If I increase memory on my server will the application run faster?

Probably not.

I have a suggestion for you...

Check your IIS Settings, you will see that the amount of ram each application pool can use is configurable.

Your issue could be a sql query that is not optimized. How long does the sql query take to run?

If that isn't the issue you could install this http://www.jetbrains.com/profiler/[^]

It will enable you to determine how long each .net method is taking to execute.

If that doesn't help you could install fire fox, firebug and http://developer.yahoo.com/yslow/[^]

Basically, you need to rule out a hole host of issues before you go adding ram to your web server.

I didn't get any requirements for the signature

Need VB/ASP equivalent of PHP's fie_get_contents to retrieve URL contents

Doug Coughler23-Feb-09 3:48

Doug Coughler

23-Feb-09 3:48

I had created a very simple PHP page that would read in a value from a wiki webpage, then use that number to retrieve information for a different wiki page, and spit the whole thing out into a purely HTML webpage. Recently, we moved our site over to a Windows server, and the php page no longer worked. I managed to throw together an HTML/javascript equivalent, but I'd really like to do all of this work on the server instead of on the client, in order to hide the "guts". I'm hiding them for ethetics, not security, and so that the page, once retrieved, can be viewed offiline. Can someone tell me how to do this in asp and vbscript please?

Here is the PHP page:

<html><head><title>Helpful Hints</title> </head> 
<body> 
 <?php <br mode="hold" /?> 
   $configFile=file_get_contents('http://www.mysite.com/wiki/data/pages/internal/helpfulhints/numberofpages.txt'); 
   $somenumber=rand(1, ($configFile*1)); 
   $filename='http://wiki.mysite.com/doku.php?id=internal:helpfulhints:hint'.$somenumber.'&do=export_xhtmlbody'; 
  
   echo file_get_contents($filename); 
 ?> 
  <br /> 

</body></html>

and here is the Javascript version:

<html><head><title>Helpful Hints</title> </head> 
<body> 
<script lang="javascript"> 
function file_get_contents( url ) { 
	    // http://kevin.vanzonneveld.net 
	    // +   original by: Legaev Andrey 
	    // %        note 1: This function uses XmlHttpRequest and cannot retrieve resource from different domain. 
	    // %        note 1: Mainly here for study purposes. 
	    // %        note 1: To avoid browser blocking issues's concider using jQuery's: $('#divId').load('http://url') instead. 
	    // *     example 1: file_get_contents('http://kevin.vanzonneveld.net/pj_test_supportfile_1.htm'); 
	    // *     returns 1: '123' 
	  
	    var req = null; 
	    try { req = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { 
	        try { req = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) { 
	            try { req = new XMLHttpRequest(); } catch(e) {} 
	        } 
	    } 
	    if (req == null) throw new Error('XMLHttpRequest not supported'); 
	    
	    req.open("GET", url, false); 
	    req.send(null); 
	    
	    return req.responseText; 
	} 
	 
	 
	var numberofpages = file_get_contents('http://wiki.mysite.com/doku.php?id=internal:helpfulhints:numberofpages&do=export_raw'); 
	var randomnumber = Math.floor(Math.random()*numberofpages)+1; 
	 
	var message = file_get_contents('http://wiki.mysite.com/doku.php?id=internal:helpfulhints:hint'+randomnumber+'&do=export_xhtmlbody'); 
	 
	document.write(message); 
	 
	</script> 
	<br /> 
	 
	</body></html>

Thanks!

Resource for understanding working of web application

Vishnu Nath23-Feb-09 3:35

Vishnu Nath

23-Feb-09 3:35

Hii,
Am new to ASP.net.
And am very curious to know from where could i get the required resource to understand the life cycle of page when it is requested to server to the time, when server responses back to browser in asp.net 2.0.
I want to know in depth about what process takes place at server.
How server process page request and all in details.
Where could i get these understanding from?
Can anyone refer me to a site where probably i could download some free e book or any presentation which gives me full understanding on the process taking place between a request submitted to server, to response received from server in depth/detail.
Guide me, if any one can for this topic to better understand asp.net. Smile | :)

Aspiring Techie,
Vishnu Nath

Re: Resource for understanding working of web application

ToddHileHoffer23-Feb-09 4:00

ToddHileHoffer

23-Feb-09 4:00

http://msdn.microsoft.com/en-us/library/ms178472.aspx[^]

I didn't get any requirements for the signature

Session in classes

mehrdadc4823-Feb-09 3:26

mehrdadc48

23-Feb-09 3:26

Hi.
How could I access session in a pure class (not a webForm)

Best wishes

Re: Session in classes

Vimalsoft(Pty) Ltd23-Feb-09 3:32

Vimalsoft(Pty) Ltd

23-Feb-09 3:32

You cant.

Call a Function that needs the value from the Session Variable in your Page and pass in the Value from the Session variable in your page and it will pass the Value to the Class Function or Method

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

Re: Session in classes

Greg Chelstowski23-Feb-09 3:34

Greg Chelstowski

23-Feb-09 3:34

My best guess:

object zObj = System.Web.HttpContext.Current.Session["MyVariable"];

var question = (_2b || !(_2b));

Re: Session in classes

ToddHileHoffer23-Feb-09 4:00

ToddHileHoffer

23-Feb-09 4:00

using System;
using System.Web;

public static class SessionItems
{
public static string YourSessionValue
{
get
{
Object result = HttpContext.Current.Session["YourSessionValue"];
if (result == null)
return null;
else
return (string)result;
}
set { HttpContext.Current.Session["YourSessionValue"] = value; }
}

}

I didn't get any requirements for the signature

shoe Euro sign in gridView Items

mehrdadc4823-Feb-09 3:23

mehrdadc48

23-Feb-09 3:23

Hi.
How could I add a Euro sign at the end of items of a coloumn of a gridview.
I have added the & euro ; (not seperted) at the end of my items, but it shows the & euro ; string itself, not the sign.

Best wishes

Re: shoe Euro sign in gridView Items

Anurag Gandhi23-Feb-09 3:37

Anurag Gandhi

23-Feb-09 3:37

Hi,
Try doing it in RowDataBound event.
I guess you will be able to do it there successfully.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Radio Button Selection

Sarfaraj Ahmed23-Feb-09 2:50

Sarfaraj Ahmed

23-Feb-09 2:50

Hello Everybody
I have 4 radio button on my page and their Group Name grpSelection.
'On button click' How do I know which radio button is seleted?

Thanks
Sarfaraj

Sarfarj Ahmed

Re: Radio Button Selection

Sneha Bisht23-Feb-09 2:54

Sneha Bisht

23-Feb-09 2:54

string name="";
if(rad1.checked)
{
name = "I selected";
}
else if(rad2.checked)
{
name = "II selected";
}
else if(rad3.checked)
{
name = "III selected ";
}
else
{
name ="IV selected" ;
}

but this code use when no of radiobutton i9s less otherwise use radiobuttonlist .

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.