|
i need to create a table with this value for every row:
Text
Text
Hyperlink
Note
Text
i've to thounght about create an excel table in my form.
My question are:
1)How can i control the field so to create hyperlink, set value or delete?
2)I've serched on COM dll about excel but i've found nothing!
Where is the excel dll?
|
|
|
|
|
Check out the Microsoft PIA's.
|
|
|
|
|
Hi,
Could you please recommend one good book on .net 2.0 and sql server 2005 (win or web)
Thanks
|
|
|
|
|
Hi,
I have written a software (a windows application) in C#.NET that is used by many clients of our company. Now my supervisor wants me to implement an auto update feature for the application. I think i am looking at a situation where my application needs to call a webservice to know if a newer version exists and if it does, it needs to download and execute the new version. Am I thinking in the right direction? If yes, can anyone provide me with what i need to do exactly? Any ideas will be highly appreciated.
Thanks,
Sandeep.
|
|
|
|
|
|
i had to do something similar at my company...small company here's what i did.
we have a networked server that everyone inhouse can access. the version number is located in the assembly of the app and i compare that to a data file located on the server (you can use streamreader to do that, or if you have a database back end that you can have the version information located inside of some table that you can query off of). you will need to make a deployment application (plenty of literature out there on that).
here's what i did:
-create deployment app (one of the projects that you can put in your solution) and compile: (.msi file is created)
-put msi file in shared server directory and resolve the directory path to some web address
-when the person logs into the app (im assuming through some login screen), a query is run to check the assembly version of the one on their computer as opposed to the most updated version
-if they require an update, this is what you do:
-implement the System.Net.WebClient class and download the msi off the server via the web address
-use the DownloadFile method of the webclient class
-save to a local directory (c:\temp perhaps...or somethign along those lines)
-execute the msi process using: System.Diagnostics.Process.Start("c:\TEMP\yourapp.msi")
-and then close your application: this.close() or something along those lines
-the installation should run as normal and then the user can start up the application again
-obvioulsy the version will be correct and this process wont happen again.
-read up on deployment applications, im sure you can do something manual like copy each executable manually over the web, but the msi makes it much easier...creats short cuts and everything.
only bad thing is that you're going to have to manually install the first version of this on each person's computer
best of luck
|
|
|
|
|
Thank you very much for the tip. I was wondering how i could download files from a web address and you just solved my problem.
Cheers!
|
|
|
|
|
I'm getting a "Failed to open database using..." error when attempting to connect to SQL Server located on a remote machine, using a user account login. Do I need to use a different Account setting? I'm currently using ServiceAccount.LocalSystem.
(and yes, I posted this in the ADO.NET forum too, but forgive me, this forum gets a lot more traffic).
Marc
VS2005 Tips & Tricks -- contributions welcome!
|
|
|
|
|
I guess you are using a windows service to connect to the database. The settting you have seems to be fine. Make sure the connection string you use has the username and password of an account that has accesss to your database. That should solve your issue.
|
|
|
|
|
You need to be running the service with a different account. LocalSystem is allowed access only to local resources. Sometimes even accessing localhost via TCP/IP will not work with this account!
Go to the Control Panel/Administrative Tools/Services, double-click the service and under the Logon tab, change the account to one that is allowed to access the DB (or even just a domain account or even a local account on the server if you're not using Windows authentication to connect to the DB).
--
Umm... what's a .sig? ;]
|
|
|
|
|
How can I access HttpApplication object within the class which does not belong to the same namespace as the application?
Thank you.
talbot
|
|
|
|
|
Use the full name of the class. MyNamespace.Classname
|
|
|
|
|
I don't want access the class, but the current instance of the application. How can I obtain the reference to the app?
|
|
|
|
|
Pass the instance of the application as an object in the constructor for your class.
|
|
|
|
|
Ok, thank you.
Is there any other/elegant aproach how can it be done in case if I have a lot of nested methods?
|
|
|
|
|
Well, frankly speaking, I do not see what is not so elegant about passing an object into the constructor. May be if you post some code, I can understand the situation well and could help you if i can.
|
|
|
|
|
E.g.:
namespace namespace1
{
class HttpAppObj : HttpApplication
{
public s_i = 5;
HttpAppObj.method1()
{
namespace2.cobj2 obj2 = new namespace2.cobj2();
obj2.method2();
}
}
}
namespace namespace2
{
class cobj2
{
cobj2.method2()
{
namespace3.cobj3 obj3 = new namespace3.cobj3();
obj3.method3();
}
}
}
...
namespace namespaceN // E.g. N = 20;
{
class cobjN
{
protected int i = 0;
cobjN.methodN()
{
namespace1.HttpAppObj appObj = ???Global app instance???; // This is my task...
i = appObj.s_i;
}
}
}
|
|
|
|
|
Hi. I want to share data (counter) among clients connected to the ASP.NET server. How could I do that? The data need not be persistent in case of server shutdown.
Thank you for your help.
talbot
|
|
|
|
|
You must post ASP.NET questions in its respective group.Anyways the answer would be to save the data in the application state. you can share an application state with all the users of your application.
|
|
|
|
|
I want to display the node text after selection in a label. However i need to restrict this display to only the 3rd-child node in the list so in other words,
CompanyName
-
DeptName
-
UserName
-
UserPC
UserPhone#
- Dept1Name
-
User1Name
-
User1PC
User1Phone#
I want to restrict the display of name to only the username, user1name, user2name, etc. nodes, and it needs to stay until the next user name is selected... Once i figure out the restriction portion i'll beable to set the label text static until the next username selection...
just would like some assitance with the setting of the node restriction.
any ideas?
string Beautiful;
Beautiful = "ignorant";
label1.Text = "The world is full of " + Beautiful +" people.";
Why is common sense such an un-common comodity?
|
|
|
|
|
I'm guessing that everyone was gone for the holidays, So i'm hopping that by adding to this thread will give it some more visiblity......
Help!!!!!
string Beautiful;
Beautiful = "ignorant";
label1.Text = "The world is full of " + Beautiful +" people.";
Why is common sense such an un-common comodity?
|
|
|
|
|
Easy. Each Node has a Tag property. Just set the Tag property to some value that signifies it as a displayable node.
TreeNode newNode = new TreeNode();
newNode.Tag = 0;
newNode.Tag = 1;
When the user selects a node, check its Tag property to see if it should be displayed in your label.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hmm, good catch...
but,
can't do it
all of my nodes (save the root) are loaded by the dataReader, so i am currently loading the node text and tag from the db so i can't edit the tag value unless i create a tag_value coulumn on the db... where i could set the usernames as 1 and all others as 0
unless someone else has a better idea / plan.
string Beautiful;
Beautiful = "ignorant";
label1.Text = "The world is full of " + Beautiful +" people.";
Why is common sense such an un-common comodity?
|
|
|
|
|
was thinking about this some more...
since the Tag property is of type: object
i can pretty much do whatever i want with it, the question just becomes what is the best thing to do?
or is simply going with a primative(so-to-speak) 0 or 1 value the best option?
string Beautiful;
Beautiful = "ignorant";
label1.Text = "The world is full of " + Beautiful +" people.";
Why is common sense such an un-common comodity?
|
|
|
|
|
If you want to determine if a specific treenode level, you can use this...
int treeNodeLevel=1;
TreeNode tn = treenodeToBeTested;
while (tn.Parent != null)
{
tn = tn.Parent;
treeNodeLevel++;
}
You can then say...
if (treeNodeLevel == 3)
{
...do whatever
}
Darryl Borden
Principal IT Analyst
dborden@eprod.com
|
|
|
|