Google Helps

is there any pivot table kind of control in asp.net / vb.net

try using LDAP authentication. refer google for LDAP source.

i have a folder that shall NOT be allowed to be accessed directly. that shall be accessed only through my ASP.NET application. please tell me how can i do that. thanks

dear friend, that will not help me. my actual task is to query a dataset based on results from a different dataset.

hi, i have executed a query and got the resultant data into a DataSet. now i need to further filter this data based on a condition. i dont want to run a query again and create a seperate dataset for this task. can you please tell how to run a query on this dataset itself? thanks

hi, i am having 2 tables (SQL 2000) on 2 different servers (windows 2003 server). now i have to run some inner join on both the tables. i tried by giving select * from servername1.databasename.dbo.tablename kind of statements in the servername2. but it throws errors. kindly suggest. thanks

hi, i wrote one vb.net service which checks for a set of conditions. if the condition fails, it gives a warning to the user asking him to fulfil the conditions within 30 minutes, failing which he will be forcebly logged off. after 30 mins, it checks taht condition again & does accordingly. (i used a msgbox to give that warning to the user). it works well & good if he responds to the msgbox by clicking on it. if he doesn't respond at all, it throws an error saying that service cannot run & stops abruptly. i guess it is waiting for the user's response for that msgbox. i am thinking of two options: some other way (popup kind) to give warning to the user instaed of msgbox start a separate thread for this kind of messages i will be thankful for some light on these issues & a better solution.

Dear friends, thanks for the timely help.

i have to check for a particular condition, and if the user doesnt satisfy that condition, i need to logoff him forcibly. (OS: WindowsXP and Win2K) obviously i have to use a windows service, but i couldnt figure out the code to loghim off. can anyone please help

dear friend, i want to get the user's loginid in to my VB / ASP applications. can anyone please help. you may please throw some light on various ways of getting this info. we are having Windows server 2003 domain and as soon as a user logs into the domain using Windows Authentication, i want to run a service to get his loginid & proceed with other tasks. thanks

hi, i want to get the user's loginid in to my VB / ASP applications. can anyone please help. you may please throw some light on various ways of getting this info.

SQL Trigger not working on update statement hi i am having a table with 3 columns (a,b,c). i have written a trigger for INSERT / UPDATE as c=a+b this is working fine as long as i enter/update each row by row manually. but, when i use any update statement for a set of rows, the trigger is firing only for the last row. can anyone please help? Thanks

hi i am having a table with 3 columns (a,b,c). i have written a trigger for INSERT / UPDATE as c=a+b this is working fine as long as i enter/update each row by row manually. but, when i use any update statement for a set of rows, the trigger is firing only for the last row. can anyone please help? Thanks

Hi, I found that the Log file of my database has grown too fat. as i want to save some of the resources, i am thinking of deleting it. but i think such a direct deletion will hamper my database. can you please tell me how to DELETE / REDUCE the size of that log file. also, throw some light on how to read database log files. Thanking You. BSRK

The above problem i am facing in SQL Query Analyser .

Hi, i am having a stored procedure like this: CREATE PROCEDURE SP1 @arg1 varchar(100) select * from emp where empid in (@arg1) the argument @arg1 will depend on the user's choice in the front end. An example of this argument may look like this: 'emp1','emp2','emp6' My problem is "I am unable to pass this type of argument for executing the stored procedure" Please help. Thank You. Please Plant Trees to Save the Mother Earth.

here is my problem, please help. I am having 2 databases namely employees and projects. employees database contains a table emp (with fields like empname, etc). projects database contains a table prj (with fields like prjname, prj_leader, etc). but i want to ensure that ALL the prj_leader entries MUST be existing empnames of emp table in employees database. i know that if both the tables are in the same database, it is simple. but i have no idea whether we can set such foreign key constraints across databases. kindly suggest.

hi, I have installed MSDE (sql2kdesksp3.exe) in my PC by following the guidelines given in Lars article http://www.codeproject.com/database/ConfigureMSDE.asp[^] but when i tried to connect using osql (C:\> osql –E –S localhost\myinstance), it is giving the following error: "Server does not exist or access denied". i dont have any idea what's wrong? i could see that the service is running. i am running on a dual boot with Linux and Windows 2000 professional. I installed it in Administrator login only without any password. Can you please help?

I think we cannot use MSDE & Enterprise Manager in conjunction. i got similar info from the below link. http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?&query=FAQ&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.msde&p=1&tid=2b4fe8b6-3d8d-4353-8f91-31c0f60bba14[^]