C# Discussion Boards - CodeProject

krisp7-Jul-03 1:49

7-Jul-03 1:49

I wrote my own command in Crystal Reports 9, I want to set the DataSource at runtime.

StaffHoursReport staffHoursReport = new StaffHoursReport();

foreach( Table t in staffHoursReport.Database.Tables )
{
t.SetDataSource( Db.DataSource );
}

Where Db.DataSource is a static string. It works for all the tables in my Report but not for the Command I made. I also tried

t.Location = Db.DataSource;

but this works for all the tables but throws an exception on any Commands. The SetDataSource does not throw any exceptions but it prompts for the database path when the report is being created for display. And then it says log in failed if i type in the path to the database.

The only way this report works is if I have the database in the path specified in the report designer. But this is no good, it will be on different machines all the time.

Please help, thanks alot.

Arrays

_cancer_7-Jul-03 1:21

_cancer_

7-Jul-03 1:21

public class Class2
{
    private Class1[][] var;
    
    public Class2
    {
        var = new Class1[9][]
        {
            new Class1[9]
            {
                new Class1(.....),
                new Class1(.....),.....
            },
            new Class1[9]
            .....
        }
    }
}

when i debug this, there's an Exeption at the underlined position: Invalid Parameter used

What did i wrong?

Re: Arrays

perlmunger7-Jul-03 11:58

perlmunger

7-Jul-03 11:58

Frankly, I haven't done a whole lot with multidimensional arrays in C#, however, I can say this--the syntax you are using looks really strange and I'm not sure what you are trying to accomplish. I don't know if the code you have provided here is just pseudo-code or the real thing, but as far as I can tell, you have all kinds of problems. Here's how I interpret your code, but with a more conventional syntax:

public class Class2
{
    private Class1[][] var;
    
    public Class2() // constructor
    {

        var = new Class1[9][];
        var[0] = new Class1[2];
        // var[0] now points to two Class1 objects.
        // The first is at var[0][0] and second at var[0][1]
        // So you can access the members of those objects
        // like this:
        var[0][0].Member1 = "Bob was here";
        var[0][0].Member2 = "Testing...testing";
        var[0][1].Member1 = "Is this thing on?";
    }
}

Looks to me like you just have a syntax problem. If you'll explain exactly what you are trying to do, I can help a little more. I am just trying to provide you with proper syntax here.

Good luck.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

Re: Arrays

PeterMoon29-Jan-08 17:53

PeterMoon

29-Jan-08 17:53

Replace the underlined line with the following:

var = new Class1[][]

C# COM+ Client/Server

SpudgunDoogal7-Jul-03 1:05

SpudgunDoogal

7-Jul-03 1:05

Hi,

I'm currently trying to develop a COM+ server component which receives data passed to it by a client and stores that data into a database. So far I have the client talking to the server but nothing appears to happen. Watching the component in the Component Services reveals that the object is being created and is pooling as expected. Yet it doesn't appear to do anything else. When I run the code in a standalone version it does the job perfectly! Can anyone help me to figure out what I'm missing?

Thanks in advance.

Graham

Re: C# COM+ Client/Server

Daniel Turini7-Jul-03 1:21

Daniel Turini

7-Jul-03 1:21

Put some System.Diagnostics.Trace.WriteLine and use DBMon from the SDK or SysInternal's DebugView[^] to see where it's failing.

ORACLE One Real A$#h%le Called Lary Ellison

Re: C# COM+ Client/Server

SpudgunDoogal7-Jul-03 1:38

SpudgunDoogal

7-Jul-03 1:38

Thanks, it does help if you know about these wonderful trace routines. I've located the problem and it appears to be due to the way I'm trying to connect to the target database.

Thanks again,

Graham

Re: C# COM+ Client/Server

Philip Fitzsimons7-Jul-03 2:53

Philip Fitzsimons

7-Jul-03 2:53

First guess is user credentials - check to see what user it is running under in com+, then check if that user is allowed to use the db.

