|
I am try to deleting data from database to dropdown list .
when I am selecting item in dropdown list then that selected item is deleted from database
which type of query i am use for delete data
I am using some query that time it's selected only 0 index value always
that query is
SqlDataAdapter adtp_del = new SqlDataAdapter("Delete from T_Vender_Selection where Tender_ID='" + lb_tenno.Text + "' AND Vender_Name = '" + lbname.SelectedItem.Text + "' ", con);
DataSet ds_del = new DataSet();
adtp_del.Fill(ds_del, "tbl_del");
lbname.Items.Remove(lbname.SelectedItem.Text);
|
|
|
|
|
|
|
|