Re: Adding a total column to datagrid control - C# Discussion Boards

m@u19-Aug-07 4:44

19-Aug-07 4:44

ok.. the ping said "using tnsnames to resolve blah blah blah..." as far as i know these tools do not look at the sqlnet.ora. did you configure the naming methods (second option in the net configuration assistant)? default is only local. you must tell it to use tnsnames also.

Re: Oracle c# Question [modified]

udikantz19-Aug-07 4:56

udikantz

19-Aug-07 4:56

yea i did set the sqlnet.ora currently it looks like this:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

*MODIFY*:OK i FOUND A TEMPORARY SOLUTION!
i found out that you can set
Data Source="[hostname]/[servicename]"....

so i changed the code to DataSource="192.168.2.100/xe"
and i managed to connect via lan........ but still its anoying that i cant make that damn alias to work

THANKS FOR THE HELP!!!!

if you got any other ideas how to make it work i'll be glad to hear

thanks again
*

-- modified at 11:14 Sunday 19th August, 2007

-- modified at 11:19 Sunday 19th August, 2007

Net

Day of week

justintimberlake18-Aug-07 19:33

justintimberlake

18-Aug-07 19:33

how can i find which day of week today is.
i.e if today is Sunday then it should return 1
the problem is if it returns day of week in another language
for e.g in German they call Sunday as sonntag.

Re: Day of week

Hessam Jalali18-Aug-07 20:23

Hessam Jalali

18-Aug-07 20:23

As far as I know all calenders in System.Globalization returns DayOfWeek property as a DayOfWeek Enumaration So no language would affect it.

and casting the DayOfWeek to integer gives something like this

Sunday=0,Monday=1,...,Saturday=6

int dayNum=(int)DateTime.Now.DayOfWeek+1;

good luck

How to close XP AutoPlay Dialog

Barry Etter18-Aug-07 9:50

Barry Etter

18-Aug-07 9:50

I have a C# service that communicates to a USB flash drive. Since my program is smart enough to know when the drive is plugged in and when it's not, I don't need to have XP open the "Autorun" dialog window asking me what application to run when the drive is plugged in.

Can I somehow kill this window from my C# app? I would like to do it this way because if my application is NOT running, I DO want the XP autorun dialog to display giving users the option to install the application.

Any advice would be appreciated!

Thanks,
Barry

Barry Etter

Re: How to close XP AutoPlay Dialog

Hessam Jalali18-Aug-07 19:59

Hessam Jalali

18-Aug-07 19:59

You can disable it through registry

    const int DISABLEALL = 0xff;
    const int DISABLEALLEXECPTCDROMS = 0xdd;
    const int DISABLECDROM = 0xb1;

    RegistryKey key = Registry.CurrentUser.OpenSubKey("Software").OpenSubKey("Microsoft").OpenSubKey("Windows").OpenSubKey("CurrentVersion").OpenSubKey("Policies").OpenSubKey("Explorer", true);

    key.SetValue("NoDriveTypeAutoRun", DISABLEALLEXECPTCDROMS);
}

code for disable AutoRun for all devices is 0xff

and disable AutoRun for all devices except CD-Roms is 0xdd

disable just for CD-Roms is 0xb1

and the changes would be applied after restart

Good Luck

Adding a total column to datagrid control

Muammar©18-Aug-07 9:27

Muammar©

18-Aug-07 9:27

Good evening everyone,
As the subject says, I wonder if there's a possibility to add a column to a datagrid control that calculates (count, sum, or average) multiple columns or rows..
Please advise Rose | [Rose]

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Adding a total column to datagrid control

Not Active18-Aug-07 10:18

Not Active

18-Aug-07 10:18

You have complete control over the datagrid, so yes, there is a way to add a totals column.

One way would be to add it to your query.

SELECT field1, field2, SUM(field3) FROM...

Another way would be to handle the databinding events and populate the column at runtime.

only two letters away from being an asset

Re: Adding a total column to datagrid control

Muammar©18-Aug-07 20:24

Muammar©

18-Aug-07 20:24

Mark Nischalke wrote:

SELECT field1, field2, SUM(field3) FROM...

Call me an idiot but tell me this's not creating me a totals row (not column) Confused | :confused:

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Adding a total column to datagrid control

Not Active19-Aug-07 4:57

Not Active

19-Aug-07 4:57

If you had a table with this structure

col1 col2
1 2
10 20
20 30

then SELECT col1, col2, SUM(col1,col2)...

would produce this:
1,2,3
10,20,30
20,30,50

Of course this only gives you the totals for the rows selected. If you want some other sort of total, then adjust the SQL statement, maybe MAX, or AVE, or whatever is needed.