"When the only tool you have is a hammer, a sore thumb you will have."

Re: C# COM+ Client/Server

Giles7-Jul-03 3:05

Giles

7-Jul-03 3:05

Don't know, but you may find my article helpful.

You should see a transaction go in when you register the component for the first time, then for each time you commit the root object that has RequiresNew agaist it.

"Je pense, donc je mange." - Rene Descartes 1689 - Just before his mother put his tea on the table.

Shameless Plug - Distributed Database Transactions in .NET using COM+

Re: C# COM+ Client/Server

SpudgunDoogal7-Jul-03 3:10

SpudgunDoogal

7-Jul-03 3:10

Thank you all for your help. It turns out that the COM+ component couldn't find the database DLL. According to the trace in Debug Viewer it attempted to download the DLL from the System32 directory. I copied the file into that directory and it's now working perfectly.

Thanks again!

Graham

Counting a datatable

totig7-Jul-03 0:46

totig

7-Jul-03 0:46

I have a datatable, with two columns. I want to find out how it is possible to count all the values in the 1st column. I want to be able to see which row has the highest number. There is a reason for me doing it this way, rather than making a query do the same thing. Thanks in advance.

Re: Counting a datatable

Philip Fitzsimons7-Jul-03 2:53

Philip Fitzsimons

7-Jul-03 2:53

sum()

"When the only tool you have is a hammer, a sore thumb you will have."

Re: Counting a datatable

totig7-Jul-03 3:10

totig

7-Jul-03 3:10

This may seem a bit stupid replying to my own answer, but as I found out what it is, I thought I might share it.
Ok, this is bad code, but you get the idea:

int test1 = 0;
int test2 = 0;
foreach(DataRow myRow in myTable.Rows)
{
test1 = System.Int32.Parse(myRow[0].ToString());
if (test2 <= test1)
{
test2 = test1 + 1;
}
}

Datagrid Combobox column

Rohit Kashikar6-Jul-03 23:44

Rohit Kashikar

6-Jul-03 23:44

Hi,

I have created a datagrid having source as one table. but the column style I have specified separately for each column of the table some of which are DataGridComboboxColumn. Things till now are working fine - I am able to view all the foreing table entries properly in combobox. The code is as shown below..
UserComboTextCol.MappingName = obTableVerboseInfo.ColumnName;
UserComboTextCol.HeaderText = obTableVerboseInfo.ColHeaderName;
UserComboTextCol.Width = 120;
UserComboTextCol.ColumnComboBox.DataSource = dsRefTreeSelected.Tables[obTableVerboseInfo.RefTableName].DefaultView;

UserComboTextCol.ColumnComboBox.DisplayMember = obTableVerboseInfo.DisplayColumn;

UserComboTextCol.ColumnComboBox.ValueMember = obTableVerboseInfo.RefColumnName;

Do not worry about the values on right side of =.

But now I want this datagrid for update purpose as well. i.e. if user makes some modifications to the combo control, I should get the foreign key value of the new selected member. All that I get is the display column which can be duplicate in table !! Once the user has updated the datagrid, how do I put the values back to the table by converting them to the actual values from display column ? Can anyone help me ?

Thanks.

Rohit

Re: Datagrid Combobox column

perlmunger7-Jul-03 12:16

perlmunger

7-Jul-03 12:16

I say this, not as a criticism so much as a way to help you; you've really got to try to phrase your questions a little clearer. Here's how I would have asked what I think you're trying to ask:

"I have a datagrid on a form I use to display a single table. The datagrid was originally intended for display only, but I now want to use it to update records as well. I have converted one of the columns so it now displays a combo box with a list of selections. I just don't understand, when I click my update button, how I can get the foreign key of the current record. Can someone point me in the right direction?"

The problem is that I don't know if you even have an update button. I had to assume you have some sort of handler to call update. It is also unclear, though the context seems to reveal it a bit, whether you are talking about updating a single record or many records at a time.

