How to save data from hash table to dataset

Question

HI,
I have one hash table. In that i have multiple data. Now i want to send all data from hash table to sqlserver table. How can i achieve this? Can any body pls give me some solution.

Thanks & Regards,
Nagaraju P

Satish Bhat · Answer

First read all HashTable data to a DataTable, then you can use SqlBulkCopy to save it to the database. string connectionString = "YOUR_CONNECTION_STRING"; // Your Hashtable with data Hashtable myHashTable = new Hashtable(); myHashTable.Add("Key1", "Value1"); myHashTable.Add("Key2", "Value2"); myHashTable.Add("Key3", "Value3"); myHashTable.Add("Key4", "Value4"); myHashTable.Add("Key5", "Value5"); // Create a DataTable and copy data from your Hashtable // Note: Replace the datatype with your datatype DataTable myDataTable = new DataTable(); myDataTable.Columns.Add(new DataColumn("Key", typeof(string))); myDataTable.Columns.Add(new DataColumn("Value", typeof(string))); foreach (DictionaryEntry item in myHashTable) { DataRow myRow = myDataTable.NewRow(); myRow[0] = item.Key.ToString(); myRow[1] = item.Value.ToString(); myDataTable.Rows.Add(myRow); } // Open a connection to the database. using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); // Create the SqlBulkCopy object. using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection)) { // Set the number of records updated in 1 batch // In this case store all values at one go bulkCopy.BatchSize = myDataTable.Rows.Count; // Map the Source Column from DataTabel to the // Destination Columns in SQL Server Table // Note if the column positions in the source DataTable // match the column positions in the destination table, // there is no need to map columns. bulkCopy.ColumnMappings.Add(0, 0); bulkCopy.ColumnMappings.Add(1, 1); bulkCopy.DestinationTableName = "YOUR_DESTINATION_TABLE_NAME"; try { // Write from the source to the destination. bulkCopy.WriteToServer(myDataTable); } catch (Exception ex) { // Show error message } } }

How to save data from hash table to dataset

Answers (1)