|
Hi All,
In MS SQL 2000, How can I check any row of database has updated or not through update query. My basic problem is that, same user has logged on two different system when they login at same time. I want to restrict the second user for login with same name.
Regards
|
|
|
|
|
The better option is to maintain a user session table and put an entry in it when user loggs in.. Then while logging in you can check whether that particular user id is already made an entry in the table and restrict accordingly. Remember to delete this entry on a session end or logoff
|
|
|
|
|
Thanks for reply,
I have already done thats a way which you are suggested. It works perfectally in normal situation but when I login same user in two different system at same time, then the problem occurs. Both the system executes query at same time and retrives the same result from database. Thats the area where problem occurs.
|
|
|
|
|
You can use the database transactions properly to lock and allow only one user/transaction at a time. So the first user who get the access could login and the later will not. Since already one entry is there. 
|
|
|
|
|
Few questions:
- Are you using a single database (all connections go to the same database)?
- is the connection alive all the time the user is logged into the system?
|
|
|
|
|
- Yes, I am using a single database.
- No, Connection is open before the query execution and closes after query execution.
Thanks
|
|
|
|
|
I don't know much about it, as I never used it myself, but maybe you could use a trigger that stores the db and row name somewhere when it's being updated and check that later.
|
|
|
|
|
I am working in WindowsXP SP2. when am trying to connect through WBemTest its giving an error RPC server unavailable. I have checked RPC is running and firewall in my system and remote system are turned off. The 2 systems are under workgroup named 'WORKGROUP'. I have changed 'Control Panel>Administrative tools>Local Security Policy>Security Options>Network Access : sharing and security model for local accounts' to 'Classic - local users authenticate as themselves'. And again in Computer management's WMI control's property - CIMV2's security for 'everyone' Remote Enabled'.
Still am getting an error access denied when trying to access remote machine through my C#.net code. and getting RPC server unavailable in WBemTest.
Can any one help me for this...
Jiby
|
|
|
|
|
I am trying to display a list of reports from SSRS in a WebBrowser control in C# windows application.
I have added "http://localhost/reportserver/reportservice.asmx?wsdl" as the Web service reference.
The following code works perfectly with the above
try
{
ReportService.ReportingService rs = new ReportService.ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
rs.Url = "http://localhost/reportserver/reportservice.asmx";
ReportService.CatalogItem[] items = rs.ListChildren("/BaxterReports", true);
for (cnt = 0; cnt <= items.Length - 1; cnt++)
{
//MessageBox.Show(items[cnt].Name.ToString());
listBox1.Items.Add(items[cnt].Name.ToString());
}
}
When I try to do the same thing by adding the web service as a service reference, The code does not work.
For this statement:
ReportService.ReportingService rs = new ReportService.ReportingService();
I get error like "The type or namespace ReportingService does not exist"
I need to use a service reference only as i need to develop the app in 3.5
Any help would be greatly appreciated.
Thanks
S
|
|
|
|
|
In other words, you are trying to consume the SSRS web service as a WCF?
Calin
|
|
|
|
|
Yes... But how do i make the above code work when i am using WCF?
|
|
|
|
|
Hello all
I am facing a strange problem, i am writing an application to download
web page content into a excel file. The code snapshot is below
//WebClient dwSolClient = new WebClient();
//dwSolClient.DownloadFile("http://sunsolve.sun.com/ search/document.do?assetkey=1-66-201341-1", "C:\PatchGenarator\Solaris\Suppdata.xls");
//MessageBox.Show("Data downloaded succesfully.
Formatting of data and report generation will start.It may take
several minutes to complete based on the density of data.");
while with some other links it is working properly, i am unable to
find reason why this link cannot be downloaded.
Kindly help!!!!
Thanks
Shantanu
|
|
|
|
|
|
Hi
WebClient dwSolClient = new WebClient();
dwSolClient.DownloadFile("http://sunsolve.sun.com/search/document.do?assetkey=1-66-201341-1", DwnSuppFile);
MessageBox.Show("Data downloaded succesfully. Formatting of data and report generation will start.It may take several minutes to complete based on the density of data.");
i hope there was some copy paste problem. I am again posting the link
http://sunsolve.sun.com/search/document.do?assetkey=1-66-201341-1
thanks
|
|
|
|
|
|
Why?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Is it only the delete-key, or are other keys also not working? You might want to check various KeyUp and KeyDown events.
I are Draenei FireMage 
|
|
|
|
|
|
Prajeesh wrote: WHY?
I don't know, but I can give some suggestions - if you don't shout 
The <del>-key removes the character on the right of the text if there is no selection. This default behaviour may be overriden in the KeyUp and KeyDown-events. Put a return statement on the first line of those events to check whether they cause it.
I are out of Arcane Dust - No intellect bufs today 
|
|
|
|
|
|
Will it "do" if you skip the KeyUp-event? E.g., if you put a "return" on the first line of the event, does the <del>-key work?
There's an e.Handled that might eat your key
I are troll
|
|
|
|
|
|
In what event did you put this code? Can you post your "entire" KeyUp?
Prajeesh wrote: If I get the position I can remove the character.
You can get the position of the cursor by looking at the SelectionStart property. It will hold the location of the cursor in the text, whether there's a selection or not. Removing the character right to it might 'restore' the functionality.
I suggest that you try to "fix" the code instead of looking for a workaround
I are troll
|
|
|
|
|
|
Prajeesh wrote: EditClear.ShortcutKeys = Keys.Delete;
Does the <del>-key work again if you comment out this line?
I are troll
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
