Additional information: Input string was not in a correct fo

Venkata Subbareddy

Hi Every one,

Iam New Software Developer i write One Logic code But I got Small and simple Error where iam doing Wrong Find out Me And Modified my source code in the Below the My Source Code..

public void chkStatus_OnCheckedChanged(object sender, EventArgs e)

{

CheckBox chkStatus = (CheckBox)sender;

GridViewRow row = (GridViewRow)chkStatus.NamingContainer;

string UserName = row.Cells[5].ToString();

bool ApproveStatus = chkStatus.Checked;

string constr = @"Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234";

string query = "UPDATENewStudentRegistrationForm SET ApproveStstus = @ApprovedStatus WHERE UserName = @UserName";

SqlConnection con = new SqlConnection(constr);

SqlCommand com = new SqlCommand(query, con);

com.Parameters.Add("@ApproveStatus", SqlDbType.Bit).Value = ApproveStatus;

com.Parameters.Add("@UserName", SqlDbType.Char).Value = Convert.ToInt32(UserName);

con.Open();

com.ExecuteNonQuery();

con.Close();

Thanks &Regards,

subbareddy.

17 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User11y ago
Accepted answer
CheckBox chkStatus = (CheckBox)sender;
GridViewRow row = (GridViewRow)chkStatus.NamingContainer;
string UserName = row.Cells[5].ToString();
bool ApproveStatus = chkStatus.Checked;
string constr = @"Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234";
string query = "UPDATE NewStudentRegistrationForm SET ApproveStatus = @ApproveStatus WHERE UserName = @UserName";
SqlConnection con = new SqlConnection(constr);
SqlCommand com = new SqlCommand(query, con);
com.Parameters.Add("@ApproveStatus", SqlDbType.Bit).Value = ApproveStatus;
com.Parameters.Add("@UserName", SqlDbType.Char).Value = UserName;
con.Open();
com.ExecuteNonQuery();
con.Close();
0
Guest User11y ago
Sorry Venkata, I don't provide personal/e-mail support. Please post your questions in the forums, more people can help you that way.
0
Venkata Subbareddy11y ago
Today Iam start Work Please give Your mail id iam directy Comunication if anyware i stuggle.. Thank You Dude
0
Guest User11y ago
Not now, am about to leave.

I suggest you start a new thread and provide more information about what you need to build and where you are stuck.
0
Venkata Subbareddy11y ago
Thanks Dude . It was working thanks for spending ur valuable time. I am working on online exam form can u give me some instructions how to develop the above said online exam form.
0
Guest User11y ago
Check your query, and remove the 'd'. See my posted snippet. You did not copy everything (correctly).
0
Venkata Subbareddy11y ago
public void chkStatus_OnCheckedChanged(object sender, EventArgs e) { CheckBox chkStatus = (CheckBox)sender; GridViewRow row = (GridViewRow)chkStatus.NamingContainer; string UserName = row.Cells[5].Text; bool ApproveStatus = chkStatus.Checked; string constr = @"Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234"; string query = "UPDATE NewStudentRegistrationForm SET ApproveStatus = @ApprovedStatus WHERE UserName = @UserName"; SqlConnection con = new SqlConnection(constr); con.Open(); SqlCommand com = new SqlCommand(query, con); com.CommandType = CommandType.Text; com.Parameters.Add("@ApproveStatus", SqlDbType.Bit).Value = ApproveStatus; com.Parameters.Add("@UserName", SqlDbType.Char).Value = UserName; com.ExecuteNonQuery(); con.Close(); Bind_Data(); } }
0
Guest User11y ago
Show your latest code and the full error message (again).
0
Venkata Subbareddy11y ago
Dude I got Same Error....
Must declare the scalar variable "@ApprovedStatus".

0
Venkata Subbareddy11y ago
pritaeas can u please rectify the issue by taking Teamviwer..
0
Guest User11y ago
com.Parameters.Add("@ApprovedStatus", SqlDbType.Bit).Value = ApproveStatus;

The variable must match with whats in the query. I probably copied it wrong.
0
Venkata Subbareddy11y ago
sorry dude for late Replay present correction my project source after i getin in the Below error.. letme know any Modification.. Must declare the scalar variable "@ApprovedStatus".
0
Guest User11y ago
Did you use the query I showed, I think yours contained a typo.
0
Venkata Subbareddy11y ago
am using same Synax but i got this type of An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code Additional information: Incorrect syntax near '='.
0
Guest User11y ago
Use:

com.Parameters.Add("@UserName", SqlDbType.Char).Value = UserName;

Also make sure your update query contains a space:

string query = "UPDATE NewStudentRegistrationForm SET ApproveStatus = @ApprovedStatus WHERE UserName = @UserName";
0
Venkata Subbareddy11y ago
Hi Pritaeas, where am doing Woring Modified Source code Replay me....
0
Guest User11y ago
Why is the username converted to an Int32?
0

Additional information: Input string was not in a correct fo

Must declare the scalar variable "@ApprovedStatus".