C#

allan.gagnon wrote:

However I am getting this error message when I build my project:

Error 1 Property or indexer 'System.Data.Common.DbDataReader.this[string]' cannot be assigned to -- it is read only C:\Documents and Settings\admin\My Documents\Visual Studio 2005\Projects\GasCabinetSimulator\GasCabinetSimulator\ClassLogin.cs 46 37 GasCabinetSimulator

This line is the error: rdr["IsLoggedIn"] = true;

UPDATE tblLogin SET IsLoggedIn = 1 WHERE UserID = ????

SELECT COUNT(*) FROM tblLogin WHERE UserID = @userID AND Password = @password

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT COUNT(*) FROM tblLogin "+
                  "WHERE UserID = @userID AND Password = @password";
cmd.Connection = cn;
cmd.Parameters.Add("@userId", theUserId);
cmd.Parameters.Add("@password", thePassword);
int matches = (int)cmd.ExecuteScalar();
if (matches == 0)
{
    // No match - user is not logged in
}
else
{
   // A match has been found - user can be logged in.
}

<br />
public class Blah:IDisposable<br />
{<br />
    public void Dispose()<br />
    {<br />
        //Dispose Here<br />
    }<br />
}<br />

<br />
myBlahObject.Dispose();<br />

<br />
public class Blah:IDisposable<br />
{<br />
    void IDisposable.Dispose()<br />
    {<br />
        //Dispose Here<br />
    }<br />
}<br />

<br />
myBlahObject.Dispose();<br />

<br />
(myBlahObject as IDisposable).Dispose();<br />

<br />
public abstract class myAbstractClass:IDisposable<br />
{<br />
    public abstract void Blah();<br />
    //some methods here<br />
    void IDisposable.Dispose()<br />
    {<br />
    }<br />
}<br />

<br />
public class myImplementedClass:myAbstractClass<br />
{<br />
    private ClassThatNeedsToBeCleanedUpOnDispose foo;<br />
    public override void Blah()<br />
    {<br />
         // do some blah's here<br />
    }<br />
    public override void Dispose() //this will give you a Compiler Error<br />
    {<br />
         // clean up you foo here<br />
    }<br />
}<br />

<br />
public abstract class MyAbstractClass:IDisposable<br />
{<br />
    public abstract void Blah();<br />
    void IDisposable.Dispose()<br />
    {<br />
        Dispose(true);<br />
    }<br />
    protected virtual void Dispose(bool Disposing)<br />
    {<br />
        // clean up here..<br />
    }<br />
}<br />

<br />
public class myImplementedClass:myAbstractClass<br />
{<br />
    private ClassThatNeedsToBeCleanedUpOnDispose foo;<br />
    public override void Blah()<br />
    {<br />
         // do some blah's here<br />
    }<br />
    protected override void Dispose(bool Disposing)<br />
    {<br />
        if (Disposing)<br />
        {<br />
            // clean up you foo here<br />
            base.Dispose(Disposing);<br />
        }<br />
    }<br />
}<br />
<br />

<br />
myAbstractClass blah = new derivedfromthederivedClassFrommyAbstractClass();<br />
(blah as IDisposable).Dispose();<br />

<br />
ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();<br />
Workbooks oBooks = excel.Workbooks;<br />
object nulo = System.Reflection.Missing.Value;<br />
<br />
//here u have open method, there's many parameteres, but they can be null.<br />
oBooks.Open("C:\\file.xls",nulo,false,nulo,nulo,nulo,nulo,nulo,nulo,true,nulo,nulo,nulo,nulo,nulo);	<br />
<br />
//A _workbook where the sheet lives<br />
_Workbook b = oBooks.get_Item(1);<br />