Course Hero Logo

ins del in database.docx - 1. Create a Data base “college”...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 5 out of 5 pages.

1.Create a Data base “college” and Create a table “student”using and database server like MSAccess.2.Design a New Project and Windows Application3.Drag and Drop the controls 4 labels and 4 textboxes, 1datagridviewAndbuttons4.Rename the text properties at Design time5.Following window represents the Design view6.In Form1.cs add the following code:usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Data.OleDb;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;
usingSystem.Windows.Forms;namespaceWindowsFormsApplication11{public partial classForm1:Form{publicForm1(){InitializeComponent();}private voidbutton1_Click(objectsender,EventArgse){OleDbConnectioncn =newOleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;DataSource=C:\Users\Deekshitha\Documents\college.accdb") ;cn.Open();DataSets=newDataSet();OleDbDataAdapterad =newOleDbDataAdapter("select *from student",cn);ad.Fill(s,"st");cn.Close();dataGridView1.DataSource = s;dataGridView1.DataMember ="st";}private voidbutton2_Click(
End of preview. Want to read all 5 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags
Database management system

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture