|
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:
%>'>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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Thanks Sandeep,
can you provide me sort of example??
Gautham
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Ya state manegement is required for that concept OK Boss
you have given right solution then
<l>Thanks and Regards
Sandeep
|
|
|
|
|
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
|
|
|
|
|
HI
Are you doing the console application ?
Are you passing all your data to database i.e What are you using for storing perpose ? and i am confused about your requirement What you want actually?
<l>Thanks and Regards
Sandeep
|
|
|
|
|
i am using asp.net web express, i want in my program to CHECK constraints,
For example..
The teacher has training from JAN-02-2007 8:00:00 AM - JAN-02-2007 18:00:00 PM,
The teacher must not have training between the time given. He can have traning if the EndTime was finish..
Can you show me sample CONSTRAINTS CHECK?
Bernie
|
|
|
|
|
You can use query string to send multiple values and these values may be encrypted from the source page. These will be decrypted on the target page. This, i think, would be a simple solution.
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
Hey Cool
Suppose i have many pages and have to flows between those then i need to make encryption and vice versa every time ? is it right
<l>Thanks and Regards
Sandeep
|
|
|
|
|
You can put the encryption and decryption logic in a class and use those static methods from anywhere in your site. Not a great deal, i guess.
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
example code or reference site??
Gautham
|
|
|
|
|
|
No clue whatsoever you are talking about???
Gautham
|
|
|
|
|
To Whom you replied Gautham ..To me?
Ok let me explain...
Just think a scenario that i want to export data from a Dataset to Excel file.
Am using XMLTextWriter to write into the file stream from the dataset.
So if i want to format the columns of the excel,like making the first row data alone as bold letters,coming from XML file, how can i do it?
The code am using is
for(int j=0;j<xHeader.Length;j++)
{<br />
writer.WriteString("\"");<br />
writer.WriteStartElement("xsl:value-of");<br />
writer.WriteAttributeString("select", "'" + xHeader[j] + "'");<br />
writer.WriteEndElement();
writer.WriteString("\"");<br />
if (j != xFields.Length - 1) <br />
writer.WriteString(" ");<br />
<br />
}
Can you get my point now?
|
|
|
|
|
Hi guys,
Am trying to export some data to Excel file
I can succeed in exporting the data but i couldnt format the headers and data.For example,
<br />
<Styles><br />
<Style ss:ID="s21"><br />
<Font ss:Bold="1"/><br />
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/><br />
</Style><br />
</Styles><br />
if i want to include this formatting using XMLTextWriter, how can i do that?
Am using the following code to export the data:
<br />
<br />
for(int j=0;j<xHeader.Length;j++)
{<br />
writer.WriteString("\"");<br />
writer.WriteStartElement("xsl:value-of");<br />
writer.WriteAttributeString("select", "'" + xHeader[j] + "'");<br />
writer.WriteEndElement();
writer.WriteString("\"");<br />
if (j != xFields.Length - 1) <br />
writer.WriteString(" ");<br />
} <br />
I need to format this xHeader's value to be formatted as "Bold" while opening as Excel.
Please help me!
|
|
|
|
|
It seems that you are writing Xml file rather than Excel file
<l>Thanks and Regards
Sandeep
|
|
|
|
|
hi
i'm doing a project on travel & tourism in asp.net..am using oracle as the backend...so far i've created 3 tables :
1.customer table which contains all the usernames & passwords
2.package table which contains the different packages my website provides..this table consists of the package no,package name & its cost...am dealing with only 5 packages...
3.bookings table which contains almost all details i've provided in d webform like credit card no,status,date of journey,bookings date,package no etc...
for checking out the ticket availability say me if this wud work out:
like comparing the booking date & date of journey, checking if booking date is 1month before the date of journey, 1/2month before or not?? if 1 month means tickets r available,1/2 month means only half the seats r available..is it possible to compare dates????
waiting for some1 to reply & help me out pls...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
