Hash Tables

Question

I am trying to find a way to populate my hash table variables from a database instead of hard coding them like this ( hshTable . Add(Author1 Mahesh Chand);) id rather want to get the data or object values of the hashtable from a database and then populate the hash htable maybe something like this Hashtable ht = new hashtable(); ht.ADD(“FirstName””Get data from database stored procedure”) I hope im making sense. Thanks in adavnace.

IamStalker · Answer

i think first of all you will be have to create unique index identity and it will look some thing like that HashTable ht = new HashTable(); foreach(DataRow dr in ds.Tables[0].Rows) { ht.Add(dr[EmployeeID].toString()dr[EmployeeName].ToString()); } it's works for me very nicely so have fun!!! Regards IamStalker...

Ryan Alford · Answer

I would also check to make sure the key doesn't already exist in the HashTable before you add it. This would happen if you returned duplicate authors....which could be common if 1 author has written 2 books.

Satish Kathi · Answer

//Here is sample code to read data from access table1 and fill hash Table //make sure column value which is data source for Key value in hash table is unique //(in this example values in Column1 must be unique) //Connection string for Access string ConnectionStringAccess = string .Format( Data Source= {0}; Provider=Microsoft.Jet.OLEDB.4.0; Persist security Info = false  @C:\KSK_Access.mdb ); //Connection object for Access OleDbConnection connAccess = new OleDbConnection (ConnectionStringAccess); //Command object for Access OleDbCommand cmdAccess = connAccess.CreateCommand(); cmdAccess.CommandType = CommandType .Text; cmdAccess.CommandText = SELECT Column1 Column2 From Table1  ; //Open connections connAccess.Open(); //Read Excel OleDbDataReader drAccess = cmdAccess.ExecuteReader(); Hashtable ht = new Hashtable (); while (drAccess.Read()) { ht.Add(drAccess[0] drAccess[1]); } //close connections connAccess.Close(); //hope this helps