User Profile

khalid Ahmed · Jul 12 '08, 07:55 AM

kenobewan
WOW!!! You are wonderful. Thanks a million...

khalid Ahmed · Jul 9 '08, 07:47 PM

yes, fields names are uname and pw,I tried to execute the same query ( without using parameters ) and it returns results.
like this:
string query_stmt = @"SELECT * FROM logsdb.userslog WHERE uname= '" + TextBoxusr.Text + "'"+ "& pw='"+TextBoxpw .Text+"'";
OdbcCommand odbc_command = new OdbcCommand(que ry_stmt, odbc_conn);

I know that this is a bad query cuz it invites hackers...

khalid Ahmed · Aug 31 '07, 07:36 AM

I have written a second sql-statement to get the last auto-number field entered
after the insert method like the following method

Code:

      private int LastID()
        {
            //Find highest ID in the  table
            OleDbCommand comm = new OleDbCommand("SELECT MAX(ID) FROM Student",myconn);
            return (int)comm.ExecuteScalar();
        }

but I think...

khalid Ahmed · Aug 30 '07, 04:37 PM

thanks Plater Can you show me how I can do it....

khalid Ahmed · Aug 23 '07, 01:38 PM

yeah that's what I want to do. Can you show me how I can do it....

khalid Ahmed · Aug 23 '07, 12:35 PM

string myIntialString;
string mystring=myInti alString.Substr ing(0,30);

I hope this help you....

User Profile

Profile Sidebar

access denied message is not shown!!

how to create custom membership provider with xml

Leave a comment:

Leave a comment:

OdbcDataReader.Read() returns false

Leave a comment:

Leave a comment:

Selecting from the Table by specifying the row number

Leave a comment:

Leave a comment:

Appending string into richtextbox and keeping the previous style