Posts
 
Reputation
Joined
Last Seen
Ranked #2K
Strength to Increase Rep
+3
Strength to Decrease Rep
-0
100% Quality Score
Upvotes Received
3
Posts with Upvotes
2
Upvoting Members
3
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
2 Commented Posts
0 Endorsements
Ranked #2K
~14.1K People Reached
Favorite Tags
Member Avatar for preethi_ga

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 …

Member Avatar for olobo
0
7K
Member Avatar for tuse

Maybe it is because there is no report (=class) "CrystalReport1" in your project.

Member Avatar for tuse
0
106
Member Avatar for EJK972

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 = …

Member Avatar for dadelsen
0
806
Member Avatar for realone

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 …

Member Avatar for dadelsen
0
193
Member Avatar for allopiloping

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]

Member Avatar for dadelsen
0
153
Member Avatar for dadelsen

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"> …

Member Avatar for dadelsen
0
399
Member Avatar for witternb

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

Member Avatar for witternb
0
144
Member Avatar for herbally

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]

Member Avatar for dadelsen
0
170
Member Avatar for JeffN00B

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", …

Member Avatar for dadelsen
0
228
Member Avatar for cellus205

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 …

Member Avatar for dadelsen
0
4K
Member Avatar for roblespaulo

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 …

Member Avatar for dadelsen
0
119
Member Avatar for ToHa57

Maybe this is useful: [url]http://www.astahost.com/info.php/c-net-web-timer-control-tutorial_t6605.html[/url]

Member Avatar for ericstenson
0
275
Member Avatar for richo.mw

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 …

Member Avatar for richo.mw
0
151
Member Avatar for dadelsen

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 …

Member Avatar for jasimp
0
40
Member Avatar for cellus205

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 …

Member Avatar for cellus205
0
135