Question about roled base Security

Question

0.00/5 (No votes)

See more:

Hello, every one !

I would like to ask about about an article that mister Heath Stewart @heaths posted "Role-based Security with Forms Authentication"
I followed the exact same steps he mentioned. but when I try to log in it shows this error "Unable to cast an object of type 'System.Int32' to type 'System.String'." at this line

C#

FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, txtLogin.Text, DateTime.Now, DateTime.Now.AddMinutes(30), true, reader.GetString(0), FormsAuthentication.FormsCookiePath);

I really don't know why :( :(
Please help, I need to get this done by this afternoon :'(

Posted 20-Jun-14 1:29am

Member 10889990

Add a Solution

Comments

E.F. Nijboer 20-Jun-14 7:35am

You should go to the article and ask on the bottom of the page. You can post remarks on the article page which will notify the writer of the article.

Thanks7872 20-Jun-14 7:41am

Put your comments here : http://www.codeproject.com/script/Forums/Edit.aspx?fid=6668&floc=/Articles/2905/Role-based-Security-with-Forms-Authentication

CHill60 20-Jun-14 8:14am

When you debug, what is the value of reader.GetString(0)? Is it null by any chance?

Member 10889990 20-Jun-14 9:44am

it doesnt say any reader.GetStrin{0} but it's showing me that ticket value is null !!

Member 10889990 20-Jun-14 12:01pm

I did a messageBox.show(reader.getString(0)) and it gave me that error, so I replaced it with reader.GetValue(0).toString() and it showed me the RoleId. But when I replaced it in my formsAuthenticationTicket nothing happens, no error, no redirection to the default page

[no name] 20-Jun-14 8:16am

Or you could try and figure it for yourself. The error message tells you exactly what the problem is.

Member 10889990 20-Jun-14 9:46am

If I knew how to figure it out mySelf, I wouldn't be posting a question here ! It's either you answer or you ignore !!! and thank you for the major help you are providing :)

[no name] 20-Jun-14 10:10am

Simply read the message. It tells you exactly what the problem is. Don't blame me if you do not know how to read.

Member 10889990 20-Jun-14 10:12am

God, what is wrong with you ! Forums were made to help people who don't know how to read as you said !! God !!!

TcJoshJohnson 20-Jun-14 17:10pm

I'm gonna guess the GetString() method is throwing the exception. Take a look at the documentation for this method on MSDN (http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getstring(v=vs.110).aspx). The data you are reading must already be a string. The datatype of the column at index "0" in your case is likely of the integer datatype.

Member 10889990 23-Jun-14 7:47am

Yes you were right ! I changed it and edited my table and problem gone ! thank you

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

TcJoshJohnson · Answer 1 · 2014-06-27T07:03:00

Just adding this as the solution for future visitors:

I'm gonna guess the GetString() method is throwing the exception. Take a look at the documentation for this method on MSDN. The data you are reading must already be a string. The datatype of the column at index "0" in your case is likely of the int datatype.

Question about roled base Security

1 solution

Solution 1

Add your solution here

Preview 0

Question about roled base Security

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us