Comments by s#@!k (Top 50 by date)

hope you may need to show in UI/any as you specified pattern.
In sql server u can't get this type of result set because in emp_id column for the second record
what will be the expected value in your pattern.

where do you want to save? is it different table!, and specify your schema

it means if the UU.FIRSTNAME + ' '+ UU.LASTNAME value is null isnull return '' value means empty.
google for the difference between dbnull=NULL and ''.

Thank you

your question is not clear, you can improve your question and provide some code what you have tried.

hi, check the updated solution
I think there is no subquery, you can replace your variable in the hard coded string.
or you will get some idea for your solution.

Using entity framework you can't do the manipulation, if the table doesn't have primary key.

can you specify in which line your are getting the exception.Your error says some object your going to use was killed before using.

he just wanted to convert foreach to for loop,it is a sample idea for him.

lstboxSkill.SelectedItem is a single item.It is causing problem use
lstboxSkill.Items is collection.

use UNION and remove distinct.

> Open new console application(name don't change) in new Visual studio solution.
> Add service reference to your project by right clicking on references name(DirectoryServiceReference).
> Add namespance top of your class like "using ConsoleApplication1.DirectoryServiceReference;"
> under main method copy and past the same
// Object creation for service.
DirectoryServiceClient serviceRef = new DirectoryServiceClient();

//Object creation for request with userid and password.
AuthenticateRequest requestRef = new AuthenticateRequest();
requestRef.UserName = "abcd";
requestRef.Password = "*******";

//Authentication againest your service with your user id and password
AuthenticateResponse response = serviceRef.Authenticate(requestRef);

// if true authorized else unauthorized.
bool isValidUser = response.Success;

if (isValidUser)
{
// Valid User.
}
else
{
//please check user name or password.
}

Console.Write(isValidUser.ToString());
Console.ReadKey();
// check this once for error
//http://social.msdn.microsoft.com/Forums/en-US/f619be77-2ce2-4912-b28f-7b1ab75fc79e/unable-to-automatically-step-into-the-server-connecting-to-the-server-machine-ipaddress-failed?forum=asmxandxml

I tried the same is working for me. Check once the service reference. if possible give dummy user id and password.I will check once with your service.

check for the below solution for your service.
add namespace top of your class then only this will work for you.

> Create the object for the service.
> Check for the authenticate method and its signature in the service.
> Pass the parameters what are expecting the service method and verify the return value for success.

Try like this..
select * from(
With DEDUPE AS (
select title.title_id,
edition.title,
party.party_id,
party_type_code,
(party.title + ' ' + party.first_name+' '+party.surname) as name,
ISNULL(party.affiliation,'') as affiliation ,
ISNULL(contact_address.email,'') as email ,
ISNULL(party.subject_codes,'') as subject_codes,
ISNULL(title.primary_subject_code,'') as primary_subject_code,
ISNULL(peer_review.comments,'') as comments,
ISNULL(edition.product_author_name,'') as author,
ISNULL(division_groups.division_group_desc,'')as division_group_desc
,ROW_NUMBER() OVER ( PARTITION BY party.party_id,edition.title_id ORDER BY edition.title_id) AS OCCURENCE
From Party
join contact_address on contact_address.party_id=party.party_id
join role on party.party_id = role.party_id and role.role_type='PEREV'
join edition on role.object_id=edition.title_id
join title_subject_code on title_subject_code.title_id=edition.title_id
join subject_code on subject_code.subject_code=title_subject_code.subject_code
join title on title.title_id=edition.title_id
join division_groups on edition.product_code=division_groups.product_code
Join dbo.staff_role on staff_role.object_id=edition.title_id and staff_role_type='COMMED'
JOIN dbo.Staff ON Staff.Staff_Id=staff_role.Staff_Id
JOIN peer_review on peer_review.title_id=title.title_id
where division_group_desc= 'Humanities'
)Select * from DEDUPE where OCCURENCE=1 order by party_id) temp_table --title_id,party_id
group by temp_table.name,temp_table.title

use separate register tags for each user control and place dropdowns in update panel in usercontrol.
check for (!ispostback){//your first dropdown bind}
write separate private method for binding dropdown and call relevant method in each drpodown selection change event.

keep all the dropdowns in update panel.

no yet solved error TNS-12535: TNS:operation timed out.I think TNS setup has to be done by the people who know the things clearly.. right? and it is develpment server some other sites also hosted. if i change something it might effect others..Please advise the same

Thank you so much raja but one more thing i forgot, i checked datasources(ODBC) no driver were installed other than sqlserver.I am using odp.net dll(Oracle.DataAccess.dll) only i think nothing installed at server mechine.

Thank you for your quick responses..
I copied the same sqlnet.ora file from local to devserver. Is there any chance restrict particular ip address. As seeing round-trip i think it is not able to connect host.do u has any other analysis.
And connect from IIS(hosted wcf service on IIS) is any other permissions needed?

I tried the same but not resolved even i am very new to this environment.did u see the approximate round trip time, I didn't get that all zeros.Is it able to ping the host or not

Thank you so much for your response..
under one solution i added wcf application project and i added asp.net project also.I added service reference to the asp.net application from the wcf project.

Thanks for your quick response.I tried below solution and able to authenticate user.Please check the code snippet and welcome with your concerns..

yes, I got but m getting "The server is not operational" Exception.

Thank you for your replay.In That reference there is no Validate user method.While entering into the link it is asking for credentials then I can able to see wsdl file.

Thank you so much

Thank you so much..

Please have a look on the table structure and reply back any

please have a look on the query and reply back.

Install OS in different folder(if your previous OS is in C: then do install in D:) then you can get your data safely(don't format all drives).

add in the dropdown list binding method top.
ddl.items.clear();

Thank you so much.Please find the table structure.(id(number(PK)),item_code(varchar),item_desc(varchar),1_code(varchar),1_desc(varchar),2_code(varchar),2_desc(varchar),3_code(varchar),3_desc(varchar),4_code(varchar),4_desc(varchar),5_code(varchar),5_desc(varchar));
My query need to return id,item_code,item_desc in 5 cases like..
where 1_code=1_code_in;where 1_code=1_code_in and 2_code=2_code_in,;where 1_code=1_code_in and 2_code=2_code_in and 3_code=3_code_in,; till 5_code..(hope you ppl got clear idea)

It seems your procedure returning two result sets.check once by filling dataset there you can see the number of result sets from database to your code.

Thank you so much for your response idle63,Jorgen Andersson and thatraja.It is a data ware house i can't force them to change the column definitions and hope that would n't be happen.Please welcome any other solutions.Your responses are more valuable for me..

I don't know do i create index on varchar2(100) type column which has 6 lacks records.Do i create it in procedure?

yes delete your list first if you want to update database.do compare and update in database.or make copy of your list before updating compare it.

delete data form the list(what you are binding to the datagird)

do group by you will all distinct record set.

not clear do some more explanation total how many records you want from the result set and in which way.

Thank you for your solution.Please have a look on this.http://www.codeproject.com/Questions/690441/oracle-11g-proc-for-accepting-collection-throw-csh

Thank you for your replay.Let me explain clearly..
I have 5 dependent dropdowns(from the first one selected dependent items will load second and the same for the remaining),for each drop down corresponding items will load in right side listbox,I will select some items in the listbox and move to another listbox finally i will send the items for the updation.
(Actually for list box items collection i am filtering dropdowns).hope you got clear idea.

Thank you for your response.But I am binding dropdowns.

Thank you so much for your response. But if I need to update 100 records it is going to hit db 100 times form C# code ha.So I concatenated all int types separated by "|" and made it as string passing input parameter as oledbtype.varchar. I declared varchar2 in procedure as in parameter and in procedure updated by splitting as individual items. Please update any upcoming issues with this solution.