Click here to Skip to main content
15,886,963 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: .net problem Pin
Florent Geffroy9-Dec-04 0:04
Florent Geffroy9-Dec-04 0:04 
GeneralHTTPHandler to create & write files Pin
shefali_sinha3-Dec-04 11:37
shefali_sinha3-Dec-04 11:37 
GeneralWebService.NET Pin
Anonymous3-Dec-04 6:27
Anonymous3-Dec-04 6:27 
GeneralRe: WebService.NET Pin
Dave Kreskowiak3-Dec-04 7:05
mveDave Kreskowiak3-Dec-04 7:05 
GeneralAdding Custom Options Tab in Ms Word using Add-Ins Pin
! - - < NEO > - - !2-Dec-04 20:04
suss! - - < NEO > - - !2-Dec-04 20:04 
GeneralFileSystemWatcher inconsistency, HELP!!! Pin
Alex (MCP)29-Nov-04 10:46
sussAlex (MCP)29-Nov-04 10:46 
GeneralJava Access Bridge in .Net PinPopular
ganeshvijay28-Nov-04 17:05
ganeshvijay28-Nov-04 17:05 
Generalaccessing data from a table with a relationship Pin
deepamks26-Nov-04 20:38
deepamks26-Nov-04 20:38 
I am having trouble with my VB.Net code while trying to run a SELECT-query with a "WHERE" clause on an MS Access table with some relationship specified. The same code runs fine when it is run on a table that has no relationships specified on it or if there is no "WHERE" clause. The code I am using is

Dim cmd As New OleDbCommand("SELECT * FROM Language_master WHERE Language_master.Language='English'", myConn)
Dim DtRd1 As OleDbDataReader
myConn.Open()
DtRd1 = cmd.ExecuteReader()
While (DtRd1.Read())
MessageBox.Show(Convert.ToString(DtRd1.GetValue(0)) + " " + Convert.ToString(DtRd1.GetValue(1)))
End While
myConn.Close()

the MS Dvpt Environment throws up "An unhandled exception of Type 'System.Data.OleDb.OleDbException' occurred in system.data.dll" error at the cmd.ExecuteReader() line.
The same code runs fine when I use another table "LibUser_Master". The only difference betwen the tables is that "Language_master" has some relationships specified on it, whereas "LibUser_Master" has none.

And the same code runs fine on both tables when the select query has no "WHERE" clause or if the "WHERE" clause is for a number field.

Can anybody help me solve this problem...

GeneralRe: accessing data from a table with a relationship Pin
hermitbluedog10-Dec-04 22:29
hermitbluedog10-Dec-04 22:29 
GeneralThreads and Appdomains Pin
F.D.I26-Nov-04 3:45
F.D.I26-Nov-04 3:45 
GeneralExtracting a digital certificate from a file. Pin
sillypuppy26-Nov-04 0:01
sillypuppy26-Nov-04 0:01 
General.net datagrid column editing Pin
sxsunda25-Nov-04 19:06
susssxsunda25-Nov-04 19:06 
GeneralRequested Registry Access is Not Allowed Pin
KreativeKai24-Nov-04 9:07
professionalKreativeKai24-Nov-04 9:07 
GeneralRe: Requested Registry Access is Not Allowed Pin
The Man from U.N.C.L.E.2-Dec-04 1:46
The Man from U.N.C.L.E.2-Dec-04 1:46 
GeneralRe: Requested Registry Access is Not Allowed Pin
KreativeKai2-Dec-04 2:40
professionalKreativeKai2-Dec-04 2:40 
GeneralRe: Requested Registry Access is Not Allowed Pin
The Man from U.N.C.L.E.2-Dec-04 3:13
The Man from U.N.C.L.E.2-Dec-04 3:13 
GeneralRe: Requested Registry Access is Not Allowed Pin
The Man from U.N.C.L.E.2-Dec-04 22:37
The Man from U.N.C.L.E.2-Dec-04 22:37 
GeneralRe: Requested Registry Access is Not Allowed Pin
The Man from U.N.C.L.E.2-Dec-04 23:47
The Man from U.N.C.L.E.2-Dec-04 23:47 
GeneralRe: Requested Registry Access is Not Allowed Pin
KreativeKai9-Dec-04 8:09
professionalKreativeKai9-Dec-04 8:09 
GeneralOleDbDataReader + Excel Pin
dvd0024-Nov-04 4:49
dvd0024-Nov-04 4:49 
QuestionGlobal CBT in .NET? Pin
Hadi Fakhreddine23-Nov-04 22:57
Hadi Fakhreddine23-Nov-04 22:57 
GeneralChanging URI's dynamically for web service clients Pin
burrifro7923-Nov-04 15:36
burrifro7923-Nov-04 15:36 
GeneralLotus NOtes Pin
rogerruiz23-Nov-04 10:01
rogerruiz23-Nov-04 10:01 
GeneralRe: Lotus NOtes Pin
Kevin McFarlane26-Nov-04 5:07
Kevin McFarlane26-Nov-04 5:07 
GeneralRe: Lotus NOtes Pin
rogerruiz26-Nov-04 7:39
rogerruiz26-Nov-04 7:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.