Ad
Failed To Convert Parameter Value From A ListItem To A String
I am trying to insert certain values into the table using SQL server 2005. I have used textbox, label and listbox. But by doing so, I have an error that states "Failed to convert parameter value from a ListItem to a String"
How do i solve this?
try
{
//Create an insert command
SqlCommand insertCmd = new SqlCommand("INSERT INTO Account(CustID, Name, TelExtension, Email, Password, AccountType, Status) VALUES " + "(@StaffID, @Name, @TelExtension, @Email, @Password, @StaffType, @Status); SELECT * FROM StaffAccount", sqlCon);
//Add the parameters to the command
insertCmd.Parameters.Add("@CustID", SqlDbType.VarChar, 20);
insertCmd.Parameters.Add("@Name", SqlDbType.VarChar, 50);
insertCmd.Parameters.Add("@TelExtension", SqlDbType.NChar, 20);
insertCmd.Parameters.Add("@Email", SqlDbType.VarChar, 50);
insertCmd.Parameters.Add("@Password", SqlDbType.VarChar, 25);
insertCmd.Parameters.Add("@AccountType", SqlDbType.VarChar, 2);
insertCmd.Parameters.Add("@Status", SqlDbType.VarChar, 1);
//Set the parameters
insertCmd.Parameters["@CustID"].Value = StaffID_txt.Text;
insertCmd.Parameters["@Name"].Value = Name_txt.Text;
insertCmd.Parameters["@TelExtension"].Value = telExtension_txt.Text;
insertCmd.Parameters["@Email"].Value = email_txt.Text;
insertCmd.Parameters["@Password"].Value = password_txt.Text;
insertCmd.Parameters["@AccountType"].Value = StaffType_LB.SelectedItem;
insertCmd.Parameters["@Status"].Value = status_lblvalue.Text;
Ad
Answer
change
insertCmd.Parameters["@AccountType"].Value = StaffType_LB.SelectedItem;
to
insertCmd.Parameters["@AccountType"].Value = StaffType_LB.SelectedItem.Text;
Ad
source: stackoverflow.com
Related Questions
- → How to Fire Resize event after all images resize
- → JavaScript in MVC 5 not being read?
- → URL routing requires /Home/Page?page=1 instead of /Home/Page/1
- → Getting right encoding from HTTPContext
- → How to create a site map using DNN and C#
- → I want integrate shopify into my mvc 4 c# application
- → Bootstrap Nav Collapse via Data Attributes Not Working
- → Shopify api updating variants returned error
- → Get last n quarters in JavaScript
- → ASP.NET C# SEO for each product on detail page on my ECOMMERCE site
- → SEO Meta Tags From Behind Code - C#
- → onchange display GridView record if exist from database using Javascript
- → How to implement search with two terms for a collection?
Ad