DATABASE SOFTWARE

kkkkSoftware 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

 

  1. Accessing Data through HTML and Access

    Looking at Excel Web Components to create a DAP

  2. function test(name){
    alert(‘hello ‘ + name);
    }

    function test(name){
    alert(‘Welcome to Function’ + name);
    }

    Accessing Data through HTML and Access

    Looking at Excel Web Components to create a DAP

  3. 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();

    }

  4. 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();
    }

  5. 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

  6. 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

  7. 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.

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

%d bloggers like this: