C# Discussion Boards - CodeProject

Re: How can I check any row of database has updated or not through update query

S a n d y26-Feb-09 0:37

26-Feb-09 0:37

- Yes, I am using a single database.
- No, Connection is open before the query execution and closes after query execution.

Thanks

Re: How can I check any row of database has updated or not through update query

Megidolaon25-Feb-09 22:10

Megidolaon

25-Feb-09 22:10

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.

Remote Access Error

mightygirls24-Feb-09 23:16

mightygirls

24-Feb-09 23:16

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

Displaying list of SSRS reports in C#.net windows application using a service reference

sudip67824-Feb-09 23:02

sudip678

24-Feb-09 23:02

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

Re: Displaying list of SSRS reports in C#.net windows application using a service reference

Calin Tatar25-Feb-09 0:13

Calin Tatar

25-Feb-09 0:13

In other words, you are trying to consume the SSRS web service as a WCF?

Calin

Re: Displaying list of SSRS reports in C#.net windows application using a service reference

sudip67825-Feb-09 0:18

sudip678

25-Feb-09 0:18

Yes... But how do i make the above code work when i am using WCF?

Unable to Download file Options

shantanusenin24-Feb-09 22:56

shantanusenin

24-Feb-09 22:56

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

Re: Unable to Download file Options

Calin Tatar24-Feb-09 23:03

Calin Tatar

24-Feb-09 23:03

If you navigate to http://sunsolve.sun.com/%20search/document.do?assetkey=1-66-201341-1[^], you'll see that the resource cannot be found.

Calin

Re: Unable to Download file Options

shantanusenin24-Feb-09 23:11

shantanusenin

24-Feb-09 23:11

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

[Message Deleted]

Prajeesh24-Feb-09 22:32

Prajeesh

24-Feb-09 22:32

[Message Deleted]

Re: Delete in Richtextbox?

Expert Coming24-Feb-09 22:33

Expert Coming

24-Feb-09 22:33

Why?

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: Delete in Richtextbox?

Eddy Vluggen24-Feb-09 22:51

Eddy Vluggen

24-Feb-09 22:51

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 WTF | :WTF:

[Message Deleted]

Prajeesh24-Feb-09 22:55

Prajeesh

24-Feb-09 22:55

[Message Deleted]

Re: Delete in Richtextbox?

Eddy Vluggen24-Feb-09 23:07

Eddy Vluggen

24-Feb-09 23:07

Prajeesh wrote:
WHY?

I don't know, but I can give some suggestions - if you don't shout Smile | :)

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 Frown | :(

[Message Deleted]

Prajeesh24-Feb-09 23:28

Prajeesh

24-Feb-09 23:28

[Message Deleted]

Re: Delete in Richtextbox?

Eddy Vluggen24-Feb-09 23:35

Eddy Vluggen

24-Feb-09 23:35

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 Frown | :(

I are troll Smile | :)

[Message Deleted]

Prajeesh24-Feb-09 23:47

Prajeesh

24-Feb-09 23:47

[Message Deleted]

Re: Delete in Richtextbox?

Eddy Vluggen25-Feb-09 0:11

Eddy Vluggen

25-Feb-09 0:11

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 Smile | :)

I are troll Smile | :)

[Message Deleted]

Prajeesh25-Feb-09 0:23

Prajeesh

25-Feb-09 0:23

[Message Deleted]

Re: Delete in Richtextbox?

Eddy Vluggen25-Feb-09 1:06

Eddy Vluggen

25-Feb-09 1:06

Prajeesh wrote:
EditClear.ShortcutKeys = Keys.Delete;

Does the <del>-key work again if you comment out this line?

I are troll Smile | :)

[Message Deleted]

Prajeesh26-Feb-09 16:39

Prajeesh

26-Feb-09 16:39

[Message Deleted]

Re: Delete in Richtextbox?

Eddy Vluggen26-Feb-09 21:06

Eddy Vluggen

26-Feb-09 21:06

A nice workaround Smile | :)

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 Smile | :)

Stront typing error

kanchoette24-Feb-09 22:17

kanchoette

24-Feb-09 22:17

I am comparing data fields, and setting values where differences occur like so:

foreach (DebtorDataSet.DebtorRow row in debtorDataSet.Debtor.Rows)
  {
  // ----- Debtors ----------------
    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 object is dbnull then return the default for that type.
            //Otherwise just return the orginal value.

            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?

Re: Stront typing error

kanchoette24-Feb-09 23:41

kanchoette

24-Feb-09 23:41

I fixed it with a syntax change so:

if (getDefaultIfDBNull(row["PostTown"], TypeCode.String) != getDefaultIfDBNull(row["CorrespondencePostTown"], TypeCode.String))
 {
   row.CorrespondencePostTown = row.PostTown;
 }

Q: How to serialize layer structure

pandd24-Feb-09 21:13

pandd

24-Feb-09 21:13

[Serializable]
public class DrawableObject {}

[Serializable]
public class Layer : DrawableObject, IList<DrawableObject> {}

[Serializable]
public class Graphic : DrawableObject { }

static void Main(string[] args)
{
Type[] extraType=new Type[]{typeof(DrawableObject),typeof(Layer),typeof(Graphic)};
Layer layer = new Layer();

layer.Add(new Graphic());//add Graphic is ok.
layer.Add(new Layer()); //add Layer occur error

TextWriter textWriter = new StreamWriter("layer.xml");
XmlSerializer xmlSerializer = new XmlSerializer(typeof(Layer), extraType);
xmlSerializer.Serialize(textWriter, layer);
}

There is a exception in Serialize().
InnerException said it cannot include Layer.

Is it possible to make this Confused | :confused:

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.