how to split the commas from the querystring using

seerum_san · July 8th, 2003, 11:42 PM

hai,

how to split the commas from the querystring using asp.net, as iam having one problem here is the url look like this:
http://test.aspx/peoplecode=20,40,50,60 i want to write the select query where i can take seperatly each value from the above query string for ex select * from people where peoplecode=40,select * from people where peoplecode=60 and like this how can i do this pls help me out thanks in advance

NotNowJohn · July 9th, 2003, 03:19 AM

Code:

    string peoplecode_qry=Request.QueryString["peoplecode"];
    string[] peoplecode_array;
    peoplecode_array = Regex.Split(peoplecode_qry, ",");
    foreach (string peoplecode_item in peoplecode_array)
    {
        qry="SELECT * FROM people where peoplecode=" + Int32.Parse(peoplecode_item);
        //etc...    
    }

HTH.
NNJ

...but the Soon is eclipsed by the Moon

seerum_san · July 9th, 2003, 04:36 AM

thanks u, but i need it in asp.net it is not working in asp.net i think the code u had given is in c# can u help me out in asp.net

abbylee26 · July 10th, 2003, 08:41 AM

I thought C# was created just for AFS.NET
Anyway C# works well with the .NET framework.

Sorry I know that doesn't answer your question...

U.N.C.L.E. · July 18th, 2003, 03:09 AM

Try:

For Each N In Split(Request("peoplecode"),",")
SQL = "SELECT * FROM people WHERE (peoplecode=" & N & ");"
Next