Save Insert DropDownList Selected Value to database in ASP.Net

caulson

SOLVED CLOSED ACTIVE ANSWERED
User: caulson
Posted: on Jan 20, 2014 01:40 AM
Forum: Data Controls
Answer: 1
Views: 12670

Dear All,

Based on below SQL code i would like to control the data insert.

Example If select type is 'DM', then only insert into the WM table.

Kindly advise, thank you.

  string InserttoWM = ConfigurationManager.ConnectionStrings["CIMProRPT01testserverConnectionString"].ConnectionString;
                                        using (SqlConnection Insertcn = new SqlConnection(InserttoWM))
                                        {
                                            using (SqlCommand Insertcmd = new SqlCommand("INSERT INTO [CIMProRPT01].[dbo].[WM_QTY_STATUS] (ITEM,ITEM_TYPE,DOCNUM,CONTAINER_QTY,LOCATOR,FROMLOCATOR,REASONCODE,CREATEUSER,CREATEDATE) VALUES (@ITEM,@ITEM_TYPE,@DOCNUM,@CONTAINER_QTY,@LOCATOR,@FROMLOCATOR,@REASONCODE,@CREATEUSER,@CREATEDATE) SELECT A.INV_ID, A.INV_TRANS_QTY, B.INV_TYPE, A.INV_CREATE_USER,A.INV_CREATE_DATE FROM CIMProRPT01.dbo.OTH_INV_TRANSACTION A JOIN CIMProRPT01.DBO.OTH_INV_DETAILS B ON A.INV_ID = B.INV_ID WHERE 1=1 AND A.INV_ID = @INV_ID AND B.INV_TYPE = 'DM'  AND A.INV_REASON_ID = 'ISSUE' AND A.INV_CREATE_DATE = @INV_CREATE_DATE", Insertcn))
                                            {



                                                using (SqlDataAdapter Insertda = new SqlDataAdapter(Insertcmd))
                                                {
                                                    Insertcn.Open();


                                                    Insertcmd.Parameters.AddWithValue("@ITEM", Item);
                                                    Insertcmd.Parameters.AddWithValue("@ITEM_TYPE", Inv_Type.SelectedValue);
                                                    Insertcmd.Parameters.AddWithValue("@DOCNUM", RefNum);
                                                    Insertcmd.Parameters.AddWithValue("@CONTAINER_QTY", Qty);
                                                    Insertcmd.Parameters.AddWithValue("@LOCATOR", FromLocation);
                                                    Insertcmd.Parameters.AddWithValue("@FROMLOCATOR", ToLocation);
                                                    Insertcmd.Parameters.AddWithValue("@REASONCODE", ReasonID);
                                                    Insertcmd.Parameters.AddWithValue("@CREATEUSER", MMSCUSER.Text);
                                                    Insertcmd.Parameters.AddWithValue("@CREATEDATE", MMSCDATE.Text);
                                                    Insertcmd.Parameters.AddWithValue("@INV_ID", Item);
                                                    Insertcmd.Parameters.AddWithValue("@INV_CREATE_DATE", MMSCDATE.Text);


                                                    Insertcmd.ExecuteNonQuery();

                                                    Insertcn.Close();

Download FREE API for Word, Excel and PDF in ASP.Net

Azim

0 9

Reply
ANSWER
User: Azim
Replied: on Jan 21, 2014 02:15 AM
Modified: on Jan 21, 2014 04:03 AM
Report

Yes you can. Like this

USE [Sample]
GO
/****** Object:  StoredProcedure [dbo].[InsertPerson]    Script Date: 01/22/2014 02:51:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[InsertPerson]
--InsertPerson 'Azim'
	@Name VARCHAR(30),
	@Id INT,
	@City VARCHAR(30),
	@Cost INT,
	@Salary INT
AS
BEGIN
	SET NOCOUNT ON;
	
	IF NOT EXISTS(SELECT name FROM Person WHERE Name = @Name)	
		INSERT INTO Person VALUES(@Name,@Id,@City,@Cost,@Salary)	

	SELECT * FROM Person WHERE Name = @Name	
	
END

In this Stored procedure i am inserting the record if the name is not exists and also selecting the data. If you dont want the codition then you can remove it. Procedure will execute both the queries.

HTML:

<form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true" OnSelectedIndexChanged="DropDownList1_OnSelectedIndexChanged">
            <asp:ListItem Text="Please Select" />
            <asp:ListItem Text="DM" />
        </asp:DropDownList>
    </div>
    </form>

C#:

protected void DropDownList1_OnSelectedIndexChanged(object sender, EventArgs e)
    {
        if (this.DropDownList1.SelectedItem.Text == "DM")
        {
            string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand("InsertPerson", con))
                {
                    using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.AddWithValue("@Name", "Azim");
                        // pass your paremeters
                        DataTable dt = new DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count > 0)
                        {
                            string name = dt.Rows[0]["Name"].ToString();
                        }
                    }
                }
            }
        }
    }

Make sure that you have to Pass the parameters for Insert Query and for Select query.

Thank You.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Save Insert DropDownList Selected Value to database in ASP.Net

Company

Explore

Follow us

Contact Us