CODEWITHSUNDEEP
c#asp.net
user1947927
user1947927

Reputation: 190

How to add parameter through array

I am adding a parameter through Querystring. My code is:

 SqlCommand Cmd = new SqlCommand("Showvillage", Constr1);
        Cmd.CommandType = CommandType.StoredProcedure;
        Cmd.Parameters.Add("@Yojna_No", Request.QueryString[0]);
        Cmd.Parameters.Add("@Village_Code", Request.QueryString[1]);
        DataSet ds = new DataSet();

Now due to my requirement i have to send multiple value for each parameter and the multiple value is coming as Session array from previous page.Can anyone solve how to add that session array to parameter

 SqlCommand Cmd = new SqlCommand("Showvillage", Constr1);
        Cmd.CommandType = CommandType.StoredProcedure;
        string[] getyojna = (string[])Session["value"];
        string[] getvillage = (string[])Session["values"];
        Cmd.Parameters.Add("@Yojna_No", Request.QueryString[0]);//change here for session
        Cmd.Parameters.Add("@Village_Code", Request.QueryString[1]);//change here for session

Upvotes: 1

Views: 215

Answers (2)

Kuzgun
Kuzgun

Reputation: 4737

 SqlParameter something = new SqlParameter("parameterName", "value");
     SqlParameter something2 = new SqlParameter("parameterName2", "value2");
    SqlParameterCollection parameters=new SqlParameterCollection();
    parameters.Add(something);
    parameters.Add(something2);

Maybe you should use something like this.

Upvotes: 2

Adil
Adil

Reputation: 148130

If you have successully assigned the session object Session["values"] to getvillage string array then you can simply use index of string array (getvillage) to get elements. 

Cmd.Parameters.Add("@Yojna_No", getvillage[0]);
Cmd.Parameters.Add("@Village_Code", getvillage[1]);

Upvotes: 1

Related Questions