How to add parameter through array

Question

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

Check this link hope it will work. > forums.asp.net/t/1538079.aspx/1 — Himanshu
– Himanshu, Commented Jan 7, 2013 at 8:27

Kuzgun · Accepted Answer · 2013-01-07 07:51:50Z

2

 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.

answered Jan 7, 2013 at 7:51

Kuzgun

4,7575 gold badges36 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Adil · Accepted Answer · 2013-01-07 07:23:26Z

1

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]);

answered Jan 7, 2013 at 7:23

Adil

148k25 gold badges217 silver badges207 bronze badges

3 Comments

user1947927 Over a year ago

what if i need to send multiple value. So i have to use for loop again.

user1947927 Over a year ago

'int count = vill.Rows.Count; string[] ar = new string[count]; for (int i = 0; i < vill.Rows.Count; i++) { string yojna=vill.Rows[i]["YojnaNo"].ToString(); ar[i] = yojna;} Session["value"] = ar;' this is my code to add array in session can u check it too

Adil Over a year ago

Where you have this loop ? as I could not see in question

Collectives™ on Stack Overflow

How to add parameter through array

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related