Inserting HashTable Values into Database

[bharathiyerc]

I have created a stored procedure for insert

CREATE PROCEDURE dbo.insert_sample(@Name varchar(50),@Age char(4),@City varchar(50))
AS
INSERT dbo.Test1 VALUES(@Name,@Age,@City)

I want to create an HashTable, and insert Hashtable values to table......

waiting for answers

[Plater]

I would think a DataTable object would be better suited then a hashtable, but you're free to use whatever you want.
Have you gone through this:
http://www.thescripts.com/forum/thread635615.html

[bharathiyerc]

I have been alloted an assignment, it goes as :

1.Place 3 textboxes,for name, city & age

2.Create an Class.cs, in that declare property to get & set values.
3.Create instance of Class.cs in code behind and assign the textbox values to it.
4.And insert the values in database using the instance from another class.cs (where i will place my insert command)

I have finished the above 4.......Next

5.create stored procedure and then create an hashtable, and concatenate the "Keyname" with i/p parameters inside an loop.....

Can help me out for 5th point.......i know about Connection string and how to use it.......

[Plater]

We're not supposed to do assignments.
But I guess it sounds like for every record you are going to be inserting, read off the values from the hashtable (which seems silly since you can only get one record out of that nicely) and execute your stored procedure with those values.