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.
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.
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
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.
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.
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 ?
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.
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).
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:
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:
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.
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?
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
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....
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?
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"
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.
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?
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