Drive Info - C# Discussion Boards

DKalepu8-Jul-07 2:55

8-Jul-07 2:55

well, i did debug using break point.. Actually, it is executing the code step by step but at the end of the debugging a message box displayed "syntax error in UPDATE statement" ..

Re: Update Query in MS Access

Muhammad Gouda8-Jul-07 3:02

Muhammad Gouda

8-Jul-07 3:02

string strQuery = "update UserInfo set Password = '"+ txtNewPwd.Text +"' where Password = '"+ txtOldPwd.Text +"'";

In the aove string you need to take space before WHERE
Note that 'where is COMPLETELY different from ' where
This missed space makes the error

Mohamed Gouda
Egypt

Re: Update Query in MS Access

DKalepu8-Jul-07 3:38

DKalepu

8-Jul-07 3:38

there is space b/w ' & WHERE........

Confused | :confused:

Re: Update Query in MS Access

Robert Rohde8-Jul-07 6:00

Robert Rohde

8-Jul-07 6:00

It might be that Password is a keyword in Access try:
string strQuery = "update UserInfo set \"Password\" = '"+ txtNewPwd.Text +"' where \"Password\" = '"+ txtOldPwd.Text +"'";

Robert

Re: Update Query in MS Access

DKalepu8-Jul-07 19:17

DKalepu

8-Jul-07 19:17

Hi, thanks for the help!
yes, Password is a keyword in Access. I have changed it to "pwd" & it worked very well....... Thanks!

interesting

sarvenaz847-Jul-07 21:27

sarvenaz84

7-Jul-07 21:27

Hie.I'm looking for a control in c# that can be a suitable viewer for GISMAP projects. Would you please help me?

sarv

Re: interesting

mav.northwind7-Jul-07 22:11

mav.northwind

7-Jul-07 22:11

Hi! What are GISMAP projects?

Regards,
mav

--
Black holes are the places where God divided by 0...

Drive Info

shir17-Jul-07 20:28

shir1

7-Jul-07 20:28

Hi, How can i get drive info(free/used space) in vs 2003?
(in vs 2005 there's the DriveInfo class)
thanks.

sh

Re: Drive Info

mav.northwind7-Jul-07 21:35

mav.northwind

7-Jul-07 21:35

Hi!
You can p/invoke GetDiskFreeSpaceEx to get this information.
Because GetDiskFreeSpaceEx returns ULARGE_INTEGERs, your p/invoke declaration should contain out long for these parameters.

Regards,
mav

--
Black holes are the places where God divided by 0...

Re: Drive Info

Big Daddy Farang31-Aug-07 9:17

Big Daddy Farang

31-Aug-07 9:17

Hello,

Yesterday I was trying to do the same thing and I found your post. Here is a solution I found:

<br />
System.Management.ManagementObject disk = new System.Management.ManagementObject("win32_logicaldisk.deviceid=\"c:\"");<br />
System.Management.PropertyData freeSpace = disk.Properties["FreeSpace"];<br />
Console.WriteLine("Free space on C: drive is: {0}", freeSpace.Value.ToString());<br />

You'll need to add a reference to System.Management to your project.

In this code snippet, freeSpace.Value will contain the amount of free space in bytes as a decimal number.

BDF

Different Types of SInks in .NET Remoting

Phanindra Kumar7-Jul-07 20:15

Phanindra Kumar

7-Jul-07 20:15

Can any one give me a brief description about what envoy sink, server context sink and object context sink does in .NET Remoting ?

Thanks in Advance

Phanindra...

need C# code

farthi7-Jul-07 18:21

farthi

7-Jul-07 18:21

using C#,searching data from the database by using key and print that information

(this database very big.)

Re: need C# code

Sathesh Sakthivel7-Jul-07 19:08

Sathesh Sakthivel

7-Jul-07 19:08

we can't do your work.

What you have done for this so for?

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Saving credentials to the database

Shriniwasan Viswanathan7-Jul-07 16:52

Shriniwasan Viswanathan

7-Jul-07 16:52

Is there any way to save the user's credentials to the database and re-use them?

I wanted to run all the threads and web-service calls as background processes using user's credentials.

I have tried to searilizing user's default credentials and it looks like that is not possible.

Is there any other options?

Please adivice,
Shrini Viswanathan

Re: Saving credentials to the database

WillemM7-Jul-07 23:43

WillemM

7-Jul-07 23:43

There is a way to pass the user credentials from a frontend application to a backend webservice. Even with the webservice using threads.

You only need to make sure that the webservice and the front-end work with the same credential store (Active directory) and that they use Security Impersonation. The front-end will impersonate the user that logs on to the application and use those credentials to access the webservice. If you enable impersonation on the service as well, you will have the same credentials there that can access resources.

You might want to lookup the documentation on the subject as I don't remember exactly which setting it was in web.config to enable the Security impersonation. Also you need to make sure that the web application(s) run as local system, otherwise impersonation doesn't work on windows 2003.

WM.

What about weapons of mass-construction?
"What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson
My blog

read a database into a dataset then display it in a DGV

crash8937-Jul-07 16:48

crash893

7-Jul-07 16:48

hi all

I have been searching around but i havent found anything that JUST does what i need.

does anyone know a good link to a site that would show me how to connect to a sql DB and let me populate a dataset and then fill a datagridview

the database is currently read only so i don't need to worry about writing back to the db.

thanks in advance

Crash

Re: read a database into a dataset then display it in a DGV

Not Active7-Jul-07 17:05

Not Active

7-Jul-07 17:05

Have you tried here[^]. There is a handy search function you can use.

only two letters away from being an asset

timer and threading?

Mir_As7-Jul-07 9:46

Mir_As

7-Jul-07 9:46

i start my timer than when timer is elapsed i want to change my sliderbars value in
private void timer1_elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
slider1.value=100; //i get error message in this line about threading and debug s broken.how can i solve it?
}

