How can i create a table in sql server 2005 that is totally new for me..?

Question

0.00/5 (No votes)

See more:

I have one problem.

I simply want to know how I can create a table that can be easily used as a back end for my solution in VB2010.

I also want to know that when we choose a data source in a vb.net that is for sql server, which we want to choose.
Simply which can be used because there is 2 or 3 with little different name?

Please try to help me.
Give me any reference.

Posted 15-Nov-10 22:27pm

Neeil

Updated 15-Nov-10 22:47pm

Dalek Dave

v3

Add a Solution

Comments

Dalek Dave 16-Nov-10 4:47am

Edited for Grammar, Syntax and Readability.

Neeil 17-Nov-10 23:29pm

thank you..

Simon_Whale 18-Nov-10 4:04am

read this http://visualbasic.about.com/od/usingvbnet/a/SetupProj01_2.htm

2 solutions

Solution 2

Sqlconnection Example[^]

MSDN Beginner Developer Center[^]

check these few links out that should get you started, I would suggest that if they dont give you the information that you need then google with such search terms as "VB.NET sqlconnection" or "VB.NET sqlcommand"

Posted 16-Nov-10 4:54am

Simon_Whale

Comments

Neeil 17-Nov-10 23:25pm

Can u solve my other quetion....?
How to create a setup in vb.net.....?

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)

Manoj from Pune · Accepted Answer · 2010-11-15T23:40:00

Solution 1

I am not getting your next question question, but hopefully i can answer the first.
If you have a SQL server management studio then explore your object explore select database in which you want to create a table, under selected databse name there is a folder "Tables" right click on it click to new table... and then add columns to that table. I got your next answer... Use Microsoft SQL Server as a data source. ok.

Posted 15-Nov-10 23:40pm

Manoj from Pune

Comments

Neeil 16-Nov-10 5:57am

yes u get it right......But what about first.....please tell me na.....

Manoj from Pune 16-Nov-10 6:03am

i answered it dude. The answer is open SQL Server Management studio if u have and procedd as i have written.

Neeil 16-Nov-10 11:08am

ok....My mistake........i get it.......thankx a lot......

Neeil 17-Nov-10 23:25pm

Can u solve my other quetion....?
How to create a setup in vb.net.....?