DATABASE SOFTWARE

 

Software Development (WEB)DU

Tools:

  • HTML 3.0, CSS 3.0, Java Script
  • Ajax, JQuarryiit
  • MySQL Database

ONLINE TRADING SYSTEM

12

 

 

 

 

34

5

 

6

 

 

7

 

 

 

 

 

 

Medicine Database Software

8

9

 

 

 

 

 

10

11

 

Advertisements

10 thoughts on “DATABASE SOFTWARE

  1. Abdullah Al Kamal says:

    INSERTING TEXT BOX

    Entitled Document

    function getSubmit()
    {
    var LastName;
    var Firstn = names.value ;

    var cn = new ActiveXObject(“ADODB.Connection”);
    //here you must use forward slash to point strait
    var strConn = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb”;
    var rs = new ActiveXObject(“ADODB.Recordset”);
    //var SQL = “INSERT INTO Customers(FirstName, Surname)”
    //+ ” VALUES ( ‘”+ names.value +”‘, ‘” + surname.value +”‘)”;
    var SQL = “select Surname, DOB from Customers where FirstName = ‘” + Firstn + “‘”;

    cn.Open(strConn);
    rs.Open(SQL, cn);
    surname.value = rs(0);
    DOB.value = rs(1);
    //alert(rs(0));
    rs.Close();
    cn.Close();

    }

  2. Abdullah Al Kamal says:

    Linking Access Database – 02

    Entitled Document

    function getSubmit()
    {
    var Firstn = names.value ;
    var cn = new ActiveXObject(“ADODB.Connection”);
    var strConn = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb”;
    var rs = new ActiveXObject(“ADODB.Recordset”);
    var SQL = “select Surname, DOB from Customers where FirstName = ‘” + Firstn + “‘”;
    cn.Open(strConn);
    rs.Open(SQL, cn);
    surname.value = rs(1);
    DOB.value = rs(2);
    rs.Close();
    cn.Close();
    }

  3. Abdullah Al Kamal says:

    Inserting Checkbox

    Select STATE:
    STATE

    MONDAY

    TUESDAY

    WEDNESDAY

    THURSDAY

    FRIDAY

    SATURDAY

    SUNDAY

    To submit the query, press:
    .

    Accessing Data through HTML and Access

    Looking at Excel Web Components to create a DAP

  4. Abdullah Al Kamal says:

    Entitled Document

    function getSubmit()
    {
    var LastName;
    var Firstn = names.value ;

    var cn = new ActiveXObject(“ADODB.Connection”);
    var strConn = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source = ClientDB.mdb;Persist Security Info=False”;
    cn.Open(strConn);
    var rs = new ActiveXObject(“ADODB.Recordset”);
    var SQL = “select Surname, DOB from Customers where FirstName = ‘” + Firstn + “‘”;
    rs.Open(SQL, cn);
    surname.value = rs(0);
    DOB.value = rs(1);
    rs.Close();
    cn.Close();
    }

    name
    Surname
    DOB

  5. Abdullah Al Kamal says:

    add namespace

    using System.Data.OleDb;

    OleDbConnection conn = new OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;data source=” + Server.MapPath(“App_data\\tikkajack.mdb”));
    if (conn.State == ConnectionState.Open)
    conn.Close();
    conn.Open();
    OleDbCommand comm = new OleDbCommand();
    comm.CommandType = CommandType.Text;
    comm.Connection = conn;
    comm.CommandText = “insert into AdvertType (ObjectType) values (@Type)”;
    comm.Parameters.Add(new OleDbParameter(“@Type”, txtHead.Text.Trim()));
    comm.ExecuteNonQuery();
    comm.Cancel();
    comm.Dispose();

    In this example data is being inserted in table AdvertType , column name is ObjectType

    and database name is tikkajack.mdb

    so you can see this example and change to according to your requirement.

  6. Cyber Technology Bangladesh says:

    Our Company Cyber Technology Bangladesh have the following facilities. We have network security facilities to provide our customer network security. We provide ccna training to student and help them to get ccna certification through our ccna course though ccnp certification is more important. ccnp helps student to complete cisco certification on professional network works. mcse is a vital part beside networking. We got maximum result in ccna exam in our last 2016 ccna batch. We should say cisco ccna or ccna cisco is important for cisco courses as well as network engineer ccna job. We trying to minimize ccna certification cost those who taking ccna security couse also. Our company is best in network inspection and services. We are the company ccna bangladesh who have certified ccie trainer from cisco ccie international vendor. We are helping Bangladesh to Learn.

Please Login to Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s