- Strength to Increase Rep
- +3
- Strength to Decrease Rep
- -0
- Upvotes Received
- 3
- Posts with Upvotes
- 2
- Upvoting Members
- 3
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
 | Think it is an ASP.NET application. I made some changes, marked with XXX. On my system it works. Maybe the changes help you to get your program to work. Databaseprogramming is a wide area. [code] Imports System Imports System.data Imports System.data.sqlclient 'XXX used a standard dataset since I do not … |
 | |
| | Could it be that the file does not only contain PL/SQL? Comments in PL/SQL are [ICODE]/* comment comment */[/ICODE] or [ICODE]-- comment[/ICODE] Calling PL/SQL from VB .NET may basically be performed by executing the PL/SQL text like: [ICODE] Dim sSQL As String Try 'create and use a function sSQL = … |
| | You could use a SQL statement with a GROUP BY ... HAVING clause. Group the records by the columns that are relevant for "equality". Use HAVING COUNT(*) > 1 to return only those groups that have more than one member = more than one row with the same values in … |
| | I did not analyze the algorithm. Concerning the types that are used: If a program needs to perform many append operations on a string, using a stringbuilder object may be faster than using a string object. See [url]http://msdn.microsoft.com/en-us/library/system.text.stringbuilder(VS.80).aspx[/url] |
| | The following script function "btnRunScript_onclick" works as long as it does not access the HTML control "txtMessage". If it does, "Page Error" is shown in the statusbar of Internet Explorer (6). Knows anybody why? Thank you. [code] <%@ Page Language="vb" AutoEventWireup="false" Codebehind="GuessingGame.aspx.vb" Inherits="Ch07Le04.GuessingGame"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> … |
| | one problem is the comma before the WHERE. Replace [code] & "CS = @NewCS, " _ & "WHERE fldUser = @OldfldUser " _ [/code] by [code] & "CS = @NewCS " _ & "WHERE fldUser = @OldfldUser " _ [/code] If more syntax errors please post back |
| | Did you check rows.count before and after adding the row? [code] console.Writeline( "Rows.Count {0}", DsMembers.Members.Rows.Count ) [/code] Do you assign the result of the find to a datarow? [code] Dim rowFound As DataRow = DsMembers.Members.FindByTDL(scannedMember.TDL) [/code] |
| | The following code replaces the CR+LF that separates the lines in a multiline textbox by a text that will hopefully never be entered by any user. I tested this with german culture settings. [code] Dim sLine As String sLine = Replace(TextBox1.Text, vbCr & vbLf, ":AxAxA:") Dim writer As New StreamWriter("temp.txt", … |
| | Maybe its possible but I never read code that used a stringreader to feed the DataRowCollections.Add Method. Typically a DataRow generated by the tables NewRow method or an array of objects is used as parameter. If you read the datafields from a textfile and have other datatypes than "string" in … |
| | After instantiation of the command builder: do the Commandtext properties of DA.UpdateCommand, DA.InsertCommand and DA.DeleteCommand contain the required SQL commands? P.S.: DS.GetChanges produces a copy that contains the changed rows. The code does not use this subset but the original dataset. But unless AcceptChanges is called, it should also work … |
| | Re: dim x as timer Maybe this is useful: [url]http://www.astahost.com/info.php/c-net-web-timer-control-tutorial_t6605.html[/url]  |
| | There seems to be some logic in the access DB engine to recognize that 31 cannot be the number of a month. But not enough to recognize that Feb 31th is very unusual. maybe VBA documentation is helpful: [url]http://msdn.microsoft.com/en-us/library/aa212163(office.11).aspx[/url] [url]http://msdn.microsoft.com/en-us/library/aa172286(office.11).aspx[/url] When using SQL and # # to write dates to … |
| | My name is Joachim, I live in Stuttgart, a town in a basin sourrounded by hills in the south of germany. I was born 1958 and work as a software developer since 1990. As a hobby pianist I am lucky to play in local salsa combos. I have a very …  |
| | Do you want to 1) step throgh all rows of Table1, and show the row when there is no row with the same path AND filename in Table 2 2) and then do the same vice versa? If yes, and DBMS is MS SQL Server or Oracle I would use … |