Active directory working with sql server

Question

I have a c#.net 2008 desktop application that I need to add logic to authenicate who the user is. I am going to use windows authenication to connect to the active directory to verify the right of each person by group. Thus I have the following question for a desktop application;
1. Do you know of a reference of that has a desktop form accessing the active directory? The only one I know about is an asp.net applcation accessing the active directory.
2. In this application, I would like the windows desktop application to pass the authenication(active directory) information to sql server 2008 r2 by either user or by group.
Thus I am wondering if you can point me to some references (links and/or urls) i can use to accomplish these tasks or part of these tasks.

Answer 1

Dang! We're this close! =)

Good luck on your future projects.

Answer 2

Jan, thank you for the offer to help, but the problem has been reassigned.

Thanks anyway.

Chuck

Answer 3

I could not really tell without more details.

Please post some code especially those related to the gridview.

Could you also post the stack trace of the error? that stack trace would really help in solving your problem

Answer 4

I changed the Int32 to Double. That worked. Thank you.

But, now in the SAVE routine, I'm getting the same error. My code is:

 if (Convert.ToString(gridData.Rows[i - 1][Convert.ToInt32(BillDivColumns.modesal)]) == "H") SaveInput.BILLING_DIV_MEMBER_SET_LIST[i - 1].A_SAL_CNS = Convert.ToInt32(gridData.Rows[i - 1][Convert.ToInt32(BillDivColumns.salary)]) * 100;

I assume the Int32 is causing the problem again. How should this be handled?

 

Answer 5

The problem is with the Convert.ToInt32 function call.

int value / 100 will return an integer value.

that is why 785/100 will return 7 for you instead of 7.85.

replace the Convert.ToInt32 with Convert.ToDouble instead.

Answer 6

No, not currency. I would like the format of  INT 785 to display as 7.85

However, I don't know if this display issue is the cause of the error msg. Do you know?

Thank you.

Answer 7

do you want to format your column as currency?