AzamSharp

USE Northwind

-- declare the variables 
DECLARE @column_name varchar(20) 
DECLARE @ordinal_position int 
DECLARE @counter int 
DECLARE @totalRows int 
DECLARE @table_name varchar(20) 
DECLARE @commandObjectName varchar(20) 

SET @counter = 1; 
SET @table_name = 'Customers'
SET @commandObjectName = 'myCommand' 


SELECT @totalRows =  COUNT(*) FROM information_schema.columns WHERE 
table_name = @table_name

WHILE @counter <= @totalRows 
BEGIN 

SELECT @column_name = COLUMN_NAME FROM information_schema.columns WHERE 
table_name = @table_name AND @counter = ORDINAL_POSITION

Print @commandObjectName+'.Parameters.AddWithValue("@'+@column_name+'",'+LOWER(@column_name)+')'

SET @counter = @counter + 1

END 

GO

I am using T-SQL you can easily use the STORED PROCEDURE.

This T-SQL query will generate the following parameter collection.

myCommand.Parameters.AddWithValue("@CustomerID",customerid)
myCommand.Parameters.AddWithValue("@CompanyName",companyname)
myCommand.Parameters.AddWithValue("@ContactName",contactname)
myCommand.Parameters.AddWithValue("@ContactTitle",contacttitle)
myCommand.Parameters.AddWithValue("@Address",address)
myCommand.Parameters.AddWithValue("@City",city)
myCommand.Parameters.AddWithValue("@Region",region)
myCommand.Parameters.AddWithValue("@PostalCode",postalcode)
myCommand.Parameters.AddWithValue("@Country",country)
myCommand.Parameters.AddWithValue("@Phone",phone)
myCommand.Parameters.AddWithValue("@Fax",fax)

Now you can simply copy and paste the above generated parameter collection into your C# code.

I hope this helps you in your future projects.