|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
April 23rd, 2008, 08:16 PM
|
|||
|
|||
|
Easily Fill Database Records in Visual Studio?
I was wondering if anyone knows if Visual Studio has a tool or feature to let you easily add records to a table and produces the SQL code for you.
I have lists of information (on paper) that I need to add to the database quickly and efficiently. Right now I just created an SQL script and am typing in all the code manually. However, this is very slow as you cannot tab between fields, have to keep looking at the screen to move the cursor around, and is simply taking way too long. I'd love a faster way to enter data into SQL Server, and I have Visual Studio 2008 (which I've been using thus far) to interact with the database. I'd also need it to show the SQL code used to actually populate the data so I could save it in another file.
|
|
#2
April 28th, 2008, 02:35 PM
|
|||
|
|||
If you have MS Access, you could create a table and a form to enter the data. Afterwards, just write a small script to generete the INSERT statements.
 Otherwise, depending on the database (WinDoze SQL, MySQL,...) you could 'link' the table to MS Access and enter the data. Some dbms will generate the transaction log as a series of DML (insert/update/delete) statements. 
__________________
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Easily Fill Database Records in Visual Studio? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
