|
Drop the reader, drop the dataset; you'll only need a connection and a command, if you need to retrieve a single value from the database. Use the ExecuteScalar-method.
There's an example in the documentation[^].
--edit
Edited an incomplete sentence, nothing special
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
I've just lost a day and a half of my working life trying to track down a bug which was causing word documents i am changing to include a mail merge source to error when opened in word 2007. The documents work fine in word 2010. After an awful lot of digging, I've tracked the issue down to the URI for the mdb file that is the data source for the merge. My non working in 2007 code was as follows:
using (var docx = WordProcessingDocument.Open(filePath, true))
{
FileInfo mdbFile = FileHelper.GetResourceFile("Merge.mdb");
Uri mdbUri = new Uri(mdbFile.FullName, UriKind.Absolute);
var settings = DocHelper.GetOrCreateSettingsPart(document);
settings.AddExternalRelationship("http://schemas.openxmlformats.org/officeDocument/2006/relationships/mailMergeSource", mdbUri, id1);
}
After an awful lot of checking i found that the relationship file was recording the uri without a leading "file:///", some more looking into this it appears that the openXML SDK is writing out the OrigionalString. The change i had to make to my code for it to work was as follows:
Uri mdbUri = new Uri("file:///" + mdbFile.FullName, UriKind.Absolute);
I guess my question is, was i doing something wrong when working with the Uri or is this something that the SDK is not getting right. Additionally i really hope it is not a bug that was found, and fixed in Office 2010 by working with the Uri missing the "file:///" prefix insted of changing the SDK to write out Uri.ToString();
|
|
|
|
|
hello friends:
i have to create a window service in which we check the internet connection is working or not and if it's working then i have to display a message in taskbar notification in every 2 or 3 mins.Can anyone help me...
Thanks in advance all
Bhanu
|
|
|
|
|
So what have you tried so far? What have you rejected?
|
|
|
|
|
i made an application in which i checked that internet connection is working or not and displays in the messagebox after click on a button in a form.but now i am trying to check connection with the window service in which the user login and message displays in the taskbar notification with the tray icon.I am failure to doing that so far...can u please help me...
thanks
Bhanu Madan
|
|
|
|
|
The problem is in the combination of "Windows Service" and "taskbar notification". Due to Session 0 Isolation, a service cannot interact with a user desktop (Windows 7).
Consequently, you need an extra application which communicates with that server and shows the information.
|
|
|
|
|
thanks..
but can u please ellaborate...?
Bhanu madan
|
|
|
|
|
A windows service is started when the computer boots, and is already running before you login. If the user hasn't logged in yet, there IS NO desktop to show your notification. You're not allowed to display anything on that login-screen.
Your app should be a normal app, not a service, and should be started when the user logs in. Once you do that, Windows will also show the notification icon.
Who came up with the requirement that it needs be a service?
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Get path of Files accessed or in use by a process , without using handle or other tools
|
|
|
|
|
Why does it need to be without handles, and why are you assuming that there's a solution without handles or external tools?
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
You either enumerate the handles the process is using and investigate what they go to or you don't get the information you want. It's that simple.
|
|
|
|
|
hi, i am using vs.net 2010 c#
i created several entity such as user.
and now i have to create the database which then i can use linq to link them.
however i would like to ask if there is an easier way to do this. such that the database would be created base on the entity information.
example like how java ejb create the database from the entity class by defining the relationships.
|
|
|
|
|
|
how to work class library&dll
|
|
|
|
|
This is not a very clear question; do you wish to create a library or just use one?
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
You need to build your code to create a dll assembly.
|
|
|
|
|
The .NET Framework class library is a library of classes, interfaces, and value types that are included in the Microsoft .NET Framework SDK. This library provides access to system functionality and is designed to be the foundation on which .NET Framework applications, components, and controls are built.
Refer here[^].
|
|
|
|
|
Hi, let´s suppose i have a 3 element´s matrix (boxes dimensions) and i want save the values in it from database, excel,... So, I was thinking do a windows where you select the acquisition method, thus i can make a new modules in future.
How can i make this external module? and call that module in my program?
I dont asking for code only the way to do it
Thanks
|
|
|
|
|
Depending on the language you are using you could make it into a shared or static library, a separate compilation unit or even a separate executable that uses some cross application communication to move the data.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
pablogvivo wrote: and i want save the values in it from database, excel,...
Check out the strategy-pattern, and combine that with this[^].
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
How can I find control in Public Shared Sub?
|
|
|
|
|
You seem to be missing something there. What control? What technology stack?
|
|
|
|
|
I have
Public Shared Sub DeletePlanDates(ByVal strTerm As String)
..some actions
With myGridView
End with
End Sub
I would like to refresh myGridView however I can't
|
|
|
|
|
You could pass the Control as a parameter to the method...
BTW: when people ask for clarification, they expect some answers.
|
|
|
|
|
Public shared method called from Web.Services.WebMethod. How do I pass my control?
<system.web.services.webmethod()> _
Public Shared Sub DeleteDates(ByVal args As String)
DeletePlanDates(args)
End Sub
Public Shared Sub DeletePlanDates(ByVal strTerm As String)
end sub
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
