Make An insert Function

Question

0.00/5 (No votes)

See more:

Insert Data in Sql Server using function

using VB.Net
-------------------------
i want to make an insert fucntion or method or class

who work with any table and any column
with out any changes
what should i do for these code
----------------------------------
i just add

VB

dim table as string
table = scott

and

VB

class.insert(1,2,3,4,5,6,7,8)

or

VB

class.insert(8,8,8,8,8,8,8,8,8,8,,8,8)

means no change any things in function
------------------------------------------
just give table name and values to insert....

[edit]Spurious formatting removed, code blocks added - OriginalGriff[/edit]

Posted 30-Apr-13 1:23am

saimm

Updated 30-Apr-13 1:30am

OriginalGriff

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-04-30T01:36:00

In all probability, you can't do that, or not without a lot of work to create a generic routine.
The table name is no problem: just insert it into your SQL INSERT statement:

VB

Dim sqlCommand as String = "INSERT INTO " & tableName & "...

The problem comes with the actual table data itself.
Unless you know exactly what the table holds, there is a very good chance that the insert will fail: because you are trying to be generic about this, you can't list the columns that you are going to insert, so you don't know how many rows worth of data you are trying to insert. Since the SQL INSERT statement is row based, this becomes a real problem.

In addition, if any of your columns are Identity fields, you cannot supply a value for them so you have to explicitly name the fields you do wish to load in the INSERT statement (and it's considered good practice to do so anyway).

To be honest, I wouldn't do it - just use a DL that "knows" about the database structure and save data that way instead.