Connect to Access Database in C# and ADO.NET

assallam wallekum bhai jaan well hor r u ............. its nice artical and very help full for me and thenx to u sir........... sir i needs some more help if u have time na then plz tell me

The CODE: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace InterfataBaza { public partial class Form1 : Form { private OleDbConnection mycon; public Form1() { mycon=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\george\My Documents\studenti.mdb;Persist Security Info=False"); InitializeComponent(); } private void button2_Click(object sender, EventArgs e) { cmd.CommandText = "insert into student values(" + this.textBox1.Text + ",'" + this.textBox2.Text + ",'" + this.textBox3.Text + ",'" + this.textBox4.Text + "');"; int temp = cmd.ExecuteNonQuery(); if (temp > 0) { MessageBox.Show("Record Added"); } else { MessageBox.Show("Record not Added"); } mycon.Close(); } } } The ERRORS: Error 1 The name 'cmd' does not exist in the current context Error 2 The name 'cmd' does not exist in the current context

kindly answer

Where is the answer ?

Hi  I'm  Kirk,  just  beginner

con is here command

How was the cmd error solved?

how is it solved. kindly define.

Just to add, the fixed code will look like this (I used one of my own Database's for this example):

SQL injection ?!?!?

Hello Imran,
According to your example, can you have a customised query with the:
WHERE .... LIKE %something% pattern in your C# application using Access 2003 ?

Thanks for your help.

i have to submit project within 15 days ...i have submited synopsis on online evevt mangement so plz help me...main bahut tension main hu...my mail id u knoe it but again write here manse000@gmail.com.if u have this one project plz send on this email.....and thanks for database

Please, someone should help me out. I'm getting an annoying Unhandled exception(System.NullReferenceException: Object reference not set to an instance of an object.)

Post your code it will help to figure out where the issue lies

Alright Here is the 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 Registration
{
    public partial class Form1 : Form
    {
        private OleDbConnection myCon;
        public Form1()
        {
            String connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Aykaynay\Documents\Access Db\Reg_db.mdb;Persist Security Info=False";
            OleDbConnection myCon = new OleDbConnection(connString);
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            myCon.Open();
        }

        private void btnSubmit_Click(object sender, EventArgs e)
        {
            OleDbCommand cmd = new OleDbCommand("INSERT INTO Registration VALUES ('" + this.txtUsername.Text + "', '" + this.txtPassword.Text + "')",myCon);
            cmd.Connection = myCon;
           
            int temp = cmd.ExecuteNonQuery();
            if (temp > 0)
            {
                MessageBox.Show("Record Added");
            }
            else
            {
                MessageBox.Show("Record not Added");
            }
            myCon.Close();
        }
    }
}

What line does it occur at? Your creating two myCon objects, remove the private version.

ITs really nice But my problem is I want to create user DSN through C# code for my windows application for SQl server 2005

Explain it in more detail please.

Assalam O Alaikum! Imran bhai I was looking article on Search query but I found your article which very helpful to me. If you know about Search query how to make so plz post or email me. Raza_mrmq2009@yahoo.com Regards Raza Qureshi.

thank you for source code.

Sir I heartly say to u... THANKING YOU... because i learn such important coding from your article.....:)

In this article, it says to create a blank file and save it as "Imran.udl", then double-click on it to get the "Data Link properties" window to show up. Is there a step missing here? Is there something that needs to be typed into the *.udl file before saving it? (When I double-click on the file, it just opens up in Notepad again.)

RUSSEL SIR U JUST GO STEP BY STEP.. U WILL SOLVE YOUR QUIRES. THANKS

...but double-clicking on an empty file didn't get me anywhere!

i wanted to connect a web form log in with ms access, help needed pls. thank u

Microsoft Jet 4.0 OLE DB is not seen infile.udl saved in OD Windows 7

Microsoft Jet 4.0 OLE DB is not seen infile.udl saved in OD Windows 7

Microsoft Jet 4.0 OLE DB is not seen infile.udl saved in OD Windows 7