I often need to copy complete transactions from the production system into the test system. The database structure is the same. Some of the fields in a table might have NULL values.
My objective is to write a program that will fetch records associated with a particular transaction and copy them over to the test system. The database is Oracle 9i (production system) and Oracle 10G (on the test system).
[Code]...
If I give a specific member id, it should fetch all records in MEMBER_MASTER and MEMBER_ADDRESS tables and insert these records in the test system. What is the best way of developing this app? Currently I use sqlloader to do this.
I want to build a front-end and I am thinking I could learn some VB .NET along the way.
I have a copying error with my program. I am trying to copy the internet cache folder, and the error states that some files cannont be copied (read only maybe?) How can i make it copy, or just skip the uncopyable files?
I have a WinForm 'frmUploadStatus' which has a datagridview filled with 1000 records & 20 columns.And also I hosted in hosting server ms sql server 2005 database which has tables one of its table 'Status' (it has 10 columns).Now I want to upload from WinForm 'frmUploadStatus' to ms sql db.
If I change only the connectionstring in my program for uploading the records, it takes more time for uploading.
i have 3 user roles "ALGEMEEN,OZIS,VERPLEEGKUNDIGE".And I want them added to the database.But when I use the code below it only adds the userrole "ALGEMEEN" and not the other 2.
Dim cmdCheckLidVan As New SqlCommand("SELECT COUNT(*) FROM [Lid van] WHERE [Gebruikers-ID] = @ID AND [Rol-ID] = @RolID", connection) Dim strRolArrCount As Integer Dim strRolArr() As String
My code below will save records to my database as long as all the parameter have values. One of the parameter is @MI (middle initial), however, there are times that student have no middle initial so when I click my button I get error. I want to still save the record even if one of the parameter value is missing.
I have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
I don't really know how to code but am pretty good at tweaking. I'm trying to set up a script that I can run to delete a single file, multiple files, a folder or multiple folders on a list of servers.I was thinking that the script could read the files to be deleted from a .txt file and apply the deletion to a list of servers in another .txt file.Example:
FilesToBeDeleted.txt: \(insert_server_name_from_list)c$Program FilesBINexample_file.rpt or
I am trying to copy the records from my WO table and trying to change the scheduled_date like. If I have already entered a work oder and scheduled it on 26-SEO-2011 when the next month comes it should give me message do you want to crate work oders when i press yes it should copy the those records which has current date and change it month e.g in our example 26-SEP-2011 to 26-OCT-2011 and save it but i am unable to perform this task and similer procedure will be for other saved records when their scheduled date come it should copy it and change the month and save.
This piece of code is on form load event Private Sub QueryWorkorder() Dim con As New OleDbConnection("Provider=MSDAORA.1;Data Source=(DESCRIPTION=" _ + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=196.111.116.205)(PORT=1521)))" _ + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Dummy)));" _ + "User Id=PCHR;Password=PCHR;") [Code] .....
And I am calling it on form load event. And I am changing the date from control panel and then running the project it didn't populate the message do you want to create record what should I do?
Just copied a saved VB 2005 project to a new machin which has VB 2005. When I build or rebuild this project I get one error and 14 Warnings...Warnings and error are:Warning 1 The referenced component 'LCC11' could not be found.Warning 2 The referenced component 'Microsoft.Office.Core' could not be found. Warning 3 The referenced component 'Microsoft.Office.Interop.Word' could not be found.
I can retrieve records from my Database fine, but I'm having trouble updating records. I am getting a syntax error on [code] I get this error when I change the Last Name (Row 0, Column 1). [code]
I'm making an installer and I need to copy a file into C:WindowsSystem32. It's a dll file.When I try to do this, app throws an exception saying that the access is denied. Before doing this, I copy a lot of files into another directories and have no problem at all. The exception is thrown only when I try to write into that folder.
I am trying to copy a table in a database into another database on another connection in VB.NET, using OleDb. If they were on the same connection I would just use SELECT INTO, but they are not. I have two different OleDbConnection and cannot see an easy way to do this.
Right now I am attempting to just copy the database into a DataTable using an OleDbDataAdapter, and then loop through the DataTable and insert every record into the target database one at a time. This obviously takes a ton of time for the large DB I could potentially be dealing with, and I have to deal with escaping strings, null values, etc.
edit - just to make this more clear: I have two OleDbConnection objects, one is linked directly to a local .mdb file on my computer (JET). The other is linked to a database on our servers (SQLOLEDB). I am wanting to do this:
"SELECT * FROM fromDB INTO toDB"
But I can't because fromDB and toDB are on different connections, and the OleDbCommand object is only attached to one. The only way I can see how to do this is to connect to fromDB, copy it into a DataTable, connect to toDB, and copy all of the data in the DataTable row by row into toDB. I was wondering if there is an easier way to do this.
I'm trying to copy files to the CD Drive using My.Computer.FileSystem.CopyFile. I use the FolderBrowserDialog for my destination and add the filename at the end. When I try this on the Hard Drive and also a flash drive, it works just fine, but when I try this on a CD Drive, I get the following message: Could not find part of the path 'E:'. Hw to copy movie files to CD Drive.
Error Message: "This server version is not supported. Only servers up to Microsoft SQL 2005 are supported VB.NET" I am using VB.NET 2008 and attempting to connect to SQL Server 2008 with XP as the operating system. I have service pack 1 installed in Visual Studio but this error message presists. The articles I have read on this error said to install sp1 as a solution but I have done that and the error persists. FYI, the error does not occur when I am using code to connect to SQL Server but when I attempt to connect using one of the designer wizards this error occure.
I have a DatagridView which displays the following: IDNo, SubjectName, FirstName,MI, LastName, YearLevel, Address, Gender. I want to save whatever is displayed in it to my database...My code below does not save the SubjectName all the rest are saved.
Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegister.Click Try
I have ALWAYS used the SQLDataSource to update my records in my SQL Server 2005 database, so i am not really sure how this would be done in normal code. I am using VB.NET but if you are a C# developer and want to show me some code that is more than welcome as well.
I am using ASP.NET 3.5.My user will see a page with 5 Text boxes with their contact details in. Those details I will get from a SQL Server DB and when they go and change the text in the text box and click submit, it must then save the changes.
This is very easy with the SQLDataSource but how can i code this myself?
I am trying to learn XML, for which i have created a simple Employees Program. I want to save the records of the employee in an xml file, so far i have the following code:
vb Private Sub SaveRecord(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim XMLSettings As New XmlWriterSettings XMLSettings.Indent = True XMLSettings.IndentChars = " " XMLSettings.NewLineOnAttributes = True [Code] .....
This is only working for a single record, How should I insert more employees records within this xml file?
i have a problem in displaying records between two dates...i have two datetimepickers to choose date from datebase...start date and end date..when i choose start date 1/1/2009 and end date 1/12/2009 then all the records between 1/1/2009 and 1/11/2009....the records of date 1/12/2009si not shown...date format is month/day/year.....i have posted my code below..
Dim rpt As New CrystalReport8() 'The report you created. Dim cn As SqlConnection Dim cmd As New SqlCommand()
I need to create an HTML page to be sent as E-mail , the HTML page should contain an Table which contains the records from the database. The records to be selected from the database are bound by the conditions given by the user.So i wanted to ask what is the best way to create the HTML page, should i create them dynamically or Can we link the HTML page to the DB , or anything else.
I have the following records in DataGrid .see in Pic. On button click, I am scanning thru all the records. Just tell me that dataGrid RowCount is from: For j = 0 To DataGridView1.RowCount - 2 Or For j = 0 To DataGridView1.RowCount - 1 Private Sub Button11_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button11.Click [Code] ......
I am making an inventory program in which there's an ItemMaster and Sales Form. Currently there are 15000 records of items(increasing daily). I want to display all the items in the sales form so that the user can select an item from the list for billing, and also in the itemmaster so that if the user wants to edit any item then he can select it from the list.
I can make a common list form for both sales and master, but i have to load the data from the database into the list every time the list is displayed(which is taking lot of time), so is there an better way to do it.
How do I display the concatenated records in my combobox? I have the following codes
Private Sub frmAssignSubjects_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If cnn.State = ConnectionState.Closed Then cnn.Open() If rdoHS.Checked = True Then
[code].....
What should I put in the DisplayMember and ValueMember? If I will not concatenation, I just use "LastName" and "IDNO" in my DisplayMember and ValueMember respectively then records get to display in my combo.
The problem is when i insert a first key(dix) records its coying fine. But when i insert the second set of records in is sorting int he table. but when i looked at the dataset by using gridview the recods appears in a right order. but the updated table is somewat sorted order. Is there any possible way to insert the records in the same order in the dataset..
I managed to displayed records from two tables in one datagridview and the first column being a combobox. Now, I would like to get those records displayed and save it to another table. this what I did.
For i As Integer = 0 To dtgLoad.Rows.Count - 1 Using command As New SqlCommand("INSERT INTO tblteachersload (Teacher ,SubjectName) " & _ "VALUES (@Teacher, @Subject)", cnn) With command.Parameters .AddWithValue("@Teacher", Me.dtgLoad("Column1", 0).Value) [Code] ......
I would like to loop through the records of the datagridview and then save the same to a table.
i'm making a utility in which i'm loading 100,000 records again and again, problem is that it takes much time to load records in datagridview every time.
i've used data set and data reader both but same result. if i use paging then there's will be a problem of search a record on keyup event.
I am building a custom search control in VB.NET and came across a problem getting distinct records into my datagridview. I want to bring exact matches back first so I run 2 of the same query on the same table with a slight difference:
select ... like "code%" select ... like "%code%"
I have a datatable that I need to get distinct records from; I am append records from a sql query to the end of the datatable so I cannot use a union in sql to return the dataset (I want to preserve the order which the rows are added) I have been using this which is working fine for 2 fields:
But when I have 3 (or more) fields I get duplicates ONLY for the row I am querying:
dt2 = dt.DefaultView.ToTable(True, "Code", "Name", "Initial") select ... like "initial%" select ... like "%intial%"
I am clearing the datagridview.source before rebuilding this. Is there a way to get the distinct rows this way or should I just build something myself to remove the duplicates from the second datatable before appending them to the new table?
