|
hi
i need an example for creating a report in excel file from C# code
thanks
|
|
|
|
|
|
Hi
I need also to create a graph(in Excel) from the data i have in C# code
thanks
|
|
|
|
|
Where are you getting errors? Post
the code you tried.
|
|
|
|
|
Errors and Excel, I recently have resolved a major pain when using OLE DB. If you are using the Excel Object Model then ignore this. Basically I was glad to finally discover some info buried on MSDN that helped me resovle reading (importing) data from Excel via OLE DB.
Two things:
In your Connection String Extended Options there is a setting called IMEX. It can have one of the following values:
<br />
0 = Export<br />
1 = Import<br />
2 = Update<br />
Thus, let's say you want to read an Excel file that has a few questionable cells (i.e. IMEX=1). Well without some further intervenion in the Registry, OLE DB still may not fetch the records properly because it uses the first 8 cells in the column to guess the data type. Easy to fix but you have to know about this to make it work.
Nip into REGEDIT and goto to:
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel<br />
Then you have to tweak the value of a setting called no less than TypeGuessRows. You can choose a value that makes sense in your context, say it might take 100 cells to determine the type in your estimation. Then here it's definitely OK to try 100 as the value. This is an execise in tuning verus trial and error. If you have a humongous spreadsheet, you can use 0 which causes the Type Guess to scan up to 16,000 rows. That's a tad excessive for most apps, so like I said trial and error.
BUT Wait there's more.... when you finally go to deploy your application MAKE SURE your MSI updates the Registry!
Mike Luster
CTI/IVR/Telephony SME
|
|
|
|
|
How to use settimeout property in C#
can any one pls help me out
Neelam Ravi Kumar
|
|
|
|
|
try this link
http://www.dotnet247.com/247reference/a.aspx?u=http://www.kbalertz.com/Feedback_314190.aspx
Neelam Ravi Kumar
|
|
|
|
|
Is it possible to install the downloaded application in a quite mode. Using command line arguement "/q" we can install the application in a quite mode when we are installing the msi r exe file from the command prompt or from any other .Net application using the Process.Start with the arguement "/Q". Is it possible to do in the same way in the ClickOnce deployment.
Is it possible to get the values an do some processing like, checking the Licencse key and getting the email id or pin from the user or client.
Please reply me.
Regards
Mukilan.P.S
|
|
|
|
|
Not unless the installer has a quiet option, if it does check the docs for how to invoke it.
An alternative (although a bit more work) would be to use NSIS which does support quiet installs.
Sorry I'm not of more help
Ed
|
|
|
|
|
We can access delegate invokationList by mthod GetInvocationList (), But we can't use it in a event.
I want to Add a Eventhandler to handle event Control.LoadComplete, but when a server side event occurs such as Button_Click, the click event handler will be invoked before my handler, how can i do my job before it??
thanks for any helps.
|
|
|
|
|
Dear All,
Is it possible to change the user interface in the set up project. suppose i need a dialog in the END node with textboxes for example Texboxes (A) dialog.
but its not possbile to add that dialog in the End node. Can any one please tell me a way to customize the User interface in a set up project. Im doing set up project in a VS.net 2005
Regards
Mukilan.P.S
|
|
|
|
|
Hello,
maybe someone here can help me. I need something like a tooltip. In this tooltip should be displayed a string. Til now it is not complicated. But the problem is that the string should be bind to an object and so automatically updated. Is this possible? is there something available on the whole web?
Regards
Hansjörg
|
|
|
|
|
Have you looked into the ToolTip class?
MSDN
No hurries, no worries.
|
|
|
|
|
In this class I have not found any possibility to bind the shown text to a property of an object...
Maybe there is a possibility but I don't find any...
Regards
Hansjörg
|
|
|
|
|
hpetriffer wrote: bind the shown text to a property of an object
Do you want to automatically update the text in both object property and tooltip? Write an event handler that updates them if the text changes?
No hurries, no worries.
|
|
|
|
|
yes it seems that this is the only solution. But I have another problem with the tooltip. If I open a contextmenu of the object on which is displayed the standard tooltip (.net2.0). the tooltip is not displayed anymore. it is displayed only when I call SetToolTip another time...
Regards
Hansjörg
|
|
|
|
|
keep the text in memory instead of relying on the tooltip...
No hurries, no worries.
|
|
|
|
|
What do you mean with that exactly?
|
|
|
|
|
you have a string eg. "my dynamic text".
If this text should change, you'ld like to change the property of your object and of your tooltip?
Do something like:
public void SetMyDynamicText(string input){<br />
inmemorystring = input<br />
}
something like that, it's getting difficult without really knowing what you'ld like to do...
good luck.
No hurries, no worries.
|
|
|
|
|
Okay this I understand, this I can solve when I make an event OnDataChanged or something else, where I can change the text of the tooltip...
But I don't understand til now, why the tooltip doesn't show the text anymore when I open a contextmenu on the same object (I do nothing there!)
Regards
Hansjrög
|
|
|
|
|
check if the active property is still true after the context menu, if it is I wouldn't know either 
No hurries, no worries.
|
|
|
|
|
I have set the property also to true in the contextmenu. But I saw alos that if I press ESC in the contextmenu the tooltip is not shown anymore ((
Thanks for your help!!!
|
|
|
|
|
hi,
you can change the tool tip text when ever needed.
toolTip1.SetToolTip(this.button1, "My button1");
the follwing was from an external help:
The following code example creates an instance of the ToolTip class and associates the instance with the Form that the instance is created within. The code then initializes the delay properties AutoPopDelay, InitialDelay, and ReshowDelay. In addition the instance of the ToolTip class sets the ShowAlways property to true to enable ToolTip text to always be display regardless of whether the form is active. Finally, the example associates ToolTip text with two controls on a form, a Button and a CheckBox. The code example requires that the method defined in the example is located within a Form that contains a Button control named button1 and a CheckBox control named checkBox1, and that the method is called from the constructor of the Form.
Visual Basic
' This example assumes that the Form_Load event handling method
' is connected to the Load event of the form.
Private Sub Form1_Load(sender As Object, e As System.EventArgs) Handles MyBase.Load
' Create the ToolTip and associate with the Form container.
Dim toolTip1 As New ToolTip()
' Set up the delays for the ToolTip.
toolTip1.AutoPopDelay = 5000
toolTip1.InitialDelay = 1000
toolTip1.ReshowDelay = 500
' Force the ToolTip text to be displayed whether or not the form is active.
toolTip1.ShowAlways = True
' Set up the ToolTip text for the Button and Checkbox.
toolTip1.SetToolTip(Me.button1, "My button1")
toolTip1.SetToolTip(Me.checkBox1, "My checkBox1")
End Sub
C#
// This example assumes that the Form_Load event handling method
// is connected to the Load event of the form.
private void Form1_Load(object sender, System.EventArgs e)
{
// Create the ToolTip and associate with the Form container.
ToolTip toolTip1 = new ToolTip();
// Set up the delays for the ToolTip.
toolTip1.AutoPopDelay = 5000;
toolTip1.InitialDelay = 1000;
toolTip1.ReshowDelay = 500;
// Force the ToolTip text to be displayed whether or not the form is active.
toolTip1.ShowAlways = true;
// Set up the ToolTip text for the Button and Checkbox.
toolTip1.SetToolTip(this.button1, "My button1");
toolTip1.SetToolTip(this.checkBox1, "My checkBox1");
}
C++
// This example assumes that the Form_Load event handling method
// is connected to the Load event of the form.
void Form1_Load( Object^ sender, System::EventArgs^ e )
{
// Create the ToolTip and associate with the Form container.
ToolTip^ toolTip1 = gcnew ToolTip;
// Set up the delays for the ToolTip.
toolTip1->AutoPopDelay = 5000;
toolTip1->InitialDelay = 1000;
toolTip1->ReshowDelay = 500;
// Force the ToolTip text to be displayed whether or not the form is active.
toolTip1->ShowAlways = true;
// Set up the ToolTip text for the Button and Checkbox.
toolTip1->SetToolTip( this->button1, "My button1" );
toolTip1->SetToolTip( this->checkBox1, "My checkBox1" );
}
J#
// This example assumes that the Form_Load event handling method
// is connected to the Load event of the form.
private void Form1_Load(Object sender, System.EventArgs e)
{
// Create the ToolTip and associate with the Form container.
ToolTip toolTip1 = new ToolTip();
// Set up the delays for the ToolTip.
toolTip1.set_AutoPopDelay(5000);
toolTip1.set_InitialDelay(1000);
toolTip1.set_ReshowDelay(500);
// Force the ToolTip text to be displayed whether or not the form
// is active.
toolTip1.set_ShowAlways(true);
// Set up the ToolTip text for the Button and Checkbox.
toolTip1.SetToolTip(this.button1, "My button1");
toolTip1.SetToolTip(this.checkBox1, "My checkBox1");
} //Form1_Load
|
|
|
|
|
I know that solution, but here it is not possible to update the text of the tooltip automatically.
The only solution to solve this is to generate an event OnDataChanged and then to update the ToolTip text...
|
|
|
|
|
hi guys
Anybody knows how to find the last saved file's full path while running
Windows XP?
for example user saved a file named "exam.txt".But I do not know the full path
where the file saved.I want to know "full path of the last saved file".
Who can help me?
thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
