In my application i want database data expotred to excel sheet and i have to make this file as readonly and i want to display message if the user try to edit the excel Like-you are not allowed to edit this sheet im doing this in console application
i have wriiten code like this:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data.Odbc;
namespace ConsoleApplication1
{
class Program {
static void Main(string[] args) {
SqlConnection con = new SqlConnection (""); con.Open(); SqlCommand cmd = new SqlCommand ("select Temprature,time,date from temprature3 ", con); SqlDataReader data = cmd.ExecuteReader(); OdbcConnection dcon = new OdbcConnection(); dcon.ConnectionString = @"Driver={Microsoft Excel Driver(*.xls)};Create_DB=C:\Documents andSettings\Administrator\Desktop\Excel\Report.xls;DBQ=C:\Documents and Settings\Administrator\Desktop\Excel\Report.xls; ReadOnly=True"; dcon.Open(); OdbcCommand dcom=new OdbcCommand ("create table Report new (Temperature double,Time datetime,Date datetime)",dcon); dcom.ExecuteNonQuery(); Console.WriteLine("table has been created"); OdbcCommand dinsert=new OdbcCommand("insert into Report values(?,?,?)",dcon); OdbcParameter Temprature=new OdbcParameter("@Temperature",OdbcType.Double); OdbcParameter Time=new OdbcParameter("@Temperature",OdbcType.DateTime); OdbcParameter Date=new OdbcParameter("@Temperature",OdbcType.DateTime); dinsert.Parameters.Add(Temprature); dinsert.Parameters.Add(Time); dinsert.Parameters.Add(Date); int count=0; while(data.Read()) { Temprature.Value=data[0]; Time.Value=data[1]; Date.Value=data[2]; dinsert.ExecuteNonQuery(); count=count+1;
}
Console.WriteLine("------------------------------------------------------"); Console.WriteLine(count+"Number of rows are exported to excel"); Console.WriteLine("-------------------------------------------------------"); Console.ReadLine(); } }}
i'm gettinh error like this:ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
can any1 help me on this