|
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
|
|
|
|
|
|
A nice workaround
It could very well be that one of the buttons on the form has the <del> key set as a shortcut. That could eat the key, I suppose.
Happy Programming!
I are troll
|
|
|
|
|
I am comparing data fields, and setting values where differences occur like so:
foreach (DebtorDataSet.DebtorRow row in debtorDataSet.Debtor.Rows)
{
if (row.CorrespondenceSource == "D" || row.CorrespondenceSource == "J")
{
if (row.HouseName != row.CorrespondenceHouseName)
{
row.CorrespondenceHouseName = row.HouseName;
}
if (row.NoStreet != row.CorrespondenceNoStreet)
{
row.CorrespondenceNoStreet = row.NoStreet;
}
}
}
but I am getting an error due to underlying data being DBnull.
Elsewhere in my project I use a helper class for such situations:
public static object getDefaultIfDBNull(object obj, TypeCode typeCode)
{
if (obj == DBNull.Value)
{
switch (typeCode)
{
case TypeCode.Int32:
obj = 0;
break;
case TypeCode.Double:
obj = 0;
break;
case TypeCode.String:
obj = "";
break;
case TypeCode.Boolean:
obj = false;
break;
case TypeCode.DateTime:
obj = new DateTime();
break;
default:
break;
}
}
return obj;
}
but the values don't get a chance to be passed to the helper class if I try to use something like:
if (getDefaultIfDBNull(DebtorDataSet.Debtor[0].SolicitorBuilding, TypeCode.String) != getDefaultIfDBNull(row.CorrespondenceHouseName,TypeCode.String))
{
row.CorrespondenceHouseName = DebtorDataSet.Debtor[0].SolicitorBuilding.ToString();
}
How can I correctly accommodate when underlying data is DBnull, via code, please?
|
|
|
|
|
I fixed it with a syntax change so:
if (getDefaultIfDBNull(row["PostTown"], TypeCode.String) != getDefaultIfDBNull(row["CorrespondencePostTown"], TypeCode.String))
{
row.CorrespondencePostTown = row.PostTown;
}
|
|
|
|