why it works in vb butnot in c#...

[jitenmaharana]

in vb.net

Dim cn As New ADODB.Connection
cn.Open("Provider=SQLOLEDB;Data Source=SYS13\CALLZONE;" & _
"Initial Catalog=importeddata;User ID=sa;Password=")

'Import by using OPENROWSET and SELECT query.
Dim strSQL As String = "SELECT * INTO " & fname & " FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', " & _
"'Excel 8.0;Database=" & fpath & "'," & _
"'SELECT * FROM [sheet1$]')"

cn.Execute(strSQL)
cn.Close()
cn = Nothing



in c#.net
\======
ADODB.Connection cn=new ADODB.Connection();
cn.Open(@"Provider=SQLOLEDB;Data Source=SYS13\CALLZONE;" +
"Initial Catalog=importeddata;User Id=sa;Password=;");

//Import by using OPENROWSET and SELECT query.
string strsql = @"SELECT * INTO Table1_Xls FROM "+
"OPENROWSET('Microsoft.Jet.OLEDB.4.0'," +
"'Excel 8.0;Database="+ fpath +"','SELECT * FROM [sheet1$]')";
cn.Execute(strsql);

cn.Close();
cn = null;


reply me as soon as possible

[jitenmaharana]

it shows error in c# that

no overload for method open takes 1 arguments
no overload for method execute takes 1 arguments

[r035198x]

it shows error in c# that

no overload for method open takes 1 arguments
no overload for method execute takes 1 arguments

Please do not ask questions in the articles section.