load data table to array

Dinesh Santhalingam

I have a sql table .I want load my table content into a data table dt .Add my data table content into an array and my array(tablearray) into a dictionary (lst).At last i return my dictionary .Here my code .I don't know How to add my array into dictionary? please help me to solve this problem.

[System.Web.Services.WebMethod]
public static Dictionary< string, object> Load()
{
string sql = "SELECT Name,Marks FROM table4";
using (SqlConnection Connection = newSqlConnection((@"myconnstrng")))
{
using (SqlCommand myCommand = new SqlCommand(sql,Connection))
{
Connection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
DataTable dt = new DataTable();
dt.Load(myReader);
Connection.Close();
var tableEnumerable = dt.AsEnumerable();
var tableArray = tableEnumerable.ToArray();
Dictionary<string, object> lst = new Dictionary<string, object>();
return lst;
}
}
}
}

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dinesh Santhalingam9y ago
Error populating : An item with the same key has already been added.@
Mayank
0
Mayank9y ago
foreach(var data in tableArray)
            {
               // tableArray[1].ItemArray[1]
                lst.Add(data.ItemArray[1].ToString(), new { Id = data.ItemArray[0].ToString(), Name = data.ItemArray[1].ToString() });
            }
0
Dinesh Santhalingam9y ago
Can anyone suggest idea to do my task?
0
Dinesh Santhalingam9y ago
I don,t understand the return Type @ midhun
0
Midhun Tp9y ago
Hi,

You can access that "mydictionary" using below code -

lst["mydictionary"]

To return that, you may have to change return type in your method.
0
Dinesh Santhalingam9y ago
i want to return mydictionary How to do? @ Midhun
0
sudipta sanyal9y ago
Hi
Then Just Convert Your Datatable To json data using Newtonsoft.Json; if you does not have Newtonsoft.Json in your project , Please download from https://www.nuget.org/packages/Newtonsoft.Json/9.0.2-beta1

jsonString = JsonConvert.SerializeObject(objDataTable);
0
Midhun Tp9y ago
Hi,

Please try below code -

var tableEnumerable = dt.AsEnumerable();
var tableArray = tableEnumerable.ToArray();
Dictionary lst = new Dictionary();
lst.Add("mydictionary", tableArray);

0
Dinesh Santhalingam9y ago
yes @
sudipta sanyal
0
sudipta sanyal9y ago
As Per Your code, I Thing You try to call the the method from javascript/ json post .

Is this true ??
+1
Dinesh Santhalingam9y ago
Thanks for your response.I want to add my to Array[ tableArray ] to dictionary (lst).how can i do ?Give me some idea @ sudipta sanyal
0
sudipta sanyal9y ago
public static List> DataTableToDictionary(this DataTable dt)
{
List> dictionaries = new List>();
foreach (DataRow row in dt.Rows)
{
Dictionary dictionary = Enumerable.Range(0, dt.Columns.Count)
.ToDictionary(i => dt.Columns[i].ColumnName, i => row.ItemArray[i]);
dictionaries.Add(dictionary);
}
return dictionaries;
}
+1
Dilip Gupta9y ago
why you convert table content into an array and then array(tablearray) into a dictionary

you can directly convert datatable to dictionary

reffer this
http://www.programmingposts.com/2015/10/datatable-to-dictionary-conversion-c-sharp.html
+1