i am getting an error items collection cannot be modified when the DataSource property is set. in my code which is like bellow.
i am getting this error when i am clicking on delete button( btnDelete method)
i need to reload my combobox after i delete the image..
public void Bind_Image_Name()
{
try
{
cmbPick.Items.Clear();
conn.Open();
cmd = new SqlCommand("SelectImageName", conn);//here SelectImageName is the StoredProcedure name
cmd.CommandType = CommandType.StoredProcedure;
da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
cmbPick.DataSource = dt;
cmbPick.ValueMember = "ImagePath";
cmbPick.DisplayMember = "ImagePath";
cmbPick.Text = "select one";
cmbPick.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
cmd = new SqlCommand("SelectImage", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Option", "Delete");
cmd.Parameters.AddWithValue("@ImagePath", cmbPick.Text);
cmd.ExecuteNonQuery();
}
conn.Close();
Bind_Image_Name();
}
saadiq..