only two letters away from being an asset

Re: Adding a total column to datagrid control

Urs Enzler19-Aug-07 0:53

Urs Enzler

19-Aug-07 0:53

If you are using a DataSet as data source then you can add an expression column to it.

-^-^-^-^-^-
no risk no funk ................... please vote ------>

(System.NotSupportedException: No devices of the category ) error in running sample code of directx,capture class library

kapiltheripper18-Aug-07 8:42

kapiltheripper

18-Aug-07 8:42

hi all,
iam working on directx.capture class library, iam not able to run the sample code included in the zip file. i get the above error at

private Filters filters = new Filters();

please somebody help me with this. iam using vs2005 express edition

Thanks in advance

How do I Encrypt Connection String Password in C# Windows Application

Hadi638418-Aug-07 8:25

Hadi6384

18-Aug-07 8:25

Hi
I have this Sql Authentication connection string which has a username and password.
I added this connection string to Application Settings and the corresponding app.config item
was added to my project automatically. But now that i want to access the app.config file
in my codes,ConfigurationSection,ConfigurationManager and other related classes,properties and methods
are not available.I read many articles on this subject but i havent been able to do the encryption so far.
The other question is wether the encryption needs to be done once or should it be done every time
the application runs? Is it be possible to set this encrypted connection as a SqlConnection's connection
string or the assignment must be done prior to encryption?

please help!

thanks

Re: How do I Encrypt Connection String Password in C# Windows Application

karle18-Aug-07 9:04

karle

18-Aug-07 9:04

try this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2010907&SiteID=1&pageid=0#2010907

Native docking in Winforms MDI app?

Ravi Bhavnani18-Aug-07 7:27

Ravi Bhavnani

18-Aug-07 7:27

I have a WinForms MDI app that has a docked navigation panel at the left edge. However, when I create MDI child windows, the main window seems to ignore the presence of the navigation panel and uses its entire client area to layout the child windows. Is it possible to override the MDI container's layout logic and reduce its client area by the space occupied by the navigation panel?

I tried doing this in the main window's Load handler, but it didn't seem to have any effect. (I understand that this would only set the initial client area, which may need to be recomputed in a SizeChanged handler).

private void MainFrm_Load
  (object sender,
   EventArgs e)
{
   // Nav panel test
   NavigatorFrm nf = new NavigatorFrm();
   nf.MdiParent = this;
   nf.Dock = DockStyle.Left;
   nf.Show();
   this.ClientSize = new Size (this.ClientSize.Width - nf.Width, this.ClientSize.Height);
}

Thanks,

/ravi

This is your brain on Celcius
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Re: Native docking in Winforms MDI app?

martin_hughes19-Aug-07 4:07

martin_hughes

19-Aug-07 4:07

If you get an answer to this, I'd be interested to find out how to do it.

"It was the day before today.... I remember it like it was yesterday."

-Moleman

Re: Native docking in Winforms MDI app?

Mathew Jibin5-Sep-10 1:57

Mathew Jibin

5-Sep-10 1:57

If still anyone is looking for this, just override the control's DisplayRectangle property. Just mentioned as I was looking for the same till a few days ago.

Description popup box

ddabble18-Aug-07 5:52

ddabble

18-Aug-07 5:52

Hi,

I want to display a description of the item being hovered over, how would i do this please.

Re: Description popup box

martin_hughes18-Aug-07 5:55

martin_hughes

18-Aug-07 5:55

Use a tooltip.

"It was the day before today.... I remember it like it was yesterday."

-Moleman

Re: Description popup box

Muammar©

18-Aug-07 9:36

Or a balloon

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Description popup box

Paul Conrad18-Aug-07 10:16

Paul Conrad

18-Aug-07 10:16

That is a nice article you linked to. I am wondering why it was voted down a bit... It may be an older article from 2002, but the information looks still useful.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Gamserver Query Library

wannabeuk18-Aug-07 3:37

wannabeuk

18-Aug-07 3:37

Hello,

Has anyone got an upto date and working version of a gamequery library?

i have attempted to fix the one located at http://www.codeproject.com/csharp/gameserverinfo.asp?df=100&forumid=128181&exp=1&mpp=50&select=2186981&msg=2186981

However the skill needed is beyond me, and i have recived no e-mail from the original writer.

So anyone able to assist me?
Cheers

display the machine time in a textbox

costavo18-Aug-07 3:01

costavo

18-Aug-07 3:01

hi,
I want to display the time and date in a textbox using c# where i should put the formula and how
regards

Re: display the machine time in a textbox

N a r e s h P a t e l18-Aug-07 3:19

N a r e s h P a t e l

18-Aug-07 3:19