How Do I Call This Method With Defined Parameters

Question

1.00/5 (1 vote)

See more:

I have this code in my DataAccessLayer, I want to call this method to store data into my database. How do I call this method with defined parameters?

I didn't write this, but I need to use it.

C#

public int InsertData(string StoredProcedureName, List<DataParameters> lParameters)
         {
             int iResult = 0;
             try
             {
                 DataConnector oDataConnector = new DataConnector();
                 oSqlConnection = oDataConnector.GetConnection();

                 oSqlCommand = new SqlCommand(StoredProcedureName, oSqlConnection);
                 oSqlCommand.CommandType = CommandType.StoredProcedure;

                 foreach (DataParameters item in lParameters)
                 {
                     SqlParameter oParameter = new SqlParameter();
                     oParameter.ParameterName = item.ParameterName;
                     oParameter.DbType = item.ParameterDataType;
                     oParameter.Value = item.ParameterValue;
                     oSqlCommand.Parameters.Add(oParameter);

                 }
                 iResult = oSqlCommand.ExecuteNonQuery();

             }
             catch (Exception ex)
             {
                 Log.CreateLog(ex.ToString());

             }
             finally
             {
                 if (oSqlConnection.State != ConnectionState.Closed)
                 {
                     oSqlConnection.Close();
                 }

                 if (oSqlConnection != null)
                     oSqlConnection.Dispose();

                 if (oSqlCommand != null)
                     oSqlCommand.Dispose();

                 if (oSqlAdapter != null)
                     oSqlAdapter.Dispose();

             }
             return iResult;
         }


class DataParameters
{

    private string iParameterName;
    private System.Data.DbType iParameterDataType;
    private string iParameterValue;

    /// <summary>
    /// This method is to add parameters by creating a list object
    /// </summary>
    /// <param name="ParameterName"></param>
    /// <param name="ParameterDataType"></param>
    /// <param name="ParameterValue"></param>
    public DataParameters(string ParameterName, System.Data.DbType ParameterDataType, string ParameterValue)
    {
        this.iParameterName = ParameterName;
        this.iParameterDataType = ParameterDataType;
        this.iParameterValue = ParameterValue;
    }

    /// <summary>
    /// Property for setting ParameterName
    /// </summary>
    public string ParameterName
    {
        get { return iParameterName; }
        set { iParameterName = value; }
    }

    /// <summary>
    /// Property for setting ParameterDataType
    /// </summary>
    public System.Data.DbType ParameterDataType
    {
        get { return iParameterDataType; }
        set { iParameterDataType = value; }
    }


    /// <summary>
    /// Property for setting the ParameterValue
    /// </summary>
    public string ParameterValue
    {
        get { return iParameterValue; }
        set { iParameterValue = value; }
    }
}

Posted 10-Sep-15 2:09am

King Fisher

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abdul Samad KP · Answer 1 · 2015-09-10T02:40:00

Solution 1

Instead of asking it here, try to learn basics of programming, nowadays, there are a lot of resources available

XML

//Create list

List<DataParameters> lParameters=new List<DataParameters>();

//Create paramters, you should change @NameOfParamter, System.Data.DbType.String, Value of paramter as per your requirment

DataParameters param1=New DataParameters("@NameOfParamter",System.Data.DbType.String,"Value of paramter");

//Add parametrs to the list

lParameters.Add(param1);



//call the method

int result=InsertData("Your sp name",lParameters);

Posted 10-Sep-15 2:40am

Abdul Samad KP

Comments

King Fisher 10-Sep-15 8:55am

if i want to pass another parameter ,Is this i have to do?
DataParameters param2=New DataParameters("@NameOfParamter",System.Data.DbType.String,"Value of paramter");
lParameters.Add(param2);

but if i wanna pass 10 parameters to list, then What i have to do?
should i have to repeat it.

Abdul Samad KP 11-Sep-15 17:03pm

If you want to pass 10 parameters , you have to add all of them to the list

Enemali William 10-Sep-15 9:05am

You iterate through the data and call the function at every iteration to save the record

King Fisher 10-Sep-15 9:08am

I have to store all the data in list which i want to store, then i have to call the method with the collection list.

Enemali William · Answer 2 · 2015-09-10T04:18:00

//Create list

List<dataparameters> lParameters=new List<dataparameters>();

for (int i=0; i < number_of_parameters_to_insert; i++)
{

DataParameters param+i=New DataParameters("@NameOfParamter",System.Data.DbType.String,"Value of paramter");
lParameters.Add(param+i);

}
//call the method

int result=InsertData("Your sp name",lParameters);

You iterate through the item you want to add as a parameter and build up your list then call the insertData method after adding all items. You dont need to create multiple dataparameters to insert into a list. just reuse the existing one