Visual Studio 2005 - Extract Rows From DataBase - Replace Fields - Insert Into Another Table

Mar 8, 2010

I work with Visual studio 2005 and Sql server data base. I extract 1 million rows from a database and I put the rows in a Sql table. With a simple direct extraction, in a few minutes I complete the operation:

Dim cmd As New SqlCommand(query, cnSql)
cmd.ExecuteNonQuery()
cmd.Dispose().

But, if I must select and modify some fields between extraction and introduction, it takes a lot of time!
I work in this way. I extract rows from Dbase, Table1, and I put all into a Collection using dataReader:

Dim cmd As New SqlCommand(query, cnSql)
Dim coll As New Collection
coll.Clear()
Dim dr As SqlDataReader = cmd.ExecuteReader()
I replace some fields with the string "YES".
Dim toRepl As String = ""
If dr.HasRows Then
Do While dr.Read
toRepl = dr(5).ToString
If Len(toRepl) <= 3 Then ToRepl = "YES"
collPrel.Add(dr(0).ToString)
collPrel.Add(dr(1).ToString)
.................. ..............
collPrel.Add(toRepl)
collCount = collCount + 1
Loop
End If
dr.Close()
cmd.Dispose()
Now, I insert all into a SQL Table2:
Dim a As String = "", b As String = "", c As String = "" etc.
For i = 1 To collPrel.Count Step 6
a = collPrel.Item(i).ToString
b = collPrel.Item(i + 1).ToString
.............. ...............
f = collPrel.Item(i + 5).ToString
queryIns = "INSERT INTO Tab (name, adress, etc)
VALUES ('" & a & "', '" & b & "', '" & c & "', etc. )
Dim cmdIns As New SqlCommand(queryIns, cnSql)
cmdIns.CommandTimeout = 600
cmdIns.ExecuteNonQuery()
cmdIns.Dispose()
Next

This way to work goes right but it is necessary a lot of time for completing the operation.

View 1 Replies


Similar Messages:

Visual Studio :: Can't Open A SourceSafe 6 Database With Visual Studio 2005?

May 25, 2010

I know both these software are old and that I can update to newer version. But I need to do it with those software in particular.I have Visual Studio 2005 and Visual SourceSafe 6 installed on my computer. When I try to open Visual SourceSafe 6 database using Visual SourceSafe 6 directly, I have no problem at all.Then I try to open a project solution I took from SourceSafe using Visual Studio 2005. Right away I receive this messageThe solution appears to be under source control, but its binding information cannot be found. It is possible that the MSSCCPRJ.SCC file or another item that holds the source control settings for the solution, has been deleted. Because it is not possible to recover this missing information automatically, the projects whose bindings are missing will be treated as not under source control.

