Input string was not in a correct format.

Question

0.00/5 (No votes)

See more:

C#

protected void loginControl_Authenticate(object sender, AuthenticateEventArgs e)
    {
        Employee user = new Employee();
        user.EmployeeID = Convert.ToInt32(loginControl.UserName);
        user.Password = loginControl.Password;
        e.Authenticated = EmployeeDAO.authenticateEmployee(user);



        if (e.Authenticated)
        {
            Response.Redirect("DefaultSecure.aspx");
        }
    }

this is my code of inpun on user name and paswd but it showing Input string was not in a correct format this error.i ma not geting plz help

Posted 26-Dec-12 5:47am

Eknath Sonawane

Add a Solution

Comments

ridoy 26-Dec-12 11:52am

what is loginControl? where you initialize it?

Anele Ngqandu 27-Dec-12 5:06am

what is the format of the EmployeeID?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2012-12-26T05:50:00

Solution 1

Look at your code: there is only one place that can generate that error.

C#

user.EmployeeID = Convert.ToInt32(loginControl.UserName);

From that, the clue is in the Property name: loginControl.UserName is unlikely to be a number, so the Convert.ToInt32 will throw an error.

I suspect you want a different property.

Posted 26-Dec-12 5:50am

OriginalGriff

Comments

Eknath Sonawane 26-Dec-12 12:03pm

so which property will be suit over here

OriginalGriff 26-Dec-12 14:10pm

Well that's up to you - you know what control you are using, not me! I'd suggest an integer one or perhaps a lookup from the name to the ID?
Bear in mind I can only see the seven lines of code you posted above...

Sheikh Muhammad Haris · Answer 2 · 2012-12-26T16:55:00

Solution 2

This might helps you. Use

C#

user.UserName  = loginControl.UserName;

instead of

C#

user.EmployeeID = Convert.ToInt32(loginControl.UserName);

Posted 26-Dec-12 16:55pm

Sheikh Muhammad Haris

Comments

Eknath Sonawane 26-Dec-12 23:22pm

this is my function still this is not working
public static bool authenticateEmployee(Employee employee)
{
string query = "SELECT EmployeeID FROM Employee WHERE EmployeeID = @EmployeeID AND Password = @Password";
SqlCommand command = new SqlCommand(query);
command.Parameters.AddWithValue("@EmployeeID", employee.EmployeeID);
command.Parameters.AddWithValue("@Password", employee.Password);
DataTable dataTable = executeQuery(command);

if (dataTable.Rows.Count > 0)
return true;

return false;
}

[no name] 26-Dec-12 23:27pm

Do you have any username (Login ID) field in your database? Use it instead of EmployeeID. I am expecting EmployeeID to be the primary key of your table.

Faisalabadians · Answer 3 · 2012-12-26T19:52:00

Solution 3

C#

user.EmployeeID = Convert.ToInt32(loginControl.UserName);

brother make sure that Employee has the prpoerty EmployeeID type of string?

C#

command.Parameters.AddWithValue("@EmployeeID", employee.EmployeeID);

explain here first that what is data type of EmployeeID in your database?
also, what is the data type of EmployeeID in your object? then some one would guess, what's going on exactly

Posted 26-Dec-12 19:52pm

Faisalabadians

Comments

Eknath Sonawane 27-Dec-12 1:57am

Emplpyee having property EmployeeId of type Int

Eknath Sonawane 27-Dec-12 1:58am

i am aslo chengit it to string but it didt rpl if u dnt mind will u please sned me ur emailid i will send u the project plz help

Faisalabadians 27-Dec-12 2:06am

craze.programmer@gmail.com

Faisalabadians 27-Dec-12 2:07am

also, database or database script would be required.

Eknath Sonawane 27-Dec-12 5:13am

just check out your mail i have just send u that project

Faisalabadians 27-Dec-12 7:07am

ok. i check