|
Thanks,
I did do a search before posting, however all the examples that I've come accross describe Excel automation, i.e. opening excel and populating the fields in it.
My question was, if I can embedd an excel workbook in my application, rather than having that workbook opened in the Excel app itslef.
(Something like IE does when viewing .PDF files)
Regards,
Venet.
Donec eris felix, multos numerabis amicos.
|
|
|
|
|
You've got OLE components with progids such like Excel.Sheet and Excel.Chart (you probably already know the Excel.Application progid, which in turn launches Excel).
These are OLE components, not ActiveX controls. That's why they don't appear in the IDE (customize toolbox for instance).
But they are here and ready. For instance, They appear when you are in Word, Insert \ Object, then select either Microsoft Excel Sheet, or Microsoft Excel Chart. That's exactly the entry point for that.
More info here[^].
How low can you go ?
(MS rant)
|
|
|
|
|
Example looks as exactly what I need. I'm going to try it out later.
Thanks for the reply.
Regards,
Venet.
Donec eris felix, multos numerabis amicos.
|
|
|
|
|
|
Thank you for the info. No wonder why it wasn't working!
I think that should increase my project mark for about 10% 
Regards,
Venet.
Donec eris felix, multos numerabis amicos.
|
|
|
|
|
Like the API SendMessage, PostMessage.
---
|
|
|
|
|
You have a Search edit box, right above.
How low can you go ?
(MS rant)
|
|
|
|
|
So what?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
|
I wouldn't say it better...;P
How low can you go ?
(MS rant)
|
|
|
|
|
can any body tell the sample code of inserting a row into a table and deleting a row from the table using acess data bases?
r00d0034@yahoo.com
|
|
|
|
|
public static bool Execute(string Sql)
{
OleDbCommand cmd = new OleDbCommand(Sql,
new OleDbConnection(connectionString));
cmd.Connection.Open();
cmd.ExecuteNonQuery();
if(cmd.Connection.State == ConnectionState.Open)
{
cmd.Connection.Close();
}
return true;
}
More good examples at: http://www.dotnetnotes.com/index.aspx?catID=4[^]
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
Is it possible to have a single instance of a class library?
I need a class library that returns the same object when 2 clients are using reflection to create it:
Assembly assembly=Assembly.LoadFrom("myclasslibrary.dll");
Type[] tp=assembly.GetTypes();
object app=Activator.CreateInstance(tp[0]);
Can "app" be the same when I use this code in 2 windows applications?
Thanks,
Bruno
|
|
|
|
|
There is a design pattern called a singleton, which is a class designed in such a way that only one instance of it can ever be created. I've never created a singleton in a dll that is called from multiple windows applications, but you may find that the pattern applies to your situation.
There is a site I came accross a few months ago, The Pattern Digest, http://patterndigest.com/. It covers most well known design patterns, including the singleton. I beleive it also has links to other resources. It may help you create the kind of singleton object you need.
|
|
|
|
|
Actually, I thought of this, but it doesn't go across boudaries.
|
|
|
|
|
Remoting might work well for this; the sample chapter for Ingo Rammer's book Advanced .NET Remoting
[^] might just be enough to get you going.
Good luck,
James
Sig code stolen from David Wulff
|
|
|
|
|
I'm developing a firewall log monitoring application in C#
with the .NET framework, and I can't figure out something.
I'm trying to do a reverse lookup on an IP address. I
don't mean reverse lookup to a DNS entry. I'm looking to
find out the computer-name behind the IP address.
The only thing I can find that's remotely related is:
Dns.GetHostByName() and Dns.GetHostByAddress().
However,these methods deal with IPHost objects, which only
contain DNS or IP information -- nothing about computer-
name.
Does anyone have any idea how to get a computer-name from
an IP address in my C#/.NET application? Is there anything
in .NET that will accomplish this? If so, what is it? If
not, what can I call outside of .NET that I can
incorporate into my application?
Thanks!
|
|
|
|
|
|
This is on a windows network? There is the WNet api in the PlatformSDK. You might be able to import functions from the windows networking DLL's to access windows networking information like computer names (wouldn't that be NetBIOS?).
|
|
|
|
|
No, this is not specific to a Windows network. I need to be able to get the "computer name" of any in-coming IP address to the firewall.
Basically, I want my app to be able to do what a NSLOOKUP call does. Get what I mean?
|
|
|
|
|
Yeah, makes sense. Is there an RFC or public spec for what NSLOOKUP does? I'd search the net for something and see if you can figure out the message format for NSLOOKUP messages.
|
|
|
|
|
If it's "across the wire" all you're going to get is the DNS reverse lookup. Machine names are not necessarily the same as the DNS name, and all TCP/IP w/DNS will give you is just that: The DNS name, which may or not be the machine name.
NetWkstaGetInfo() will only work on Windows machines (Pre Windows 2000 or Pre Windows 2000 compatible) where Anonymous access is allowed (a reeeeely reeeeeely reeely bad practice!)
Why do you need to know the actual machine name anyway? If there's suspicious behavior, you can trace the IP back. If it's illegal behavior, you can go deeper and give the authorities your firewall logs for the offense.
|
|
|
|
|
Hi All,
I'm trying to move colors for index 27 and beyond from the Colors enumeration to a new string[] array. The following moves them fine into the new array, and writes them out, but when the Databind occurs, it give me the following error.
Object reference not set to an instance of an object.
KnownColor enumColor = new KnownColor();
Array Colors = Enum.GetValues(enumColor.GetType());
string[] WebColors = new string[150];
for (int i=27; i< Colors.Length;i++)
{
WebColors[i-27] = Color.FromName(Colors.GetValue(i).ToString()).Name.ToString();
}
foreach (string s in WebColors)
{
Response.Write(s + "
");
}
cboColor.DataSource = WebColors;
cboColor.DataBind(); ERROR IS HAPPENING ON THIS LINE
I would be VERY thankful for any help.
Thanks,
Mike
|
|
|
|
|
I'm a CS student, and i need to write a console application which basically writes data packages read with a sniffer to a logfile and then sends data from a different logfile to a remote machine using TNS protocol over TCP. My app also has to communicate with a third party through another unique protocol over TCP.
As i never programmed with C# before, my question is if C# is suited for this kind of project or am i better off with C++ ?
|
|
|
|
|
You would be amazed how simple it is. See the System.Net.Sockets namespace, you have TcpClient and TcpServer class stuff waiting for you. As far as I can remember, there are articles on CP about this as well.
Good luck!
How low can you go ?
(MS rant)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
