Skip to main content

Posts

Showing posts from October 19, 2014

To develop simple window Application with database "School.mdb" and "student" table in the school.mdb database,student table with Roll no, Name and Address Field

// We will change name to s_name  using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace _2012 {     public partial class Form1 : Form     {      //   OleDbCommand cmd;         OleDbConnection con;       //  OleDbDataReader dr;         OleDbDataAdapter da;         OleDbCommandBuilder builder;         DataSet ds;         string query = "";         int max = 0,min=0;         public Form1()         {             InitializeComponent();             con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\anuj vb 10\2012\school.mdb");         }         private void Form1_Load(object sender, EventArgs e)         {             label1.Text = "roll no";             label2.Text = "name";             label3.Text = "address";    

to develop simple window application with database "customer.mdb" and "cust" table with customer name,address,town,country,postal code.

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace _2013 {     public partial class Form1 : Form     {         OleDbCommand cmd;         OleDbConnection con;               string query = "";         int f = 1;         public Form1()         {             InitializeComponent();         }         private void Form1_Load(object sender, EventArgs e)         {             con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\anuj vb 10\2013\Customer.mdb");             label1.Text = "Customer name";             label2.Text = "address";             label3.Text = "town";             label4.Text = "country";             label5.Text = "postal code";             button1.Text = "save";