|
I am updating an excel spreadsheet using OleDbConnection and OleDbDataAdapter.
This seems to be very quick if the excel file is closed.
Now, I would like to make sure that is the case.
i.e:
if the file is open, then save and then close.
go through the update as it is doing now
open the excel file again.
Question.
How can I check if the file is open?
save and close
and then re-open.
Thanks
|
|
|
|
|
not sure if this will help you or not, but what the hell . . .
If you use the MS Office Interop classes (MSDN 1[^] MSDN 2[^]) there's a property in the Workbook class that might help you. The simplest way of opening an Excel file is
ApplicationClass excelApp = new ApplicationClass();
_Workbook myWorkbook = excelApp.Workbooks.Open(@"C:\test.xls", Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
and then you'll have available the myWorkbook.ReadOnly property that tests several different conditions, one of which is if the file is already open in Excel. If the file is already open or otherwise un-editable then this property will return true and you'll know you have to yell at your user and tell him/her to close it before you can modify it.
|
|
|
|
|
hi i want to set size of form according to system resolution ... how to do that in windows application
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile : +919423872257
Pune(India)
|
|
|
|
|
|
This should do:
int x = SystemInformation.PrimaryMonitorSize.Width;
int y = SystemInformation.PrimaryMonitorSize.Height;
Enjoy
|
|
|
|
|
HI Guy
Nice way, get Monitor resolutions values.after ajust with form value and based on the resoltions.or try with autoscale property for form.
Thanks
Cheers
RRave
MCTS,MCPD
|
|
|
|
|
I have requirement storing and retriving images from sqlserver.
insertion works fine but getting images from sqlserver not working . so how we can implement asp.net web application using c#
|
|
|
|
|
rajeshkumar g wrote: insertion works fine but getting images from sqlserver not working
Why isn't it working? What have you tried?
If you don't supply sufficient information relating to your problem, you won't get any help.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
following code works fine in vb.net application but in c# application doesnot work because myDataReader.Item method not in c#. so how this one implemented in c#
Dim myConnection As New SqlConnection("server=latitude-be8a47;database=tempdb;uid=sa;password=sa")
Dim myCommand As New SqlCommand("Select * from Person", myConnection)
Try
myConnection.Open()
Dim myDataReader As SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Do While (myDataReader.Read())
Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))
Loop
myConnection.Close()
Response.Write("Person info successfully retrieved!")
Catch SQLexc As SqlException
Response.Write("Read Failed : " & SQLexc.ToString())
End Try
|
|
|
|
|
rajeshkumar g wrote: myDataReader.Item method not in c#. so how this one implemented in c#
myDataReader["myfield"]
BTW, you could have found this information yourself had you read the documentation or searched Google.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
|
Without a better explaination of what is wrong it will be hard to help.
How do you know they are inserted the right way?
In ASP.NET to use dynamic images, you need to create an ASPX page that will output an image as its sole purpose.
I have created applications that store files in databases and read them back out, I should be able to help you out pretty easily.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
following code works fine in vb.net application but in c# application doesnot work because myDataReader.Item method not in c#. so how this one implemented in c#
Dim myConnection As New SqlConnection("server=latitude-be8a47;database=tempdb;uid=sa;password=sa")
Dim myCommand As New SqlCommand("Select * from Person", myConnection)
Try
myConnection.Open()
Dim myDataReader As SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Do While (myDataReader.Read())
Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))
Loop
myConnection.Close()
Response.Write("Person info successfully retrieved!")
Catch SQLexc As SqlException
Response.Write("Read Failed : " & SQLexc.ToString())
End Try
|
|
|
|
|
In my page i have used AJAX model popup, once i use the model popup it will generate error on click on any button.
the error is "Sys.InvalidOperationException: Handler was not added through the Sys.UI.DomEvent.addHandler method"
Best Regards,
Chetan Patel
|
|
|
|
|
AJAX questions should be asked in the ASP.NET forum.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi
Can any body tell me is there any way to display a Table in the
windows application?.Like (HTML -Table with controls in Web applications)
Thanks in advance...
your
peter
|
|
|
|
|
Wow....
You best start here: C# for Dummies[^]
Come back when you're done.
He who makes a beast out of himself gets rid of the pain of being a man
|
|
|
|
|
Whats wrong with that question, i dont understand why did you ask him to read that book.
ASFAIK upto .net 2.0 version winforms doesnt have table control.
Have to manage with Panels or use GDI
Thanks
Srini
|
|
|
|
|
Thanx srini
you have understand my problem.
your
peter
|
|
|
|
|
Are you looking for something like this?
TableLayoutPanel[^]
If you are looking for something else please make it clear...
*jaans
|
|
|
|
|
Hi ,
Thanx for reply. But I am using VS2003.Is there any other way to do in 2003.
Thanx in advance...
your
peter
|
|
|
|
|
I would like to write an application (in C#) to read data from a textbox to a WORD doc (and vice versa), can anyone HELP me.
Mvelo Walaza
Junior Developer
Telkom SA
|
|
|
|
|
You can use Word Object Model to work with word files
|
|
|
|
|
|
Hi All,
I implemented a C# class library and registered it to be visible for COM objects, then i used it from VB6 application and it works fine. Now the problem is that i want to raise an event in the .NET COM and pass it as an event in VB6. i.e. when the .NET COM catched an exception i want it to raise event in the VB6 application to log the event (because the logger works there). Any ideas?
Thanks,
Mayy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
