[RESOLVED] Retrieve value from table and How to store in string variable

[ehsan85]

Hello,

I want to store some data to string array that came from Database table.



The table Data is (only a column):

Alice Mutton
Aniseed Syrup
Boston Crab Meat
Camembert Pierrot
Carnarvon Tigers

...

...



I want to store this retrieved data to String array like (Programetically):

string[] data = {"Alice Mutton", "Aniseed Syrup", "Boston Crab Meat", "Camembert Pierrot", "Carnarvon Tigers"};



How can I fix it?



best regards

ehsan

[jmcilhinney]

Follow the CodeBank link in my signature and check out my thread on Retrieving & Saving Data. One of the examples uses a data reader to read the result set of a query one record at a time. You can create a List<string> and then read the data the same way and add each value to that list. When you're done, you can just use the List as is or, if you specifically need an array, you can call its ToArray method.

[ehsan85]

Finally I got it Here is the code

PfolioDataContext db = new PfolioDataContext();
        string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["PortfolioDBConnectionString"].ConnectionString;
        SqlDataAdapter adpt = new SqlDataAdapter("select PortID, pName from Portfolio", conStr);
        DataTable dt = new DataTable();
        adpt.Fill(dt);

        int TotalRow = dt.Rows.Count;

        string[] res = new string[TotalRow];
        for (int i = 0; i < TotalRow; i++)
        {
            res[i] = dt.Rows[i]["pName"].ToString();
        }

This problem is solved