I have tried nd modified your code but its not working...
I have added the references but it is showing some errors, is there any easy way to do this without using old references.
I have generated the sollowing code its just giving exception error...
-----------------------------------------------------------
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace PracticalsEight
{
public partial class Publisher : Form
{
private OleDbConnection con;
private void main2_btn_Click(object sender, EventArgs e)
{
Database Form = new Database();
Form.Show();
this.Hide();
}
private void create2_btn_Click(object sender, EventArgs e)
{
// Only for demonstration purposes, no error checks:
// This code will only work as long as the table "Publisher" does not exist
// First create an new database if necessary
// Create a new table "Publisher" using ADOX ...
DataTable publishers = new DataTable("Publishers");
// Add Column "PublisherID" with Autoincrement
DataColumn publisherKey = new DataColumn();
publisherKey.DataType = Type.GetType("System.Int32");
publisherKey.ColumnName = "PublisherKey";
publisherKey.AllowDBNull = false;
publisherKey.Unique = true;
publisherKey.AutoIncrement = true;
publisherKey.AutoIncrementSeed = 1;
publisherKey.AutoIncrementStep = 1;
publishers.Columns.Add(publisherKey);
// Add column "PublisherName"
DataColumn publisherName = new DataColumn();
publisherName.DataType = Type.GetType("System.String");
publisherName.ColumnName = "PublisherName";
publishers.Columns.Add(publisherName);
//set primary key that is CarId column
DataColumn[] PK = new DataColumn[1];
PK[0] = publishers.Columns["PublisherKey"];
publishers.PrimaryKey = PK;
//
DataRow newRow;
newRow = publishers.NewRow();
newRow["PublisherKey"] = "1";
newRow["PublisherName"] = "Pakistan Publication";
publishers.Rows.Add(newRow);
//
DataTable books = new DataTable("Books");
DataSet ds = new DataSet();
//
string dbconnection = "Provider=Microsoft.Jet.OLEDB.4.0;" + @"data source=BookCSharp.mdb";
string dbcommand = "Create Table Publishers(PublisherKey integer Primary Key, “ + “PublisherName char(50))";
OleDbConnection conn = new OleDbConnection(dbconnection);
OleDbCommand comm = new OleDbCommand(dbcommand, conn);
conn.Open();
int c = (int)comm.ExecuteNonQuery();
conn.Close();
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from Publishers", conn);
OleDbCommandBuilder dcb = new OleDbCommandBuilder(adapter);
conn.Open();
adapter.Update(ds, "Publishers");
ds.AcceptChanges();
conn.Close();
ds.Tables.AddRange(new[] { books, publishers });
//
ds.Relations.Add("BookPublisher", books.Columns["BookKey"], publishers.Columns["PublisherKey"]);
MessageBox.Show("A new Data Table is successfully Created");
}
public Publisher()
{
InitializeComponent();
con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;" + @"data source=BookCSharp.mdb");
}
private void delete2_btn_Click(object sender, EventArgs e)
{
}
private void insert2_btn_Click(object sender, EventArgs e)
{
}
private void label3_Click(object sender, EventArgs e)
{
}
private void label2_Click(object sender, EventArgs e)
{
}
private void label1_Click(object sender, EventArgs e)
{
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
}
}
