|
Import data in excel with OPENROWSET
but i want set formats of cell like date(dd-MMM-yy),number
and text but all should be done by sql server
or in predefine excel sheet
but not through excel objects.
|
|
|
|
|
Hello,
is there a possibility to draw controls like in a graphic-program in layers? My problem is, that i want to have for example a panel with a transparent-png-file as background drawed over a button, but the button should be visible if there's a transparency in the png file. - and maybe for every control inside my form?
Is there any way to draw them without having the restrictions of the Panels and Controls and so on?
Many thanks
|
|
|
|
|
Hallo
I'm developing a C# .Net2 application built around a DGV.
Is it possible to have the DGV data refreshed automatically as the underlying data change?
I mean, is there any way to automatically PUSH changes from database to the grid (or the BindingSource)?
Thanks in advance
|
|
|
|
|
I have a no idea what a DGV is. You can create triggers in your DB, and I believe in newer versions of SQL Server, they can run .NET code.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I think you ment DataGridView Control by dgv??
If you are using dataadapter object you can easily reflect changes to db. All you need is a timer control, and calling update method of this adapter in Tick event of timer.
|
|
|
|
|
Well, that's not very efficient, I assume that's what he's trying to avoid.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
By looking the question that he asked i think this method is adequate for this question.
I agree that this is not the best way and not very efficient but anything not mentioned about performance, or other ways that already tried.
|
|
|
|
|
hallo and thanks for the replies.
By DGV I mean the DataGridView control, but it could be any control showing data.
Actually I was trying to avoid a timer, but the underlying database is a SQL2000 thus having no possibility of CLR into T-SQL.
As far as I understand, the logic flow would be:
data changes > trigger that broadcasts/sends a message > client application "listening" > performs a grid refresh
|
|
|
|
|
Sorry I thought you were trying to send data to database. Now i understood you are trying to refresh grid from database.
data changes > trigger that broadcasts/sends a message > client application "listening" > performs a grid refresh is the best way i think
|
|
|
|
|
Yes, your outdated database probably means you have no choice but to use a timer. Unless, you write some sort of external app that broadcasts to all users somehow, when data is changed. It depends on how many users you have, how often data changes, etc.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I have maximum 15 concurrent users (on that particular table in the db) with less than 10 changes per minute: hence, I think I'll go for a timer.
Only, I thought that newer .NET brought something better on the argument...
Thanks anyway
|
|
|
|
|
It's your database that is out of date, and your database that is the issue. The database needs to tell your program when it's been changed, or you need to keep asking, those are the two options.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
If your implementation utilises BindingSource there are several events that you should consider investigating.
BindingSource.CurrentChanged
BindingSource.CurrentItemChanged
BindingSource.ListChanged
The last of these is most likely to be of use to you.
Here[^] is a link to the BindingSource reference on MSDN. I am struggling along on 53.6 Kbs at the moment otherwise I would have given links to the events themselves. 
Hope this helps.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
I want to gather the Mac address in the diffrent subnet.
Now,My programe(C#) can obtain the PC and Printer's Mac address by SNMP.
But i can not obtain the switches' Mac address by the programe.
I think i should obtain the switche's Mac address by the same programe.
isn't it?
Maybe there are some forbidden in my VLAN.it is right?
urgent help!
modified on Friday, September 18, 2009 5:09 AM
|
|
|
|
|
Hi,
I am working on shared add-in in c# for Excel. Let us consider 3 components A,B,C. Where A is a Shim,B is Shared an add-in(used IDTExtensibility interface) which creates all tool bars, menu items for Excel and C is an automation add-in which contains UDFs.
I have static property in Automaion add-in(C) which set/gets Excel Application object. Whenever OnConnection(..) of shared add-in is called from the framework, I am setting the Excel application object using this property. So When I type some UDF in Excel, it uses this Excel application object for further work on Excel.
Recently I tried to remove the Shim and put the VSTO on it. When I use VSTo, it doesn't use shared add-in.Here also I set the Excel application object by using static property. Now I have I enabled this Auotomation add-in(add-in->Options->Automation Tab).But when I type some UDF in Excel cell, excel object is not available that is set from VSTO.How do I pass reference to Excel object to Automation add-in so that the same Excel Object is available in Automation add-in when we type some UDFs.
What I observed here is VSTO and Automation add-ins are working in different AppDomains.
Please help me.
Thanks.
|
|
|
|
|
Please do not post the same question in multiple forums. Choose the appropriate one and stick to it.
|
|
|
|
|
I have installed the SNMP in my machine and the printer.
Now i can obtain the Printer's name and the other infomation.
But i can not obtain the total printing pages.
Can i use MIB to do it? Or by the other method.
Any help will be appreciated!
modified on Friday, September 18, 2009 5:08 AM
|
|
|
|
|
Hi,
I was trying to get the information WMI but i could not succeed.
and i got the solution form Winsopller.drv api
please go though this api and you can get your needful
|
|
|
|
|
Thank you jasome.
I googled the "Winsopller.drv",i have not found it.
is it "Winspooler.drv" or "Winspool.drv" which one is right?
By the way the printer is not connect with my PC,
it is in another subnet,
For Example my IP is "192.1.168.5"
The printer's IP is "192.1.167.23".
I also can use the API to obtain the printing total pages?
Thanks a lot
|
|
|
|
|
Hello Experts,
Seeking help\advise on how to go about designing a 100+ client server application (domain network) on windows (XP\Vista) desktop platform.
1. What to use? RPC\Remoting\WCF?
2. How to push install agents on client machines from server program?
3. Inter thread communication, main thread & 2 child treads, how do 2 child treads talk to each other?
Will highly appreciate if somebody can point to right articles or links that can help me getting started with the above challenges.
Many Many Thanks,
Tanmay.
|
|
|
|
|
Hi,
I'm trying to get WebDAV implementation using some open source called Sphorium and Casinni Webserver. It is able to reach the destination folder but some time i'm getting the following error.
"Documents in this folder are not available. The folder may have been moved or deleted, or network problems may be preventing a connection to the server."
What could be the cause?
|
|
|
|
|
You are more likely to get an answer if you post in the correct forum. Try Web Development (look at the side-bar to the left for forums list) 
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Check Directory Browsing permission. You must set directory browsing permission to true. This will allow to get it a list of files/folders.
|
|
|
|
|
Hi ,
What is the advantage of using IList over List in C# ? what is the difference between List and Ilist ?
Thanks,
Azeez
|
|
|
|
|
List implements IList. It takes the features of IList and implements them. Also, you can only actually create a List - IList is just a contract, or an Interface. So, List is better.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
