vb.net code for create a class file

Question

1.00/5 (1 vote)

See more:

How to create a class file for containing all the tables and their fields of database(sql server/ms access) in VB.Net.
pls provide ~~the code~~ for above problem in vb.net.

Posted 18-Mar-11 0:32am

sandeep sonkar

Updated 18-Mar-11 0:51am

Albin Abel

v3

Add a Solution

Comments

Albin Abel 18-Mar-11 6:45am

Not sure what you are asking for. A in memory copy of the database? May be you may need to have a look at repository patterns

Sandeep Mewara 18-Mar-11 6:46am

pls provide the code for above problem in vb.net.
Anything less would not work for you? Why?

3 solutions

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)

Simon_Whale · Answer 1 · 2011-03-18T01:40:00

Solution 3

Your to vague!

do you want to get the column names from the results of a query? If so this will work for sql server

get column names from a sql server query[^]

if I got it wrong you need to expand your question

Posted 18-Mar-11 1:40am

Simon_Whale

Eduard Keilholz · Answer 2 · 2011-03-18T00:58:00

Why would you want this? Can you not just load the table in a DataTable object, or use Entity Framework for your SQL Server tables?

Right click your project and choose [ Add -> New Item ]

In the dialog box choose ADO.NET Entity Data Model and enter a name for the object (for example DatabaseNameEntities)

A blank screen appears, right click it and choose 'Generate model from Database'.

Good Luck,

Eduard

jim lahey · Answer 3 · 2011-03-18T00:54:00

Solution 1

If you want to generate some sort of model of a database in VB.net you can use ADO.net DataSets, Linq To SQL or Entity Framework.

Posted 18-Mar-11 0:54am

jim lahey