Re: timer and threading?

Luc Pattyn7-Jul-07 9:52

Luc Pattyn

7-Jul-07 9:52

Hi,

you must be more specific:
- what kind of timer, there are at least three different Timer classes in CLR
- what Exception

My best guess is you are NOT using a Forms.Timer hence your timer is accessing
a Control from within a thread that did not create said Control, hence resulting
in an InvalidOperationException. If this suits your case, read up on
Control.InvokeRequired and Control.Invoke()

Smile | :)

Luc Pattyn

try { [Search CodeProject Articles] [Search CodeProject Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: timer and threading?

Mir_As7-Jul-07 10:16

Mir_As

7-Jul-07 10:16

i get this message when i try to set sliderbar s value.System.InvalidOperationException.i used "using System.window.threading; "

i think i must break timer s threading than slider bar s valur could be changed.

Re: timer and threading?

Luc Pattyn7-Jul-07 10:36

Luc Pattyn

7-Jul-07 10:36

So you have confirmed my assumption. You must:
either switch to a Forms.Timer
or call myControl.Invoke() instead of directly trying to change the Control
(read up on Invoke !).

Smile | :)

Luc Pattyn

try { [Search CodeProject Articles] [Search CodeProject Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: timer and threading?

Mir_As7-Jul-07 11:08

Mir_As

7-Jul-07 11:08

please can you write code?i tried to write but i couldnt do it.

Re: timer and threading?

Luc Pattyn7-Jul-07 11:17

Luc Pattyn

7-Jul-07 11:17

Hi,

I'm not going to do your work.

Did you try a Forms.Timer ? if not, why not ?
Did you read the MSDN documentation on your current timer ? and Forms.Timer ?

Did you try to call Invoke ? if so, show the code, and explain what happened.
If not, why not ? Did you at least search CodeProject for InvokeRequired/Invoke ?
and read an article about them ?

Smile | :)

Luc Pattyn

try { [Search CodeProject Articles] [Search CodeProject Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: timer and threading?

Mir_As7-Jul-07 11:35

Mir_As

7-Jul-07 11:35

ok i have done it now.thanks all of so much good night

Re: timer and threading?

Giorgi Dalakishvili7-Jul-07 10:02

Giorgi Dalakishvili

7-Jul-07 10:02

If your timer is running in a thread that doesn't own slider then you need to call Invoke methods. Have a look at this: http://msdn.microsoft.com/msdnmag/issues/04/02/TimersinNET/

#region signature
my articles
#endregion

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.