Retrieving Data from database using TableAdapter, storing it in String/Array

[zhshqzyc]

Here is a little code but not completed.
Hope somebody give me a hint. I want to sort the result.

Object RReturn = new Object();
            DataSet1TableAdapters.droughtDataTableAdapter k1 = new DataSet1TableAdapters.droughtDataTableAdapter();
            String[][] ddata;
            for (int i=0;i<k1.GetData().Rows.Count-1;i++)
            {
                RReturn = k1.GetData (i)
            }

[Arjay]

I'd start by learning how to use the DataTableAdapter.

Search Bing or Google for "DataTableAdapter C# example".