Click here to Skip to main content
15,902,276 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionTreeNodeWithInfo Pin
TerRO_GirL4-Mar-09 5:12
TerRO_GirL4-Mar-09 5:12 
AnswerRe: TreeNodeWithInfo Pin
TerRO_GirL4-Mar-09 5:14
TerRO_GirL4-Mar-09 5:14 
AnswerRe: TreeNodeWithInfo Pin
Viral Upadhyay4-Mar-09 8:02
Viral Upadhyay4-Mar-09 8:02 
GeneralRe: TreeNodeWithInfo Pin
TerRO_GirL4-Mar-09 8:04
TerRO_GirL4-Mar-09 8:04 
GeneralRe: TreeNodeWithInfo Pin
Viral Upadhyay4-Mar-09 8:12
Viral Upadhyay4-Mar-09 8:12 
QuestionRe: TreeNodeWithInfo Pin
Jörgen Andersson4-Mar-09 10:00
professionalJörgen Andersson4-Mar-09 10:00 
AnswerRe: TreeNodeWithInfo Pin
TerRO_GirL4-Mar-09 10:34
TerRO_GirL4-Mar-09 10:34 
QuestionHow to update Content of Exel sheet [modified] Pin
Member 46590014-Mar-09 3:09
Member 46590014-Mar-09 3:09 
In One of my page i need to read the data from Exel Sheet ,
and After reading the content form it I need to delete the content of Exel Sheet
(means i need to delete all rows it contain

I have done till how to read data from exel , Now i need to blank it
so Plz Guide me how to Blank Exel sheet

Well for deleting i used a function


private void call1()
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\OrderHeader.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");

using (DbConnection connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString;

using (DbCommand command = connection.CreateCommand())
{
command.CommandText = "Delete from [OrderHeader$]";

connection.Open();

command.ExecuteNonQuery();
}
}


}


But it is giving error msg
Deleting data in a linked table is not supported by this ISAM.

Raghvendra

modified on Wednesday, March 4, 2009 9:29 AM

AnswerRe: How to update Content of Exel sheet Pin
Jörgen Andersson4-Mar-09 9:39
professionalJörgen Andersson4-Mar-09 9:39 
Questionhow to use the chromeless player to play the video? Pin
keyur satyadev4-Mar-09 1:23
keyur satyadev4-Mar-09 1:23 
AnswerRe: how to use the chromeless player to play the video? Pin
N a v a n e e t h4-Mar-09 1:28
N a v a n e e t h4-Mar-09 1:28 
Questioninstalling visual source safe Pin
thapaswi reddy4-Mar-09 1:06
thapaswi reddy4-Mar-09 1:06 
AnswerRe: installing visual source safe Pin
N a v a n e e t h4-Mar-09 1:07
N a v a n e e t h4-Mar-09 1:07 
GeneralRe: installing visual source safe Pin
thapaswi reddy4-Mar-09 1:15
thapaswi reddy4-Mar-09 1:15 
AnswerRe: installing visual source safe Pin
Christian Graus4-Mar-09 9:45
protectorChristian Graus4-Mar-09 9:45 
GeneralRe: installing visual source safe Pin
thapaswi reddy4-Mar-09 19:32
thapaswi reddy4-Mar-09 19:32 
QuestionWhat is Web Service Software Fectory?? Pin
mr_muskurahat4-Mar-09 1:01
mr_muskurahat4-Mar-09 1:01 
AnswerRe: What is Web Service Software Fectory?? Pin
Yusuf4-Mar-09 3:14
Yusuf4-Mar-09 3:14 
QuestionAutomatic Mailing [modified] Pin
am.net4-Mar-09 0:47
am.net4-Mar-09 0:47 
AnswerRe: Automatic Mailing Pin
N a v a n e e t h4-Mar-09 1:10
N a v a n e e t h4-Mar-09 1:10 
GeneralRe: Automatic Mailing Pin
Yusuf4-Mar-09 3:17
Yusuf4-Mar-09 3:17 
AnswerRe: Automatic Mailing Pin
Viral Upadhyay4-Mar-09 7:55
Viral Upadhyay4-Mar-09 7:55 
Questionhow to allow only asp.net machine account to read a file Pin
giri_jazz4-Mar-09 0:41
giri_jazz4-Mar-09 0:41 
QuestionMixing Of two mp3 files in Parallel and convert into a single Mp3 File in asp.net,c#.net [modified] Pin
umeshrajpoot4-Mar-09 0:29
umeshrajpoot4-Mar-09 0:29 
AnswerRe: Mixing Of two mp3 files in Parallel and convert into a single Mp3 File in asp.net,c#.net Pin
Christian Graus4-Mar-09 9:49
protectorChristian Graus4-Mar-09 9:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.