Hi All,

I have created a table called tblState in access with 2 columns: id and state and am populating a dropdownlist with state.

I am in need of code to delete a selected value of dropdownlist from database in asp.net2.0 using c#.

Can anybody help me please.

Thanks
Wajid

hi ansari.wajid,
You can easily remove selected items from DropDownList. On the click of Delete button you first take index of selected item and then pass it to the Remove function of DropDownList control.Use following code.

DropDownList_Object.Items.Remove(DropDownList_Object.SelectedIndex);

Hope this will help you. If you have any problem feel free to share with us.
Thanks & Regards
Dilip Kumar Vishwakarma
Programmer
.Net Consulting

Yup, exactly. When a user chooses it, have it either autopostback to the server (or something), then find the selected index, then remove it with the above code. Vuala.

Hello All

I am not a very good programmer, just tryied following code but its not working.

when ever I am pressing delete button after selecting a value in dropdownlist, it just deleting the top most value.

C# CODE:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class newDeleteValueDDList : System.Web.UI.Page
{
    OleDbConnection cn;
    OleDbCommand cmd;
    DataSet ds;
    OleDbDataAdapter da;

    protected void Page_Load(object sender, EventArgs e)
    {
        getData();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        connectDatabase();

        string str = DropDownList1.SelectedValue;
                string strDelete = "delete state from tblState where state='" + str + "'";
                cmd = new OleDbCommand(strDelete, cn);
                cmd.ExecuteNonQuery();
                cn.Close();
                getData();

    }
    private void connectDatabase()
    {
        string strConnectionString = Server.MapPath("~/App_Data/dummyDb.mdb");
        cn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + strConnectionString);
        cn.Open();
    }
    private void getData()
    {
        connectDatabase();

        string strSelectState = "select state from tblState order by state";
        da = new OleDbDataAdapter(strSelectState, cn);
        ds = new DataSet();
        da.Fill(ds);

        DropDownList1.DataSource = ds.Tables[0];
        DropDownList1.DataTextField = "state";
        DropDownList1.DataValueField = "state";

        DropDownList1.DataBind();

        cn.Close();
    }
}

DESIGN SOURCE:

<body>
    <form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="DropDownList1" runat="server">
        </asp:DropDownList>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Delete" /></div>
    </form>
</body>

ACCESS DATABASE:

ID  STATE
--  -----
10   AAA
20   BBB
30   CCC
40   DDD

I am sending the relevent db and code which has been used in my code

If anybody can help I will be grateful to him.

Thanks
wajid

Your code is fine, its this line:

DropDownList1.SelectedValue;

This is supposed to be:

DropDownList1.SelectedItem.Value;

Hi SheSaidImaPregy

Thanks for your help.
But still its giving the same problem

Thanks Again
Wajid

I'm sorry I missed that completely. One thing, because it is C#, it has to be dropdownlist1.SelectedValue

Also, you need to put your page_load in a "ispostback" statement. The reason why it is deleting the top one is that even during postbacks, the page_Load event is fired. Therefore, your dropdownlist is repopulated via getData();. Since it is repopulated, the selected index is [0], which means when you go to delete your selected value, it grabs the selected index, which is now again defaulted to [0].

To prevent this, you need to put your page_load in a ispostback like:

void page_load..
{
  if (!isPostBack) {
    getData();
  }
}

This way your page_load doesn't fire on a postback, so your selectedindex will remain the same, and the correct value will be deleted.

Hi shesaidimapreggy

Thanks a lot, its working fine now.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.