ListBox Posting Problem

[Phenglai]

I have looked all over and I can not figure this out. I am setting up a form that will allow someone to update a product group category in the database. I want them highlight the item in the listbox and then press a remove button. I can not figure out why this will not work. I have posted the code of the sub below. The code runs fine as long as I dont reference the listbox.

Any help would be appreciated.


//We need to mark the selected item as inactive
string cmdStr;
string connStr;

cmdStr = "UPDATE productGroup " +
"SET active = 0 " +
"WHERE Name = '" + lstMain.SelectedItem.Text + "'";

connStr = System.Configuration.ConfigurationSettings.AppSettings["connSql"];

// Create connection object
SqlConnection conn = new SqlConnection(connStr);
// Create command object
SqlCommand cmd = new SqlCommand(cmdStr, conn);

try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch ( Exception ex )
{
Response.Write(ex.Message);
}
finally
{
conn.Close();
}

[JemimaChadwick]

Are you getting some error now?

Otherwise it could be no rows matched the selection. To solve this, try trimming the list box's selected item value.

Thanks,
Jemima.

[Phenglai]

If you remove the listbox reference from the sql statement and add anything it works. Its when you reference the listbox does it fail. The sql statement is not failing.

I get NullException Object not set error on the listbox. Its like, at the point the sub runs, the listbox has been released.