Prof. Ashay Dharwadker's Courses (2):

Course	Semester	Grade	Add New Course
Information Systems	Fall 2003	View	Update Course
Database Systems	Fall 2003	View	Update Course

Projects (2)

Seminars (2)

• Update
• Insert
• Where
• Alter

• Perfect Numbers.
• Amicable Numbers.
• Goldbach conjecture.
• Mersenne Primes.
• How to swap two values without using temporary variable. Algorithm: Given (a,b). Put a = a + b. Put b = a - b. Put a = a - b. Hence done.

Research Notes (2)

1: START VC++ > FILE > NEW> MFC APPWIZARD(exe)
ENTER sanjayshop(DATABASENAME) > OK
DIALOG BASED > NEXT \\UNCHECK ACTIVEX AND ABOUT BOX.(WE DON'T NEED THAT)
FINISH.
The wizard creates a form. The new form has two buttons OK and CANCEL. Add the lines which is given in the step 1 of the table. These lines make access to the ADO Library. Close and Save it.

2: Add two functions which is given in step 2 of table. close and save it this file. Add list box onto form and declare its variable using class wizard. Change the following things while add it as member variable.
VARIABLE NAME = m_lbpart.
CATEGORY = Control.
VARIABLE TYPE = CListBox.

3: All you have left to do is write the code that will run a Query and populate the list box. DOUBLE CLICK on button OK and that will open a dialog box ask you , what you want to name the function for its CLICK event.Left name as OnOK()the default pone.
PRESS OK.
Add the code which is given in the table. After the variable are declared , a connection string is assigned to bConn and a query string is assigned to vQuery. An instance of a recordset object is created , and then its OPEN method connects to the database , runs query , and stores its results. After that loops is run that moves through each row in the result set. In the loop the description column is copied to a variable and added to the list box. BY , default the list box will automatically sort the strings as they are added.

NOW YOU ARE READY TO TRY IT OUT ! SAVE AND COMPILE.

1: //File view > header file folder > StdAfx.h
#include
#import"c:\program files\common files\system\ado\msado15.dll"no_namespace rename ("EOF","adoEOF")
 
2: // Add two functions for initializing Ado.
class view > CsanjayshopApp > InitInstance
BOOL CsanjayshopApp::InitInstance()
{ AfxOleInit();
AfxEnableControlContainer();
(several more lines already exist there) }
 
3: After adding function for button write the following code under that.
void CsanjayshopDlg::OnOK()
{ //CDialog::OnOK();
_RecordsetPtr pRecordSet;
_variant_t vRecordSetField;
Cstring sRecordSetField;
_bstr_t bConn("Provider=SQLOLEDB.1" Persist Security Info=True; User ID=root; password=;Initial Catalog=sanjayshop;Data Source=local host");
_variant_t vQuery(" SELECT * from PART ;");
pRecordSet.CreateInstance(__uuidof(Recordset));
pRecordSet->Open(vQuery,bConn,adOpenDynamic,adLockOptimistic,adCmdText);
while(!pRecordSet->GetadoEOF())
{ vRecordSetField = pRecordSet->GetCollect(L"Description");
sRecordSetField = vRecordSetField.bstrVAL;
m_lbPart.AddString(sRecordSetField);
pRecordSet->MoveNext();
}
}

1. Account creation: This creates a new account and password for a user to access Data Base.
   SYNTAX ….
   GRANT USAGE on *.* TO username@localhost identified by password;
   Eg. Grant usage on *.* to sanjay@localhost identified by sanjay;
2. Privilege granting: This action permits the DBA to grant certain privileges to certain accounts.
   SYNYAX …
   GRANT queries ON TABLENAME to USERNAME;
   Eg. Grant SELECT, DELETE, UPDATE on sanjayshop to Ankit;
   (By this Ankit can only update, delete, select in my database).
3. Privileges revocation: This action permits DBA to revoke (cancel) certain privileges that were previously given to certain accounts.
   SYNTAX …
   REVOKE queries ON TABLENAME to USERNAME;
   Eg. REVOKE DELETE, UPDATE on sanjayshop to Ankit;
   (By this now Ankit can only select in my database.because I cancelled his power for delete and update).
   Note : Here queries meant that which function do you want to allow to the user to access Database.