Click here to Skip to main content
15,905,504 members
Home / Discussions / C#
   

C#

 
AnswerRe: Composite Key constraint logic Pin
Guffa8-Sep-05 11:35
Guffa8-Sep-05 11:35 
QuestionTargeting a Framework version? Pin
bosfan7-Sep-05 1:40
bosfan7-Sep-05 1:40 
Questionhours minutes seconds Pin
PHDENG817-Sep-05 1:27
PHDENG817-Sep-05 1:27 
AnswerRe: hours minutes seconds Pin
John Fisher7-Sep-05 7:06
John Fisher7-Sep-05 7:06 
AnswerRe: hours minutes seconds Pin
machocr7-Sep-05 11:43
machocr7-Sep-05 11:43 
QuestionHow to install a snapin for MMC 2.0?? Pin
Socket_Layer7-Sep-05 0:34
Socket_Layer7-Sep-05 0:34 
QuestionCan FolderBrowserDialog be extended? Pin
Socket_Layer7-Sep-05 0:29
Socket_Layer7-Sep-05 0:29 
QuestionFinding Excpetion Line Number Pin
Tiger4567-Sep-05 0:27
Tiger4567-Sep-05 0:27 
AnswerRe: Finding Excpetion Line Number Pin
Mohamad Al Husseiny7-Sep-05 7:03
Mohamad Al Husseiny7-Sep-05 7:03 
QuestionCreateprocewwwithlogonw & .NET 2.0 Pin
Ruchirdhar6-Sep-05 23:25
Ruchirdhar6-Sep-05 23:25 
Questionset the input for a text box from addition class. Pin
cue_ball6-Sep-05 22:32
cue_ball6-Sep-05 22:32 
AnswerRe: set the input for a text box from addition class. Pin
Ashok Dhamija6-Sep-05 23:11
Ashok Dhamija6-Sep-05 23:11 
GeneralRe: set the input for a text box from addition class. Pin
cue_ball6-Sep-05 23:54
cue_ball6-Sep-05 23:54 
GeneralRe: set the input for a text box from addition class. Pin
Ashok Dhamija7-Sep-05 0:11
Ashok Dhamija7-Sep-05 0:11 
GeneralRe: set the input for a text box from addition class. Pin
cue_ball7-Sep-05 15:10
cue_ball7-Sep-05 15:10 
QuestionGet data from Com Port Pin
quocbao6-Sep-05 20:36
quocbao6-Sep-05 20:36 
AnswerRe: Get data from Com Port Pin
Russell Jones6-Sep-05 23:02
Russell Jones6-Sep-05 23:02 
QuestionUpdating data in Form A from form B? Pin
Johan Glysing6-Sep-05 20:17
Johan Glysing6-Sep-05 20:17 
AnswerRe: Updating data in Form A from form B? Pin
Gavin Jeffrey6-Sep-05 22:21
Gavin Jeffrey6-Sep-05 22:21 
GeneralRe: Updating data in Form A from form B? Pin
Johan Glysing6-Sep-05 22:40
Johan Glysing6-Sep-05 22:40 
GeneralRe: Updating data in Form A from form B? Pin
Ashok Dhamija6-Sep-05 23:26
Ashok Dhamija6-Sep-05 23:26 
QuestionDataReader Issue Pin
Expert Coming6-Sep-05 18:42
Expert Coming6-Sep-05 18:42 
I am using a datareader to read cells in a database. Here are a few pieces of my code, what is wrong?

using System;<br />
using System.Data;<br />
using System.Data.OleDb;<br />
<br />
		string szQUser = txtUser.Text;<br />
<br />
		//Our connection string to the DB<br />
string szConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\inetpub\\runescapestats.mdb";<br />
		//Open Connection to the database<br />
		OleDbConnection cn = new OleDbConnection(szConn);<br />
		cn.Open();<br />
  		<br />
                //The query for the database<br />
		StringBuilder szMyQuery = new StringBuilder ();<br />
		szMyQuery.Append ("SELECT User.Username, User.Password FROM [User] WHERE (((User.Username)=\'szQUser\'))");<br />
<br />
                //The building of the reader    <br />
		OleDbCommand cmd = new OleDbCommand(szMyQuery.ToString (), cn);<br />
    <br />
		OleDbDataReader rdr = cmd.ExecuteReader();<br />
  <br />
		while (rdr.Read())<br />
		{<br />
			int iUsernameOrdinal = rdr.GetOrdinal("Username");<br />
			int iPasswordOrdinal = rdr.GetOrdinal("Password");<br />
			string szUsername = rdr.GetString(iUsernameOrdinal);<br />
			string szPassword = rdr.GetString(iPasswordOrdinal);<br />
			<br />
			if(szPassword == txtPass.Text)<br />
			{<br />
			Output.Text = "Logged In";<br />
			}<br />
			else<br />
			{<br />
			Output.Text = "Failed";<br />
			}<br />
	}<br />
	}<br />
<br />
	finally<br />
	{<br />
		//Cleanup<br />
                //THIS IS WHERE THE ERROR OCCURS<br />
		<big>rdr.Close();<br />
		cn.Close();</big><br />
	}


Thanks for any feedback.
AnswerRe: DataReader Issue Pin
Gavin Jeffrey6-Sep-05 22:34
Gavin Jeffrey6-Sep-05 22:34 
AnswerRe: DataReader Issue Pin
Guffa6-Sep-05 23:49
Guffa6-Sep-05 23:49 
QuestionTry... Catch.... help Pin
sonicsqwirl6-Sep-05 18:28
sonicsqwirl6-Sep-05 18:28 

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.