OLEDB Database connection string in C#.Net

OledDb database connections allow C# developers to build data powered applications with Access database. It can be possible with Database connection object and command object.

Connection string 

For connecting .mdb Access files you can use the following connection string,
string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/.Net Project/PharmaERP/PharmaERP/PharmaData.mdb";
and for the Access 2007, 2012,2016 databases you have to use the following one.
string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;;Data Source=D:/.Net Project/PharmaERP/pharmaData.accdb;Jet OLEDB:Database Password=password";

 Now we are ready to setup the connection, let build the connection objects and get started.

Connecting database with OleDbConnection object.

   
OleDbConnection conn;
OleDbCommand Rs;
public void Connect()
{
conn = new OleDbConnection(connstr);
conn.Open();
}
With the OleDbConnection object, we are ready to establish connection with the data base, all we need to manipulate data is Command object. Let start with Insertion command first.

We can use insert into SQL statement and execute, DML command with ExecuteNonquery() of command object. We can also use the Parameter to pass arguments to the insert statements. Lets have a look at the code.

public void New_Medicines(Product_Registration f)
{
Connect();
Rs = new OleDbCommand("insert into new_Medicines(product_name,pdate,manufacture,catagory,subcatagory,type,packing,printpack,reorderlevel,tax,ptr,pts,contents,rackno) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)", conn);
Rs.Parameters.Add(new OleDbParameter("product_name", f._txtPname));
Rs.Parameters.Add(new OleDbParameter("pdate",f._txtPrdate ));
Rs.Parameters.Add(new OleDbParameter("manufacture", f._txtmanufacture));
Rs.Parameters.Add(new OleDbParameter("catagory ", f._txtCatagory));
Rs.Parameters.Add(new OleDbParameter("subcatagory", f._txtSubCatagory));
Rs.Parameters.Add(new OleDbParameter("type", f._txtType));
Rs.Parameters.Add(new OleDbParameter("packing", f._txtPackNo));
Rs.Parameters.Add(new OleDbParameter("printpack", f._txtPackPrint));
Rs.Parameters.Add(new OleDbParameter("reorderlevel", f._txtReorderLevel));
Rs.Parameters.Add(new OleDbParameter("tax", f._txtTax));
Rs.Parameters.Add(new OleDbParameter("ptr", f._txtPTR));
Rs.Parameters.Add(new OleDbParameter("pts", f._txtPTS));
Rs.Parameters.Add(new OleDbParameter("contents", f._txtContents));
Rs.Parameters.Add(new OleDbParameter("rackno", f._txtRack));
Rs.ExecuteNonQuery();
}

The command object is also capable of running queries and join statements. Try it yourself.




Comments

Post a Comment

Popular posts from this blog

How to get Computer Name using VB6 Code

Accessing system property is pretty easy with VB6 code. This can be useful when programmers need to refer the system name in the code. Steps Declare the GetComputerNameA function which resides in the kernel32 library. Create a function to fetch the Computer Name. Use the function The Kernel functions Declare Function GetComputerNameA Lib "kernel32" (ByVal lpBuffer As String, nSize As Long) As Long Get the computer name Define a new function to do the rest of the task. So you can reuse the code. Public Function GetComputerName() As String Dim sResult As String * 255 GetComputerNameA sResult, 255 GetComputerName = Left$(sResult, InStr(sResult, Chr$(0)) - 1) End Function Calling the function Just invoke the function and place values to a TextBox Text1.Text = GetComputerName
Read more

SqlAlchemy[SQLite] database connection in Python-Flask

Flask is a Python framework which can be used to build the web application from scratch. Flask is a micro-framework which capable to build websites like Instagram, twitter and anything at programmers will. SqlAlchemy is a package in Python Flask which simplifies database connections. The following simple Application will explain ..... how. This project was built on windows OS and Pycharm IDE The connection string from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) app.config['DATABASE_FILE'] = 'app2.db' app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + app.config['DATABASE_FILE'] app.config['SECRET_KEY'] = '123456790' db = SQLAlchemy(app) So the db is like the cursor to the database. Read More The complete SQLite Project can be downloaded from GitHub
Read more