Netstair ODBC(Open Database Connectivity)

 
It can be used with the following databases
MS-Access - Database
 
MS-SQL - Database
easy to use, no need to know HOW to code connection strings.
all you need to have NetstairODBC.dll referenced when working with Project solutions or add it to the
bin folder when Website project.
Download here NetstairODBC.zip
 //- Fetch Data from SQL Database
 NetstairODBC.SQLDBC oDB = new NetstairODBC.SQLDBC();
 DataTable dt = oDB.SQLDataTable("SELECT * FROM tblTableGoesHereName");
  if (dt.Rows.Count > 0)
  {
        foreach (DataRow dr in dt.Rows)
         {
               //- Process record               
          }
   }
  dt.Clear();
  oDB.Dispose();

//- Insert data into SQL Database Table
 NetstairODBC.SQLDBC oDB = new NetstairODBC.SQLDBC();
 int iRecordAffected = oDB.SQLExecute("INSERT INTO tblTableName(first.last) VALUES('John','Doe'));
 oDB.Dispose();

Add Feedback