Search This Blog

Monday, July 19, 2010

Convert Data table columns to Arrary

DataSet ds = objSummary.BindDataSet("xxxxxxxxxxxxxxxxxx", dts, strUserid);

        DataTable dt = ds.Tables[0];
        string strTitle = ds.Tables[1].Rows[0]["ABBR"].ToString().Trim();
        //dt.DefaultView.Sort = "PLAN  DESC";
        // DataView dv = dt.DefaultView;
        // dv.Sort = "PLAN  DESC";


        string[] legends = Array.ConvertAll(dt.Select(), delegate(DataRow row) { return (String)row["LOSSREASON"].ToString().Trim(); });

        string[] xValues = Array.ConvertAll(dt.Select(), delegate(DataRow row) { return (String)row["REVENUE"].ToString().Trim(); });

No comments:

Post a Comment