Click here to Skip to main content
15,918,889 members
Home / Discussions / C#
   

C#

 
GeneralNameValueCollection Pin
Peter Kiss26-Feb-03 0:40
Peter Kiss26-Feb-03 0:40 
GeneralRe: NameValueCollection ???? Pin
Peter Kiss26-Feb-03 0:42
Peter Kiss26-Feb-03 0:42 
GeneralBeginner Q - long strings Pin
Alexandru Savescu25-Feb-03 22:18
Alexandru Savescu25-Feb-03 22:18 
GeneralRe: Beginner Q - long strings Pin
leppie26-Feb-03 0:11
leppie26-Feb-03 0:11 
GeneralRe: Beginner Q - long strings Pin
Alexandru Savescu26-Feb-03 1:16
Alexandru Savescu26-Feb-03 1:16 
GeneralRe: Beginner Q - long strings Pin
Alexandru Savescu26-Feb-03 20:38
Alexandru Savescu26-Feb-03 20:38 
GeneralRe: Beginner Q - long strings Pin
leppie27-Feb-03 6:26
leppie27-Feb-03 6:26 
GeneralHRESULT in C# Pin
Nicholas Naddaf25-Feb-03 15:26
Nicholas Naddaf25-Feb-03 15:26 
GeneralRe: HRESULT in C# Pin
Stephane Rodriguez.25-Feb-03 21:02
Stephane Rodriguez.25-Feb-03 21:02 
GeneralRe: HRESULT in C# Pin
Nicholas Naddaf26-Feb-03 4:08
Nicholas Naddaf26-Feb-03 4:08 
GeneralRe: HRESULT in C# Pin
Stephane Rodriguez.26-Feb-03 4:26
Stephane Rodriguez.26-Feb-03 4:26 
Generalbeginner question in C# Pin
nnnnnnnnnn25-Feb-03 14:38
nnnnnnnnnn25-Feb-03 14:38 
GeneralRe: beginner question in C# Pin
Steven Behnke25-Feb-03 19:33
Steven Behnke25-Feb-03 19:33 
GeneralRe: beginner question in C# Pin
Ryan Cromwell26-Feb-03 3:11
Ryan Cromwell26-Feb-03 3:11 
GeneralRTF Scrolling Pin
Steven Behnke25-Feb-03 12:29
Steven Behnke25-Feb-03 12:29 
QuestionManaged Directx - partially useless or not? Pin
Filip Strugar25-Feb-03 11:28
Filip Strugar25-Feb-03 11:28 
AnswerRe: Managed Directx - partially useless or not? Pin
Anonymous25-Feb-03 18:20
Anonymous25-Feb-03 18:20 
GeneralOleDbConnection Pin
Jassim Rahma25-Feb-03 9:53
Jassim Rahma25-Feb-03 9:53 
GeneralRe: OleDbConnection Pin
Chris Austin25-Feb-03 13:48
Chris Austin25-Feb-03 13:48 
GeneralRe: OleDbConnection Pin
Jassim Rahma27-Feb-03 7:48
Jassim Rahma27-Feb-03 7:48 
GeneralRe: OleDbConnection Pin
Jassim Rahma27-Feb-03 11:52
Jassim Rahma27-Feb-03 11:52 
I'm using the same code in all my other applications and the strange thing that the same application which is giving an error is working on my laptop with no problems:

strSQL = "SELECT * FROM account WHERE department = 'CRM' AND account_pin = '234567'";

// open database;
strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\temp\\Apps\\CRM Queries\\accounts.mdb;Jet OLEDB:Database Password=mem";

OleDbConnection dbConnection = new OleDbConnection(strConnection);

dbConnection.Open();

OleDbDataReader dbReader;

OleDbCommand dbCommand = new OleDbCommand(strSQL, dbConnection);

dbReader = dbCommand.ExecuteReader();

try
{
update_log("validating department and PIN");

while (dbReader.Read())
{
account_department_name = dbReader["department"].ToString();
account_department_pin = dbReader["account_pin"].ToString();
}

dbReader.Close();

}

catch(Exception exp)
{
MessageBox.Show(exp.Message, "Error");
}

finally
{
dbConnection.Close();
}

Many Thanks,
Jassim Rahma

Jassim Rahma
QuestionDate/Time change on CDO message? Pin
PianoJazz25-Feb-03 8:30
PianoJazz25-Feb-03 8:30 
GeneralA Windows Service question Pin
Radoslav Bielik25-Feb-03 7:55
Radoslav Bielik25-Feb-03 7:55 
Generalmultiple data access component Pin
..Hubert..25-Feb-03 7:51
..Hubert..25-Feb-03 7:51 
GeneralRe: multiple data access component Pin
Chris Austin25-Feb-03 13:50
Chris Austin25-Feb-03 13:50 

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.