Hi I would like to create a database where users can search for multiple fields. For example: if the record is personal details info like name, address, phone number and email id i would like to generate link for this automatically with the fields using
stored procedure.. Is that possible.? If so can anybody provide me with the line of code or guideline on how to do that?
srnj890
0 Points
2 Posts
How to save records with autogenerated html links in Sql database?
Aug 24, 2010 05:38 PM|LINK
Hi I would like to create a database where users can search for multiple fields. For example: if the record is personal details info like name, address, phone number and email id i would like to generate link for this automatically with the fields using stored procedure.. Is that possible.? If so can anybody provide me with the line of code or guideline on how to do that?
Any help much appreciated. Thanks
Sqll html links
hemamalinigr
Participant
1310 Points
345 Posts
Re: How to save records with autogenerated html links in Sql database?
Aug 24, 2010 08:14 PM|LINK
you mean you want to store that information as link in the database or show that data as link on the aspx page??
Pikesville P...
Participant
1036 Points
197 Posts
Re: How to save records with autogenerated html links in Sql database?
Aug 25, 2010 02:41 AM|LINK
It's possible, but don't do it that way.
Your database is for the storage and retrieveal of data, period.
You take the sanitized data from your user's search form and pass it to a method
THis method will call a function that returns the data from a stored proc that will be used to build your link in your DAL.
The returned data is turned into hyperlinks via StringBUilder and written back to the user.
You haven't had a beer until you've learned how to make your own...
KumarHarsh
All-Star
15133 Points
3647 Posts
Re: How to save records with autogenerated html links in Sql database?
Aug 26, 2010 12:04 PM|LINK
Kumar Harsh