Saving data from one DB Table in DropDown to another DBTable

How can i save the data which we got from one table of database to another table. Actually i want first to get data from first table using DROPDOWN and then save the data (i.e.Employee ID and Employee name) which we got in dropdown to another table of the database.

HTML code:

<asp:DropDownList ID="ddlEmployees" runat="server" AutoPostBack="true" OnSelectedIndexChanged="OnSelectedIndexChanged_ddlEmployees">

asp:DropDownList>

<br />

 CS Code:
protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                this.PopulateDropDownList();
            }
        }
 
        private void PopulateDropDownList()
        {
            string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand("SELECT FirstName,EmployeeID FROM Employees", con))
                {
                    using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                    {
                        con.Open();
                        DataSet ds = new DataSet();
                        da.Fill(ds);
                        this.ddlEmployees.DataTextField = "FirstName";
                        this.ddlEmployees.DataValueField = "EmployeeID";
                        this.ddlEmployees.DataSource = ds;
                        this.ddlEmployees.DataBind();
                        this.ddlEmployees.Items.Insert(0, new System.Web.UI.WebControls.ListItem(" --Select Please-- ", "0"));
                    }
                }
            }
        }

3 Replies
Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sign inCreate an account

Ramesh Barik9y agoPosted May 12, 2017, 3:43 AM Accepted answer Create on method which will insert you records in DB and call that method from your save button click. Ex: private void Save() { //Your code to push your data to DB. Here you can pass your dropdownlist selected value to the sp. // cmd.Parameters.Add("@Pram1", ddlID.SelectedValue.ToString()) If you also want to save your selected text then you can you ddl.SelectedItem.Text. //cmd.Parameters.Add("@Pram2", ddl.SelectedItem.Text) } Check this link. http://www.c-sharpcorner.com/UploadFile/47548d/simple-insert-select-update-and-delete-in-Asp-Net-using-mysq/
Ramesh Barik9y agoPosted May 12, 2017, 4:10 AM Welcome brother..
MLMohd lonpo9y agoPosted May 12, 2017, 4:02 AM thx bro.,