Then an invite to chose a SourceSafe Database open. I click on BROWSE. First thing I noticed : The SourceSafe available databases list is empty (while I remind, it's not in SourceSafe 6. I can see there the COMMON database and the VSS database which is located on a different server on our network. Before that, I went in TOOLS->OPTIONS->SOURCE CONTROL, and make sure Visual Source Safe was selected as the Plug-in to use for a Source Control).So I click again on Browse, and locate my srcsafe.ini file. Everything is OK. It evens confirm me that my database path is
\dev2k3programmationVSS and that my database name is indeed VSS. So it found it. I then click on OK.

But when I do, the Database is not added to my available list, at all. The result, I can never select a source control, ever, which end in me not being able to work connected to the main source control of our network. Everything is working fine on every other computer in our company. Only this one have problem.Did I give enough description to my problem? I really need help on this one, because working disconnected from Source Safe can give a lot of pain to our team. Can anyone give me an hand? If you need any more info, just ask.

View 2 Replies

Visual Studio :: How To Drag And Drop Fields Of Table In The Design Surface

Sep 25, 2010

I am followint the insructions of this walkthrough of VS2003

[URL]

and in a part say this 8 Find the authors node and expand it to show the fields in the authors table. 9 Using CTRL+Click, select the au_id, au_lname, au_fname, and city fields. 10 Drag these fields from Server Explorer onto the design surface Now i am using VS2008

When i try to drag and drop i can not made it is maybe because of the differences between 2003 and 2008 versions

how can do it in VS2008?

View 1 Replies

Adding A Database With Visual Studio 2005?

Nov 1, 2010

i am new to .net field , currently i am using Visual Studio 2005, Sql Server 2005(not express editions). Now while creating a website when i want to add a database through VS 2005 >App_Data>"New Item">Sql Database...i am getting an error "Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URl: http:go.microsoft.com/fwlink/?linkID=49251"...

secondly if i add a database through Sql Server how it will add in website that i created in VS 2005.

View 7 Replies

SQL Server :: Insert Large No Of Excel Sheet Rows Into Database Table?

Aug 17, 2010

I have an excel sheet that contains around 30,000 rows and 18 colmns. These no of rows and columns may increase in future. I need to read all these records from excel sheet and insert into a table in sql database. For reading the excel book I am using Oledbconnections. The possible solutions I have known as per my knowledge, to insert the data are

1. To insert one record at a time which makes 30,000 database hits. How will this affect the performance?
2. To use liked servers - bu this is not working for me.I do not have database permissions to use linked servers. So, the only option i have is the first one.

View 2 Replies

Visual Studio :: Using Server Explorer In 2005 And Database Connections?

Mar 27, 2010

I noticed that when I download a framework say like "Coolite" and open the solution, and find the Connection to the Database showed up in the Server Explorer.

In some other times, the Connection Dose not show.

I can create a connection to a Database in Server Exploere, but I need say to add it to my Web.Config directly, but not sure how. I am trying to drag-and-drop from the Server Explorer to Web.Config, it is not working.

When and how the Connections to Databases will show in Server Explorer ?

How I can create a connection to a Database using say a Wizard, and add it directly to Web.Config ?

View 3 Replies

Visual Studio :: Can't Create Database - VWD2008 SP1 Asking For Sql Server Express 2005

Mar 24, 2010

I've used the WebPI to install SQL Server Express 2008 and VWD2008 SP1. I made sure to install SQL Server first then install VWD. Whenever i use VWD now though and try to add a new SQL Server Database to my website i get the error message "Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly."

I'm a little stuck as to where to proceed with this error. I've un-installed everything web development related and re-installed and still get the same error. I was under the impression that VWD2008 SP1 required SQL Server Express 2008 and wouldn't work with SQL Server Express 2005 so can't understand why it now wants it to be installed.

View 2 Replies

Can Insert Rows To Table A Based On Values In Table B By A Single INSERT Statement

Dec 7, 2010

I am doing a data warehouse project.I have two tables tblA (id, type) and tblB(city, no_crimes, type).I want to create (insert) a number of rows based on the value of no_crimes.For Example, in tblB(Leeds, 2000, murder). SO, I need to insert 2000 rows into tblA by a single INSERT statement (not 2000 statements).

View 3 Replies

ADO.NET :: Sql Insert Into Database Visual Studio 2010

Jan 23, 2011

I am having an issue with my Windows forms application. I am trying to insert a record into a table. It says the rows affected is 1 however the row is not in the database. Here is my code:

<code>
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("AddSong",new System.Data.SqlClient.SqlConnection(Properties.Settings.Default.Database1ConnectionString));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@length", dict["Total Time"]);
cmd.Parameters.AddWithValue("@genre", dict["Genre"]);
cmd.Parameters.AddWithValue("@name", dict["Name"]);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
</code>

View 1 Replies

Visual Studio :: Use Database File From SQL Server 2005 Installed In App Data Directory?

Dec 1, 2010

I am just learning application development and my question is so I can demo a project from an Internship for a class at school. I am planning on using Visual Studio 2010 in debug mode for the presentation.

Here it goes:

I created a database utilizing SQL server 2005. I want to take the .mdf file from SQL Server and place it in the App data directory of my application. I am hoping that I do not need to rebuild any datasets that I am currently utilizing. I am utilizing several stored procedures that are in the database, these stored procedure are access utilizing my datasets.

I was able to place the file in the application but I get an exception whenever I try to utilize a stored procedure that was created in the database.

Here is the error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I verified all of my datasets utilize the following connection:

<add name="DerrickConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename="|DataDirectory|Derrick.mdf";Integrated Security=True; Connect Timeout=30;User Instance=True "
providerName="System.Data.SqlClient" />

Get methods that I built with the query builder in VS work but stored procedures do not.

View 4 Replies

Visual Studio :: Visual Source Safe Plug In Control For Visual Studio 2005 IDE

Jan 28, 2010

where to find/download visual source safe plug in or visual source safe client for visual studio 2005 IDE?

I do not want to install visual source safe 2005 server.

View 1 Replies

'Add Config Transforms' And One Click Publish Option Not Working When Upgraded From Visual Studio 2005 To Visual Studio 2010

Jul 28, 2010

I just recently upgrade my asp.net web project from visual studio 2005 to visual studio 2010. The upgrade was successful with no problems however im missing some features with this project. The One Click Publish feature(which is greyed out) in the header area of Visual Studio 2010 and the Add Config Transforms feature which is no where to be seen when you right click on web.config. When i create a new web project straight from visual studio 2010, these options work fine.

View 1 Replies

Forms Data Controls :: Read The Fields From A Database Table And Insert In The ItemTemplate Controls?

Sep 16, 2010

I want to add controls (or simply texts) to a ListView inside the ItemTemplate at run time.

The reason is that in my application I don't know in advance how many controls (or texts) I should insert.

For example I have to read the fields from a database table and insert in the ItemTemplate controls according to those fields:

<ItemTemplate>
<%# Eval("fieldname1")%> - <%# Eval("fieldname2")%> - <%# Eval("fieldname3")%> - .....

Afterwards I have to bind the ListView to the table content, so I need to preserve the <%# ... %> structure for the binding

View 3 Replies

Visual Studio :: Visual Source Safe 2005 + Visual Studio 2010,?

Feb 28, 2011

I want to use a source control in VS2010, I know my best bet is TFS, but at the moment TFS(can't afford ). As i understand TFS is the new VSS_2005(can afford)Can VSS 2005 be use as a source control for VS 2010 solutions/projects?

View 2 Replies

Visual Studio :: Unrecognized Tag Prefix Or Device Filter Error In Visual Studio 2005?

Dec 13, 2010

I am building master page in visual studio 2005 and I have placed contentplaceholder into between <head> and </head> tag of master page, but in source view of visual studio 2005, I am getting error that says "unrecognized tag prefix or device filter" how do i get rid of this error or is this bug in visual studio 2005

View 2 Replies

Visual Studio :: Start Debugging Option Is Shown In The Visual Studio 2005 IDE?

Feb 9, 2011

I run the start debugging option...it runs successfully. but still is shows start debugging option is shown in the Visual studio 2005 IDE. And one more problem is ::I applied break points in one page and run the application. but those break points are not detected....

View 1 Replies

SQL Server :: Extract Express 2005 Database And Attach It To Project?

Nov 5, 2010

i have using sql server 2005 express managment studio, i have create my database and every thing just i want to extact Database and attach it to My asp.net 3.5 Project how?

View 1 Replies

Visual Studio :: Migration From Visual Studio 2005 To Visual Studio 2010?

Jun 16, 2010

I have a site in production developed in 2005 and i am planning to migrate to Visual studio 2010. Is there an easy way to do it?

View 1 Replies

Can Run A Project In Visual Studio 2005 That Is Created In Visual Studio?

Apr 20, 2010

Can i run a project in Visual Studio 2005 that is created in Visual Studio Team Edition 2005

View 1 Replies

Difference Between Visual Studio 2005 And Visual Studio 2008

Sep 9, 2010

I have installed visual studio 2008 in my system.But my website is in Framework 2.0 and have a reports in it. i have opened my website in visual studio 2008 with the Framework built in 2.0. but many times when i debug it will give a version conflict error for reports as mentioned below.

"The type 'Microsoft.Reporting.WebForms.ReportViewer' exists in both 'c:WINDOWSassemblyGAC_MSILMicrosoft.ReportViewer.WebForms9.0.0.0__b03f5f7f11d50a3aMicrosoft.ReportViewer.WebForms.dll' and 'c:WINDOWSassemblyGAC_MSILMicrosoft.ReportViewer.WebForms8.0.0.0__b03f5f7f11d50a3aMicrosoft.ReportViewer.WebForms.dll"

View 6 Replies

Visual Studio :: Where Is Find And Replace Window

Jan 26, 2010

I have press ctrl-F or view-> find in VS2008 for a project. The find window does not

show. I can search in other project. But for this project. I cannot open the find window?

View 1 Replies

Visual Studio :: Find Text Within A Page And Replace With A Div VB

Mar 17, 2011

I have a page that contains some text within a div. How do I go about finding that text and replacing it with a div?

View 4 Replies

SQL Server :: Bulk Insert Or Insert Multiple Rows Into Database At A Time?

Aug 20, 2010

i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.

View 2 Replies

Forms Data Controls :: Insert New Blank Rows In A Gridview And Insert Them In Database Multiple At A Time?

Oct 19, 2010

I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?

View 7 Replies

Java -comparison Between Microsoft Visual Studio 2005, Visual Basic And Netbeans

Jul 3, 2010

I need to write a paper on the comparison between (Microsoft Visual studio 2005 to develop web applications using asp.net) and (visual basic and Netbeans to develop j2ee applications using java).I need suggestions for good webpages,journals or documents which can help me out here. I have to write at least 1500 words

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved