|
Populating it from a database using a SQLDataReader
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
Hi Folks! I am using a class that puts data into excel worksheet and do formatting etc. Every thing is fine but i am not able to close the excel app when i exit the program. I'm saving the workbooks, using .quit() and ReleaseComObject(obj) functions but to no help.
Please help me.
Aman Tur
modified 9-Jul-22 21:01pm.
|
|
|
|
|
Do you have a referance to the application? The following is How I do it in C#. VB should be simular.
Excel.ApplicationClass EApp = new Excel.ApplicationClass();<br />
Excel.Workbook EWrk;<br />
EApp.Workbooks._Open(FilePath, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);<br />
...<br />
EApp.Quit();<br />
EApp = null;<br />
EWrk = null;
Hope this helps.
ARon
|
|
|
|
|
Thanks ARon i am putting EApp = null already let me try EWrk also.
modified 9-Jul-22 21:01pm.
|
|
|
|
|
While debuging set the APP to visible, making easier find the problems like a "Would you like to save changes" dialog. You will get no indication in your app if it is excel tripping up.
AH
|
|
|
|
|
I want to make a .NET application in C# that can act as an active document server. To my disappointment I can't find any support for it.
Has anyone implemented the interfaces that are necessary to support it in .NET?
What would be the typical alternative to active document in .NET?
|
|
|
|
|
Excuse me for a quick noob question:
Let's say a component of my C# application throws and exception. I want to catch it and handle it, but!
I have try...catch in program.cs around the whole Application.Run(new FormMain()); and yet the system itself somehow pops the "application error" dialog with the whole backtrace and all. I'm guessing it's catching the exception sooner somewhere handling my FormMain execution. Where would I then place the whole form wide exception handling to intercept it before the .NET code?
3.1415
|
|
|
|
|
I might be missing something, but it sounds like .NET can catch the exception raised in your code before you can. If you don't know where exactly the exception could be raised, you needn't do anything. If you do know the exact code segment, try to catch and handle the exception before .NET does.
Best,
Jun
|
|
|
|
|
Try handling the AppDomain.UnhandledException event. However, you should find the cause of the exception and handle it at the point closest to where it is being thrown
only two letters away from being an asset
|
|
|
|
|
If you click and hold on a regular Button control and then press alt+tab (without releasing alt), the button will go into it's normal unpressed state. I wish to do the same with my custom control but have been unable figure out how to detect when the user presses alt+tab as the LostFocus event doesn't fire until alt is released.
Any ideas on how MS did this?
|
|
|
|
|
Hey Everybody!
I'm not sure if I'm in the right forum, so if not, just tell me and I'll rewrite it again in the right place  Thanks!
I started to read and understand "Extending Explorer with Band Objects using .NET and Windows Forms" article and I'm trying to understand what is GAC and strong name.
I've been looking for an article that will explain GAC, but I couldn't find a good one that explains the basic idea.
from what I understand (which might be wrong!), GAC is a global assembly that "contains" DLLs that can be accessed by any running program on the computer.
each dll has a "strong name" which is destincs to each DLL and using that strong name programs can "talk" with this dll.
if (all of the above is right (or at least partial right))
{
how do I assign a dll to the gac (without the registerLib in the article)?
do I have to reassign it everytime, or I need to do it once?
how do I remove a DLL from the GAC?
and last one, how do I read from the GAC? (I saw an article about it, but it would be nice if someone would explain it anyway ).
}
Thanks ALOT!!!
|
|
|
|
|
|
Hi all, here is my problem:
(system is VS 2005, C#, ADO .NET 2)
I have a bindingsource, a datagrid, and set of details like fields on the same
form. Next, there are following bindings set:
void Init()
{
BindingSource.DataSource = someLocalTable
datagrid.DataSource = BindingSource
for every control
{
Control.DataBinding.Add("...", BindingSource, "...")
}
}
Moving through a datagrid changes the data in bound detail controls, hence
BindingSource too, changes position. Changing data in controls changes
the data in selected dataGrid row.
The problem is:
I have a button "Insert New", that does exactly this:
1. adds a new row in the local someLocalTable and
fills it with the default values:
DataRow dr = someLocalTable.NewRow();
... fill default values
someLocalTable.Rows.Add(dr);
2. TRIES TO CHANGE THE BINDINGSOURCE-s POSITION TO LAST(newly created table row)
3. This is the step where after changing position on the bindingSource
to the newly created row (.MoveLast()), you expect detail fields change
to null (or empty), and dataGrid changes the ActiveRow and position
However, after adding new row to someLocalTable, I can not change the position
of the bindingSource to that new row. BindingSource.Count returns good nr. of
rows, including the newly created. I tried a lots of things, like rebind all
controls like on the Init method, still no luck. Am I missing something here?
I forgot to mention that the grid is actually Infragistics ultraGrid, but that
doesn't change the basic concept...
Mike
|
|
|
|
|
I am not a CS programmer, but it sounds like you may need to call the ResetBindings method on your BindingSource control(s) prior to calling MoveLast.
Hope this helps.
|
|
|
|
|
No, I have tried that allready.
Like I said, I tried to even mannualy reset bindings, still doesn't
work.
Thank You for trying...
Mike
|
|
|
|
|
I have 4 ComboBoxes on a win form frm1 I have 2 comboboxes on another form frm2 all of these combobxes are databound.
On private void Combobox1frm2_SelectedIndexChanged(object sender, EventArgs e) I have some data selection events bu when frm2 is loading it automatically rins this procedure, I dont unserstand how.
On the from load Im bindign them by assignin these comboboxes to a DataSet.
Whats the problem?
Oh by the way Im using compact framework
_____________________________________________________
Yea! I could be wrong...
|
|
|
|
|
Can someone guide mehow to develop HL7 compatible programs using VB/ASP .net ?
What kind of client and server based programs have to be developed, anyone has any experience ? any websites/tutorials ?
thanks
anuj
anuj
|
|
|
|
|
Hi,
HL7 is a format for data representation. It can be in encrypted form or un-encrypted. There are many ready made components which provide functionality for parsing these HL7 messages. Otherwise, you can develop your own component for the same. If you go for the second option, developing on ur own, then you will have to understand the complete format. According to that you can easily create HL7 parser.
If the message is encrypted then you will have to know the encryption algorithm and the key for decryption.
The following link is useful-
http://www.hl7.org.au/
You will get lot of ready made components online to start with. try google !
<marquee>"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
Anant Y. Kulkarni
|
|
|
|
|
Searching in googleis like searching for a needle in a haystack, wud u know any ready components in .net, which can map to form mesages from our tables, route the message to the engine and get an acknowledgement in HL7 format.
Chameleon is a good engine, but how to integrate in our exisiting software.
thanks
anuj
|
|
|
|
|
DON'T CROSS POST 
only two letters away from being an asset
|
|
|
|
|
I migrated my project from dot net 2003 to dot net 2005.
I added the project in visual source safe. at the beginning it was working file in 2 machines but the next day I found that in other machines I am not able to log in in the source control.
one more problem I am getting is :
Due to some problem I uninstalled visual source safe in one of the machine. Then when I installed the same iit is not working properly in both .net 2003 and 2005.
I tried by un installing all the visual studio and installed first the visual studio6.0 with source safe and then installed .net2005. till then I am not getting the source control menu in .net.
any help in this regard is appreciated.
Rabindra Patra
(0)9322340492
Niche Softek Pvt Ltd
|
|
|
|
|
Hello everybody, I am writing a program in c# for logging/analyzing purposes and am trying to access the information located in another applications datagrid. I figured out how to use the winapi and sendmessage to get text from textboxes, comboboxes, listboxes, etc... but cannot seem to find anything about getting text from a datagrid. Is it even possible? I searched msdn for datagrid SendMessage information and nothing of significance was available.
Thanks.
|
|
|
|
|
Hi All,
am working on .net windows application.as my application takes more time to run,a problem is getting known:ContextSwitchDeadlock
how to solve the problem and where to include the code in my application to solve it.if any of u find, plz reply me as early as possible.
Thanks in advance.
Regards,
cnr.
|
|
|
|
|
Dear All,
I am creating a Image Library and want to know what can the best and standard procedure to do this.
Concept is to have all the images needed by all projects (dlls and exes) in the product at a central place (in a single DLL) making it easy to distribute and maintain.
There are 2 ways of doing this.
1) Creating a new project, add all the images to it using "Add Existing Item" and set Build Action=Embeded Resource for each image.
OR
2) Creating a new project>Add new Item>Resources File and then adding all the images to it and setting Build Action=Embeded Resource for each image. Doing this will provide me a strongly typed DLL which will provide a property like access to all images. But .resx are mainly for localization. And here I am not localizing images.
My question is what is the standard way of doing this?
Do you guys know pros or cons of any of these methods?
Is anybody there knowing how Microsoft do it??? (When they need to create an image library)
Any links or articles for this?
Most important is, will the second (2) way will have any negative effect on start up time?
Regards,
----------------------------------------------------------------------------------
Jayvardhan Patil.
|
|
|
|
|
Hi All,
In .net,I have to convert a string into date in a format 'dd/MM/yyyy'.
My Code is
System::DateTime ^dt=Convert::ToDateTime(this->txtModifiedDt->Text);
try
{
String ^str=String::Format("{0,9:dd/MM/yyyy}",dt);
MessageBox::Show(str);
}
catch(Exception ^e1)
{
MessageBox::Show(e1->Message);
}
its working fine when I type in the order of dd/mm/yyyy format
But when i type for example:
08/13/2006.it is giving error that exception has occurred.
But what i need ,it should automatically convert date as 13,month as 08 .
ie like 13/08/2006
Is there any way to do like that
Thanks in advance
Nagaraju
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