If I've missed your point, I apologize, I just think you should try to re-phrase it a bit to make it very clear what the problem is. You'll be a lot more likely to get a response that helps you fix the problem if you do.

Best Regards.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

Re: Datagrid Combobox column

7-Jul-03 18:30

Sorry ! I typed that message in such a hurry that I could not re-read it even once. But yes what you have understood is correct. I have an update button and I want to update one row at a time when User clicks on Update. Is there a way in which you can get the foreign key in this case?

Another question I had is, when you have a table with composit primary key (3 columns in my case) and you have that as a foreign key in another table, how do you replace those (foreign key) composite columns by a combo box which will hold values for some other column from the primary key table ?

Thanks
- Rohit

WM_PRINTCLIENT message

peenu6-Jul-03 23:15

peenu

6-Jul-03 23:15

Hi,
Has anybody used WM_PRINTCLIENT message?
I m using the following SendMessage call.....

SendMessage(hWnd, WM_PRINTCLIENT, (WPARAM) hDCMem, PRF_CLIENT | PRF_ERASEBKGND | PRF_CHILDREN );

but this returns a black window.
Any clues?
Thanks,
Puneet.

PDF viewer / printer component or solution - for distributed software(don't wanna use Abobe's)

Selector6-Jul-03 20:20

Selector

6-Jul-03 20:20

Hi all.

We are currently working on some software, that'll be distributed to a lot of customers - of our customer.

We need to show pdf files and make batch printing of them.

Anyone out there with a solution or knowledge of a component, that's capable of this?
It's important that it's royalty-free.

Thanks in advance!

Greetings,
Brian Dam
Tricon data A/S
Denmark

Re: PDF viewer / printer component or solution - for distributed software(don't wanna use Abobe's)

Roland Bär7-Jul-03 3:22

Roland Bär

7-Jul-03 3:22

Do you know ghostscript ?
-> http://www.ghostscript.com/[^]

Greets
Roland

Putting Array data in a string then showing it in a label.

eggie56-Jul-03 10:48

eggie5

6-Jul-03 10:48

I have an array...

private void Page_Load(object sender, System.EventArgs e)
{
    string [] dirs = Directory.GetDirectories(@"c:\inetpub\wwwroot\shares\folder\", "b*");
    labelPath.Text=dirs.ToString();
}

as you can see it's value is assigned to the string "dirs"

now I want it to show up thought he label "labelPath", but when I compile the page it shows "System.String[]"....

I need it to show the names of folders that start with "b", I can make it work as a consle application, but not a aspx page...

can somebody please help...???

/\ |_ E X E GG

Re: Putting Array data in a string then showing it in a label.

leppie6-Jul-03 11:32

leppie

6-Jul-03 11:32

Look at String.Join()

leppie ::AllocCPArticle(Generic DFA State Machine for .NET);

Re: Putting Array data in a string then showing it in a label.

eggie56-Jul-03 14:44

eggie5

6-Jul-03 14:44

string [] dirs = Directory.GetDirectories(@"c:\inetpub\wwwroot\shares\folder\", "b*");

I tried the Join Method but I can't get it to turn the above array "dirs" into a regular string that I can show though a label....

Blush | :O

can you show me?

/\ |_ E X E GG

Re: Putting Array data in a string then showing it in a label.

leppie6-Jul-03 15:15

leppie

6-Jul-03 15:15

Try delimiting the strings with "<BR>".

leppie ::AllocCPArticle(Generic DFA State Machine for .NET);

Re: Putting Array data in a string then showing it in a label.

eggie56-Jul-03 15:44

eggie5

6-Jul-03 15:44

huh?

/\ |_ E X E GG

Re: Putting Array data in a string then showing it in a label.

Daniel Turini7-Jul-03 1:24

Daniel Turini

7-Jul-03 1:24

try

Console.WriteLine(String.Join('\n', dirs));

ORACLE One Real A$#h%le Called Lary Ellison

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