Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Professional
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 10th, 2011, 01:48 AM
Authorized User
Points: 410, Level: 7
Points: 410, Level: 7 Points: 410, Level: 7 Points: 410, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2009
Posts: 72
Thanks: 17
Thanked 0 Times in 0 Posts
Thumbs up Uniqueidentifier datatype issue

Hi,

I have a column in my database table named EMP_ID which is of uniqueidentifier datatype & generated automatic values by (newid()).

And i have records of employees in same table for e.g. full name, birthdate, photourl, etc. EMP_ID is primary key.

i have 2 .aspx pages.
Home page shows only list of names of employees , SO i have taken a Gridview & there is a LABEL & LINK BUTTON in GridView. LABEL shows the NAME of EMPLOYEE & On clicking on LINK BUTTON , i am running a method which redirects user to 2nd page i.e. EmplyeeDetails.aspx page as follows:-

public void View_Details(object Src, CommandEventArgs Args)
{
Response.Redirect("EmployeeDetail.aspx?emp_id=" + Args.CommandName);
}


In the 2nd page i again have a GridView which shows details of the Employee selected on 1st page based on querystring. But the records are not shown. I get an empty GridView. I can see the EMP_ID in the URL as follows:-

http://localhost:1457/EmployeePortal...7-049687864bf8

But the records are not shown. The emp_id is perfectly correct.

How to solve this issue.

Pls Help Me.

Thank U.....
  #2 (permalink)  
Old June 14th, 2011, 03:21 AM
Friend of Wrox
Points: 3,558, Level: 25
Points: 3,558, Level: 25 Points: 3,558, Level: 25 Points: 3,558, Level: 25
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: California, USA
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

first of all: i dont think that Guid is good option for PK & ur employee number
but anyway, make sure u get the emp_id's value from QueryString.
trace there & see if its ok, so if it is problem must be in ur loading in EmployeeDetail.aspx page
__________________
Always,
Hovik Melkomian.
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is uniqueidentifier is always unique ? vinod_yadav1919 SQL Server 2000 4 May 30th, 2008 11:31 AM
Use of UNIQUEIDENTIFIER ggandta BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 2 March 9th, 2007 01:52 PM
Issue with float and currency datatype prabodh_mishra SQL Server 2000 10 December 6th, 2006 03:30 AM
Uniqueidentifier to Integer Conversion mp01 BOOK: Beginning VB.NET Databases 2 August 8th, 2005 06:57 PM
datatype ngang SQL Language 1 November 18th, 2003 09:55 AM



All times are GMT -4. The time now is 01:40 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.