The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine




Comments

Post a Comment

Popular posts from this blog

Remove HTML Tages from Datatable In C# First Create This Function.  Public string RemoveHTMLTags( string source)  {         return Regex .Replace(source, "<.*?>", string .Empty);  } And Then use like this ---------------------------- // Data Stored in DataTable if (dt.Rows.Count > 0) { string strterm = Convert .ToString(dt.Rows[0]["term"].ToString()); strterm = RemoveHTMLTags(strterm); } else { }
Read more

Change database schema name using mssql

Question : ============================================ I have this schema :  [hhh].[spemployee] and what to change schema like this :  [eee].[ spemployee ] ============================================ Answer : ============================================= First Create below  IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'eee'))  BEGIN     EXEC ('CREATE SCHEMA [eee] AUTHORIZATION [dbo]') END Then user ALTER to change schema name  ALTER SCHEMA [ eee ]      TRANSFER [hhh].[ spemployee ] ============================================= ===================================================== and Result as below :  [eee].[ spemployee ] =====================================================
Read more

Calculate Mortgage in c# using console application

Formula :  M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1] M = monthly mortgage payment P = the principal, or the initial amount you borrowed. i = your monthly interest rate. Your lender likely lists interest rates as an annual figure, so you’ll need to divide by 12, for each month of the year. So, if your rate is 5%, then the monthly rate will look like this: 0.05/12 = 0.004167. n = the number of payments, or the payment period in months. If you take out a 30-year fixed rate mortgage, this means: n = 30 years x 12 months per year, or 360 payments. ___________________________________  Start Code  _________________________________ using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Oops_Concepts {     class Program     {         static void Main(string[] args)         {             Program objProgram = new Program();   ...
Read more