Hi Everyone..
please help me in my project. i have create a procedure which i call to it in my aspx.cs file bellow is brief summary of my code.
What I have tried:
Here is my stored procedure:
CREATE PROCEDURE PLACE_DEMAND
(
@ITEM_ID INT,
@EMP_ID INT,
@DEMAND_DATE DATE,
@DEMAND_QUANTITY INT,
@DEMAND_STATUS VARCHAR (50),
@STATUS_DATE DATE
)
AS
BEGIN
INSERT INTO Demands (Item_ID,Emp_ID,Demand_Date,Demand_Quantity,Demand_Status,Status_Date) VALUES (@ITEM_ID,@EMP_ID,@DEMAND_DATE,@DEMAND_QUANTITY,@DEMAND_STATUS,@STATUS_DATE)
END
And bellow is my function which execute my procedure:
public static void exec_insert_proc(string proc, string[] param)
{
SqlCommand cmd = new SqlCommand(proc, DBConnection());
cmd.CommandType = CommandType.StoredProcedure;
int i;
for (i = 0; i <= param.Length - 1; i++)
{
string[] nme;
nme = param[i].Split(':');
cmd.Parameters.Add(nme [0], SqlDbType.VarChar, 50).Value = nme [1];
}
cmd.ExecuteNonQuery();
}
And Finaly this my function to which i am passing parameters
string abc = Convert.ToString(DateTime.Now);
string[] array = new string[]
{
"@ITEM_ID:"+DDL_Select_Item.SelectedValue,"@EMP_ID:"+txt_Emp_ID.Text,"@DEMAND_DATE:"+txt_Date.Text,"@DEMAND_QUANTITY:"+txt_Quantity.Text,"@DEMAND_STATUS:"+txt_Status.Text,"@STATUS_DATE:"+abc
};
db.exec_insert_proc("dbo.PLACE_DEMAND", array);