|
See MSDN: Guid.ToString Method[^]
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
where must i add these methods ?
there is a specific location so when the application start these methods call automatically?
where i can to call them? in program file?
|
|
|
|
|
Wherever you normally put "generic" helper methods. I would call it once from my main form and save a static string with the whole connection string ready to rock'n'roll when you need to access the file.
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
I don't understand very well what i must do it so the user can make update thee queries to access database without problems when he already run my application program in his laptop
the actions that i have to do if i understand correctly is to add the following methods in program.cs
but i don't understand how i call ant save it with connection string
///
/// Get the Application Guid
///
public static Guid AppGuid
{
get
{
Assembly asm = Assembly.GetEntryAssembly();
object[] attr = (asm.GetCustomAttributes(typeof(GuidAttribute), true));
return new Guid((attr[0] as GuidAttribute).Value);
}
}
///
/// Get the current assembly Guid.
/// <remarks>
/// Note that the Assembly Guid is not necessarily the same as the
/// Application Guid - if this code is in a DLL, the Assembly Guid
/// will be the Guid for the DLL, not the active EXE file.
///
///
public static Guid AssemblyGuid
{
get
{
Assembly asm = Assembly.GetExecutingAssembly();
object[] attr = (asm.GetCustomAttributes(typeof(GuidAttribute), true));
return new Guid((attr[0] as GuidAttribute).Value);
}
}
///
/// Get the current user data folder
///
public static string UserDataFolder
{
get
{
Guid appGuid = AppGuid;
string folderBase = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData);
string dir = string.Format(@"{0}\{1}\", folderBase, appGuid.ToString("B").ToUpper());
return CheckDir(dir);
}
}
///
/// Get the current user roaming data folder
///
public static string UserRoamingDataFolder
{
get
{
Guid appGuid = AppGuid;
string folderBase = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
string dir = string.Format(@"{0}\{1}\", folderBase, appGuid.ToString("B").ToUpper());
return CheckDir(dir);
}
}
///
/// Get all users data folder
///
public static string AllUsersDataFolder
{
get
{
Guid appGuid = AppGuid;
string folderBase = Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData);
string dir = string.Format(@"{0}\{1}\", folderBase, appGuid.ToString("B").ToUpper());
return CheckDir(dir);
}
}
///
/// Check the specified folder, and create if it doesn't exist.
///
/// <param name="dir" />
/// <returns>
private static string CheckDir(string dir)
{
if (!Directory.Exists(dir))
{
Directory.CreateDirectory(dir);
}
return dir;
}
|
|
|
|
|
So try it on your computer in the debugger and see what happens. This is not rocket science! 
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
zebra88 wrote: What might be the problem?
The fact that Access isn't a database-server, but a client-application. It's not meant to serve multiple clients.
I'd suggest you hit the "Upgrade to SQL Server" button after opening the database in the Access-IDE. SQL Server Express is "free", and would be better suited for this particular task.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hey Every Body!
How do you do! I'm beginner of C# language. Now i want to save pdf file to sql and retrieve from there via C#. Someone could help me for this problem  .. Thanks for every thing
|
|
|
|
|
For my 2 cents worth.
There are many ways to solve this problem.
One way, is to store the actual pdf file on server some where, and maybe store the path to where this file is located on the server, in the database. You can select out the path information information from database and retrieve the file accordingly.
Another way, store the content in the database, and create the pdf on the fly when you retrieve the information from database.
Thanks.
|
|
|
|
|
Thanks friend!
I was thinking this way. But I have no idea "How do this method "Example--- How store pdf file to SQl.. and how retrieve pdf file to C#... You can teach me-- how write this
|
|
|
|
|
naylynn wrote: How do you do! I'm beginner of C# language
First step - learn basics of putting and getting stuff from the database.
And do not use a PDF when learning that. Instead use int and string.
AFTER you are comfortable with that then learn how to put and get a blob.
|
|
|
|
|
|
Hi
I'm looking for an implementation of ToObservable and ToEnumerable
can you pls help with this
thx
|
|
|
|
|
kaminem wrote: I'm looking for an implementation of ToObservable and ToEnumerable
That's a different statement than in the title.
Are you trying to convert an Observable to an Enumerable, or something else? Can you show us some code that shows what you want to convert?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
There is a simple (by MSDN's standards) of ToObservable here[^]. Likewise, in the opposite direction, here[^]
Note that these are really conversions (as opposed to casts): ToObservable takes the value from the IEnumerable on the basis of the IScheduler, whereas ToEnumerable produces the "list" from the Observable's updates.
“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”
Sir Thomas More (1478 – 1535)
|
|
|
|
|
This blog[^] might help you as well.
|
|
|
|
|
|
Is it possibe to display column A FROM TABLE 1 IN database ABC AND COLUMN B from table 2 of database XYZ IN a single gridview USING c# code...i got the column data in a datatable 1 and 2 respectively..joined them and assigned it to an object.Tried binding it but got "Make sure your datasource has content"...Can anyone help.Thanks in advance
|
|
|
|
|
JOIN the tables before loading them into a collection. You'll have two SQL statements now; paste 'em both, and we'll make a single statement of it. Prerequisite would be that you're using Sql Server (adding in the other DB as a linked database)
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Currently, I use IMAPI library to get the used space of DVD disc on Win7. The calculation is start when insert DVD (handle by WM_DEVICECHANGE window event).
However, with multi session disk (disk that is write many time without finalize), sometime it takes long time to get used space (double when comparing with Window Explorer).
I also investigated and found some other ways to get used space (use IOCTL_DISK_GET_DRIVE_GEOMETRY, IOCTL_SCSI_PASS_THROUGH_DIRECT). The calculating time is improved but result is different from Window result.
I also wonder there is any way that I can reuse the result of window (window also calculated the used space right after insert DVD) without re-calculating? Or any one else to calculate the used space?
Thank you for your interested and helping me.
|
|
|
|
|
WMI may come to your aid - check out the Win32_CDROMDrive class[^].
|
|
|
|
|
Can you explain more detail?
I search and found the way to get all properties from Win32_CDROMDrive. However, the capacity information of DVD Drive seems not to be retrieved.
|
|
|
|
|
Hey guys got a ? that I know is going to get a very objective answer, but here goes anyways. I'm deploying to Afghanistan soon, so I'll have some time at nights to read without interruption from the kids. I'm a beginner programmer, learning the basics of c#. Should I get a book on ASP.net MVC 4, or WFP 4.5? I'm down with learning both desktop development and web development.
Thanks for any input!
|
|
|
|
|
If you are wanting to learn the basics I'd get one of the "Learn C# in XX days" books, and then it really is a preference where you go from there. WPF has a lot of cool things you can do, but its only visible to those you send the executable to. ASP is a good skill to have and MVC can be translated to WPF when you get into that.
There isn't a "this is the one" answer, but if you are starting with basics then get basic books. Learning the back-end of a language before you work on the pretty front end will save you a lot of headaches later.
BTW, thanks for serving and stay safe out there.
|
|
|
|
|
Ron,
Thank you for your reply and safe wishes. I am no longer serving our country in the military though. I just separated from the US Navy, and am now going back out to Afghanistan to support the troops as a contractor.
I'm currently reading two books to learn the basics of C#, Rob Miles C# Yellow Pages and Pro C# 2012 and .NET 4.5
The Pro C# 2012 book has a section on WPF. How much information do I need on WPF to be able to put together a small program?
Thanks,
Jeramy
|
|
|
|
|
You really don't need much. WPF is XML with a .CS code behind. You can use the visual designer to make a form without writing any code at all, but it really gets more powerful if you hand code the XML. There are tools to help though, Microsoft Expression Blend can do some pretty bad-ass stuff without the need to hand code.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
