Create Table in MSSQL using Visual Studio

[furqi]

hi every one

my question is that i actually want to make a table in a database and update delete the recordsin that table

The thing is that i dont want to make the database table in the sql server but i want to make it in the visual web developer (the editor i am using) can any body gimme any idea abt how i can do this orany link regarding to this
i shall be very thankful tou you and waiting for hte reply

regards
furqi

[furqi]

cmon can any body reply help me out!!!

[semomaniz]

are you trying to attach a sql database to the project or just directly access the database that is on the server ?

[furqi]

i dont want to attatch it with sql i only want to make a table on the server means make a table on the editor (the support that the edotor gives you ) like in visual web developer we can make a table by ourself
i can make a table there but i cant be able to insert update and delete the record there i am actually new in dat base u can say in ado.net thats why

waitibng for ur reply

[semomaniz]

Creating table on the editor ? well VS does allow to creates tables but it has to end up in a from of sql database either attached database or to a actual server.

First on your server explorer create a connection to the database .(here you will connect to the server where database resides or to the one in the app_Data folder). After the connection is successfully made you will be able to expand the database in tree format, then right click on the tables and bingo you should be able to add a new table.

I am hoping this is what you are looking for

[furqi]

well i know how to make a table but i dont know how to insert delete update record there

like wise in php we make a simple table in php admin and in the editor we just run our commands using insert statements and the data manipulation starts

i want to do it in asp.net how could i do this
i actually want to know the code
thanks

[semomaniz]

So are you trying to write a code that will insert data to that table you created or are you trying to use VS feature to insert data manually?

[furqi]

yes but i am not using visual web developer i amusing visual web developer can ya plzz help me out

[semomaniz]

you still haven't answered my question. are you trying to write a code to insert or are you trying to use VS to insert data manually?

[furqi]

i want to write a code

[semomaniz]

This might help you

http://www.asp.net/learn/data-access/

http://www.4guysfromrolla.com/articles/050207-1.aspx

[Frinavale]

If that doesn't help then check out the following MSDN articles on the topic:

• Using SQL Server Express with ASP.NET
• How to: Create SQL Server Express Edition Databases

-Frinny