• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 374
  • Last Modified:

Paramaters to pass in datatable from vb to SQL 2008

How do I pass in an entire table to SQL Server 2008 from my web page vb code using the following

Blah...blah...blah...

 objCmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@leadID", System.Data.SqlDbType.Int)).Value = dt6

blah...blah...blah...
0
Larry Brister
Asked:
Larry Brister
1 Solution
 
Deepak LakkadCommented:
here is a link which may helpful to you

http://msdn.microsoft.com/en-us/library/bb675163.aspx

Deepak Lakkad
0
 
Larry Bristersr. DeveloperAuthor Commented:
Perfect!  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now