Connection to databse and some fuctions

As of now u should have the database with colums like Roll no,Nme Address..like that in either sql or ms access.....

First try to connect to the database and try retreive one or two values....

The code is..
for Ms access:
using System.Data;
using System.Data.OleDb;
using System;
public class Adojet{
public static void  Main(){
String strResult ; 
String strConnect ;
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=books.mdb";
OleDbConnection con=null;
OleDbDataReader objDR =null;
String strSelect ;
strSelect = "SELECT * FROM BookList WHERE ISBN LIKE '1861003%'";
 try{
    con = new OleDbConnection(strConnect);
    con.Open();
    //OleDbCommand cmd = new OleDbCommand(strSelect, con);
    OleDbCommand cmd = con.CreateCommand();
    cmd.CommandText=strSelect;
    objDR= cmd.ExecuteReader();
    //con.Close();
    while (objDR.Read())
    {
        strResult = "  " + objDR["ISBN"] + "  " + objDR["Title"] + "  " + objDR["PublicationDate"] ;
        Console.WriteLine(strResult);
    }
    }catch (Exception objError)
    {
        Console.WriteLine(objError);
        }
        finally
        {
              objDR.Close();
        con.Close();
        }
   }
}

For Sql

using System.Data;
using System.Data.SqlClient;
using System;

public class adoSQLClient{
public static void  Main(){
    String strResult ; 
    String strConnect ;
    strConnect = "server=doit;database=northwind;uid=sa;pwd=sa";
    String strSelect ;
    strSelect = "select firstname from employees";

 try{
    SqlConnection con = new SqlConnection(strConnect);
        con.Open();
    SqlCommand cmd = new SqlCommand(strSelect, con);
    SqlDataReader objDR ;
        objDR = cmd.ExecuteReader();
    while (objDR.Read())
    {
        strResult = "  " + objDR["firstname"] ;
        Console.WriteLine(strResult);
        }
            objDR.Close();
            con.Close();
            }catch (Exception objError) { Console.WriteLine(objError);
   }
}
}


Hope it helps....

Please be free to ask any doubts...

Which kind of database did you use?