|
Thanks, the reference to the Grid's BindingManager was what I was looking for. Did not know how to use the grid to get back to the dataset. got it working, thanks
|
|
|
|
|
Hello,
I hope someone can help with this problem.
I'm working on an app which reads the company database for a range of scanned images according to user and date. It retrieves a list of all relevant scans and displays the results in a datagrid, date scanned, image location etc. The image is not displayed.
When I hit the Export button, the 'grid is made into an Excel spreadsheet and all the images downloaded locally. I need the image location column of the spreadsheet to be a relative hyperlink to the local copy of the images that were downloaded.
I can go into the spreadsheet and manually turn every link into a hyperlink which is OK when the result set is only a few lines but there could be hundreds of rows potentially. I want to be able to do it programatically. Any ideas?
I've messed about with the text in the spreadsheet as it is written with things like
xl.Cells[rowIndex + 1, 5] = "/images/" + filename.Substring(45, 10) + ".jpg";
trying to turn it into a relative link this way but no dice.
Any ideas please, as I'm stumped.
Thanks in advance and Merry Christmas to everyone
Scott
scotlandc
|
|
|
|
|
I need to have a menu with similar look and feel like the MainMenu except that I need to be able to put it anywhere in form( making little flexible). I started having Panel as holding main menu items. I need to provide functionality pretty much same as MainMenu. That means if a menu item has children it should be able to add an arrow to the right and show the sub menus on mouse over and make appropriate menus invisible on mouse out.
I would appreciate if anyone would throw some light into it.
Thanks in advance,
VPMahank
|
|
|
|
|
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
|
|
|
|