473,326 Members | 2,126 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

visual studio.net 1.1 edit

I am writing a vb.net program that needs to create a table in the same format
each time it creates a new table. This is a "ulility" program that I am going
to be using it for.
Right now I have keyed this large table into sql server 2000 and the
vb.net program I wrote loads all the columns appropriately. I have run sql
server 2000 with the "generate script" for me have have saved the sql server
2000 code that will create a table.

The start of the script looks like
"CREATE TABLE [dbo].[test_table] ([field1] [varchar] (40) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[field] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

The end of the table looks like:
[WC_USE.22] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,[WC_PASSWORD.20] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , {
[MPLANNER] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

I would like to incorporate this code into the VB.net program. To to this I
need to put " (quotes) at the start of every line and I need to put " & _
at the end of every line.

Is there a way to have this completed for me without having to key this in
on every line? This would be similar to the "comment select lines" and
"uncomment selected lines" feature that the visual studio .net ide has.

Thanks!
May 30 '06 #1
0 729

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bryan Van. | last post by:
Hello, I've had Visual Studio .NET for C# only two weeks now. Today I encounter a big problem with the developer. The edit menu is disabled! Both using the right click of the mouse, the edit menu...
0
by: Michiel | last post by:
Hello, I want to edit my existing HTML Help Workshop project from Visual Studio. Therefore, I've added it to my project and selected "C:\Program Files\HTML Help Workshop\hhw.exe" as the default...
4
by: Nathan Sokalski | last post by:
When editing an ASP Table, Visual Studio does not allow me to edit it in Design View. This makes it harder to add elements, because I must add every element either by using Design View to create...
3
by: Shapper | last post by:
Hello, I am starting 2 new projects to deliver in January 2006. I want to create them in Asp.Net 2.0 using Visual Studio 2005. All my clients web sites are Visual Studio 2003 projects in...
0
by: fiona | last post by:
Innovasys Ltd., a leader in help authoring and documentation tools, today announced the inclusion of a tailored version of the Innovasys HelpStudio help authoring product, HelpStudio Lite, in the...
4
by: William LaMartin | last post by:
For the past month or so, while working with VB.net, as I use the mouse to either move a control or resize it, the mouse cursor will freeze sometimes. This happens from several times a day to once...
7
by: Nathan Sokalski | last post by:
I am an ASP.NET developer, and Visual Studio 2005 seems to have stopped declaring the controls that I add in the *.designer.vb files, therefore forcing me to manually add them before I can use them...
1
by: Cramer | last post by:
I'm running XP Pro/SP2 + patches and updates, with Visual Studio Professional 2008 (and no prior installation of Visual Studio ever installed). When attempting to open an ASP.NET Web application...
2
by: Nikolay Belyh | last post by:
1. Why does Visual Studio 2008 started ignoring //{NO_DEPENDENCIES} in resource.h? If I edit file "resource.h" _manually_, it rebuilds the whole solution. It worked just fine with Visual Studio...
2
by: puzzlecracker | last post by:
I am sick and tired of looking in explorer or right-click on the type in some class to go to its definition. In eclipse (java) you could do ctrl-shift-t and then type a Type you're looking for and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.