ASP.NET

PSK_8-Feb-07 21:39

PSK_

8-Feb-07 21:39

Follow following steps.

1-Create a Datagrid and place a template column where you want to palce the hyperlink to appear.

Eg:

<asp:TemplateColumn HeaderText="Details">
	<ItemTemplate>
	<a href=http://url+?id='<%# DataBinder.Eval(Container.DataItem, "project_id")
	 %>'>Details</a>
	</ItemTemplate>
</asp:TemplateColumn>

2: Load the values from database to a data table of data reader and bind it to Datagrid.

3: In the recieving page get the id from query string and fetch details from the database on basis of that id.

Note: you need to create the correct hyperlink in the ItemTemplate column, here i have created just a dummy link.

Regards
Prakash

gauthee8-Feb-07 21:42

8-Feb-07 21:42

when you are providing the target url for the names generate the dynamic url.
lets say you got all the data frm db and have it in a dataset.
then it wouldbe targeturl=www.abc.com/....?name"+ds.tables[0]["columnname"]......

Gautham

coolestCoder8-Feb-07 22:15

coolestCoder

8-Feb-07 22:15

What would happen if some special characters are stored in the database ? ( for example "&" which is used in query strings )

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

gauthee8-Feb-07 22:59

8-Feb-07 22:59

Good question, never came across that!
Make sure that your database doesnt have any specila characters, kidding!
May be we have o filter the value again at the front end???
You know the answer?

Gautham

How to send multiple values from one page to another

coolestCoder8-Feb-07 23:18

coolestCoder

8-Feb-07 23:18

when inserting data into database always HtmlEncode it first. When displaying the data on forms HtmlDecode it.

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

gauthee8-Feb-07 19:26

Re: How to send multiple values from one page to another

8-Feb-07 19:26

Hi All,

I need to send some values from PageA.aspx to PageB.aspx and the options would be sessions or QueryString!!!

Dont want to use sessions since the application has too many sessions as of now!!!
QueryString?? the information passed would be customer's information so not secure and at the same time i would need to pass like 20 values, so hould i include all these values in the querystring??

Any other suggestions??? Kindly suggest!

Gautham

PSK_8-Feb-07 19:49

PSK_

8-Feb-07 19:49

You can user Server.Transfer("page.aspx") method to pass values from one page to other page.

Create a collection property in PageA which contains all the values you want to pass, and access the property in the PageB.aspx, but remember that use Server.Transfer insted of Response.Redirect method and EnableViewStateMac page directive value should be false, other wise you'll get error.

Regards
Prakash

Re: How to send multiple values from one page to another

Sandeep Akhare8-Feb-07 20:28

Re: How to send multiple values from one page to another

8-Feb-07 20:28

HI
Instead of creating in the page you can have seperate class called DataCintainer class which will have all Private varuables and public properties containing your data so that you can access from Anywhere Only you need to assign values before going to second page Smile | :)

<l>Thanks and Regards
Sandeep

gauthee8-Feb-07 21:34

Re: How to send multiple values from one page to another

8-Feb-07 21:34

Thanks Sandeep,

can you provide me sort of example??

Gautham

Sandeep Akhare8-Feb-07 22:15

Re: How to send multiple values from one page to another

8-Feb-07 22:15

private string _CategoryId = "";
public string CategoryId
{
get { return this._CategoryId; }
set { this._CategoryId = value; }
}
private string _CategoryName = "No Group";
public string CategoryName
{
get { return this._CategoryName; }
set { this._CategoryName = value; }
}
private int _CategoryState = 0;
public int CategoryState
{
get { return this._CategoryState; }
set { this._CategoryState = value; }
}
private string _AccountNumber = "";
public string AccountNumber
{
get { return this._AccountNumber; }
set { this._AccountNumber = value; }
}
private string _AccountType = "";
public string AccountType
{
get{ return this._AccountType;}
set{ this._AccountType = value;}
}
private string _RoutingNumber = "";
public string RoutingNumber
{
get{ return this._RoutingNumber;}
set{ this._RoutingNumber = value;}
}
private System.DateTime _LastCollectionDate;
public System.DateTime LastCollectionDate
{
get { return this._LastCollectionDate; }
set { this._LastCollectionDate = value; }
}
private bool _HasPendingCollections;
public bool HasPendingCollections
{
get{ return this._HasPendingCollections;}
set{ this._HasPendingCollections = value;}
}
private bool _ShowActionLinks = false;
public bool ShowActionLinks
{
get{return _ShowActionLinks;}
set{_ShowActionLinks = value;}
}
private string _BankName = "";
public string BankName
{
get { return this._BankName; }
set { this._BankName = value; }
}
this is container class with public properties and private varaibles
create a object of this class and pass this object to the page where you want to show/use tha data
example from page 1 to page 2
InSubmitstep of page1

this.PropertyOfPage2.pupulateData(this.DataContainerObject);
i think it is effective if you have large data and pages ?

<l>Thanks and Regards
Sandeep

PSK_8-Feb-07 22:04

PSK_

8-Feb-07 22:04

Hi Sandeep, to store object of DataCintainer class which you have specified we need to do some state management which he don't want to use. I hope you agree with me on this point.

Regards
Prakash

Re: How to send multiple values from one page to another

Sandeep Akhare8-Feb-07 22:45

how to validate input if violate between two datetime

8-Feb-07 22:45

Ya state manegement is required for that concept OK Boss
you have given right solution then Smile | :)

<l>Thanks and Regards
Sandeep

bernie_0118-Feb-07 22:49

bernie_011

8-Feb-07 22:49

hi can you help me with this?..

i have
in my class table--

classcode nvarchar,
teacher nvarchar,
room nvarchar,
TimeStart dateTime,
TimeEnd dateTime,

in my input for example--

class1 teacher1 room1 Feb-02-2007 8:00:00 AM Feb-02-2007 18:00:00 PM

If another class will be inserted it should not be in between the timestart and the timeEnd or else shows some error.The teacher should have training after the timeEnd and the room should be occupied after the training.

this input shoud not be accepted---
class2 teacher2 room1 Feb-02-2007 9:00:00 AM Feb-02-2007 18:00:00 PM

thank you very much....

Bernie

Re: how to validate input if violate between two datetime

Sandeep Akhare8-Feb-07 23:07