insert-data.axpx Source Code

insert-data.aspx Source Code

<%@ Page Language="C#" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

// Populate Dataset
    string line, name, gender;
    int age;
    string[ ] fields;

// Throw away first line.
    line = sr.ReadLine( );
    
    while (sr.Peek( ) > -1)
    {
        // Get fields from row of input text file.
        line = sr.ReadLine( );
        fields = line.Split(',');
        name = fields[0].Trim();
        gender = fields[1].Trim();
        age = int.Parse(fields[2].Trim());
        
        // Compose SQL command string.
        string sql = INSERT INTO Persons VALUES  + 
            (' + name + ', ' + gender + ',  + age + );;

// Create command object.
        OleDbCommand command = new OleDbCommand(sql, conn);
        command.ExecuteNonQuery();
    }
    sr.Close();
    conn.Close();
}
    
public void btnDisplay_Click(object sender, EventArgs e)
{
     // Create and configure connection string.
    OleDbConnection c = new OleDbConnection( );
    c.ConnectionString =
        Provider=Microsoft.Jet.OLEDB.4.0; +
        Data Source=e:/ectserver/sjost/Database/persons2.mdb;
    
    // Create and configure SelectCommand object.
    OleDbCommand sc = c.CreateCommand( );
    sc.Commandclass = Commandclass.Text;
    sc.CommandText = SELECT * FROM Persons;

// Create DataAdapter object.
    OleDbDataAdapter da = new OleDbDataAdapter( );
    da.SelectCommand = sc;

// Create and populate DataSet object.
    DataSet ds = new DataSet( );
    int n = da.Fill(ds, Persons);

// Display data in Literal control.
    litDisplay.Text = ;
    foreach(DataRow r in ds.Tables[Persons].Rows)
    {   
        foreach(object cell in r.ItemArray)
        {
            litDisplay.Text += cell + , ;
        }
        litDisplay.Text += <br />;
    }   
}

public void btnClear_Click(object sender, EventArgs e)
{
    // Create and configure connection string.
    OleDbConnection conn = new OleDbConnection();
    conn.ConnectionString =
        Provider=Microsoft.Jet.OLEDB.4.0; +
        Data Source=e:/ectserver/sjost/Database/persons2.mdb;
    conn.Open();

// Compose SQL command string.
    string sql = DELETE FROM Persons;;

// Create command object.
    OleDbCommand command = new OleDbCommand(sql, conn);
    command.ExecuteNonQuery( );

conn.Close( );

}
</script>

<html>

<head>
<title>insert-data.aspx Example</title>
<link rel=stylesheet class=text/css 
                       href=examples.css />
</head>

<body>

<h2>insert-data.aspx Example</h2>

<p>Populate, display, and clear table data.<br />
   Use the ExecuteNonQuery method of the command object
   to populate and clear the dataset.</p>

</body>
</html>