C# Discussion Boards - CodeProject

Re: Sorry... answers from the newsgroups...

3-Sep-03 4:24

MMm.... well you can set that DataView in a new DataTable, and pass it as parameter to the Report as a dataset parameter.

HTH
Braulio

Braulio Dez3-Sep-03 4:26

Displaying label in ASP.NET

3-Sep-03 4:26

You can't use a DataView as a datasource. It's supposed to work, but my
contact at Crystal told me that there is a bug in the current release that
doesn't let it connect properly. Hopefully they will fix this in a future
release. If you want to see all the ways you can connect a datasource to a
report then check out Chapter 14 of my free online ebook.

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

You are right. CR works with datasets, but not dataview. I discovered this
while working on my book and discussed it with tech support. They worked on
it and decided that there must be a casting error in their code and they
created a KB issue for it. Hopefully it will be fixed in a future service
pack.

IrishSonic2-Sep-03 22:39

IrishSonic

2-Sep-03 22:39

Hi guys,

Created a simple asp web app and compiled it fine and runs the web page.

So I dragged a label over and placed it on the form. In load_page put the code:

label1.Text = "This is a test web page";

But when its run, it doesn't display the label!!

What am I doing wrong??
Thanks.

scroll events detecting

azusakt2-Sep-03 21:39

azusakt

2-Sep-03 21:39

Hi,
Is it possible to get the event of scroll of a Form? I would like to do something every the forms is scrolling; (the form is set to AutoScroll).

Thanks for help~~!!

J. Dunlap2-Sep-03 21:46

J. Dunlap

2-Sep-03 21:46

Scrolling support in WinForms is not too good. You have to subclass the form and catch WM_HSCROLL, WM_VSCROLL, and WM_MOUSEWHEEL events.

"Blessed are the peacemakers, for they shall be called sons of God." - Jesus

"You must be the change you wish to see in the world." - Mahatma Gandhi

azusakt2-Sep-03 22:04

azusakt

2-Sep-03 22:04

jdunlap wrote:
You have to subclass the form

sorry,jdunlap,

I'm stupid.Could you explain it a bit more?
Coz I'm just a fresh C# programmer. I'll be happy if you could provide me some part of codes/examples.

Thank you

J. Dunlap3-Sep-03 19:43

J. Dunlap

3-Sep-03 19:43

Here is a basic subclassing class in C#:

class SubClasser : System.Windows.Forms.NativeWindow
{	

    public SubClasser(IntPtr formhandle)
    {
            base.AssignHandle(formhandle);
    }

    protected override void WndProc(
           ref System.Windows.Forms.Message m)
    {
        base.WndProc(ref m);

        switch(m.Msg)
        {
            case WM_HSCROLL:
                //do something here
                break;
            case WM_VSCROLL:
                //do something here
                break;
        }
    }

}

"Blessed are the peacemakers, for they shall be called sons of God." - Jesus

"You must be the change you wish to see in the world." - Mahatma Gandhi

GAC and Versioning Question

azusakt3-Sep-03 17:12

azusakt

3-Sep-03 17:12

jdunlap wrote:
Scrolling support in WinForms is not too good.

If the scrolling is not good in WinForm, then what can I use? Or I need to make a newcontrol?
I use autoScroll in my Form, because I don't want to waste much time on calculation. I've tried to use hScrollBar and vScrollBar, but the interface looks not beautiful as autoScroll bar.

Any idea for me??

Mazdak2-Sep-03 21:20

Accessing a .mdb database on a CD

2-Sep-03 21:20

I have a class library version 1.0. I want it to GAC(Global Assemly Cache).Now how can I use it in my application?I can't use object which exist in it,I have to first Add reference to the local compy of it,then if I delete dll file in my debug directory,because another version is exist in GAC I can use the version in GAC.HHow can I use that vversion from the begining.

My second question is I have careated version2.0 and v3.0 and put them in GAC,the question is how can I force my application to use my desired version?

Mazy

No sig. available now.

Den2Fly2-Sep-03 21:15

Den2Fly

2-Sep-03 21:15

Regards,
We have developed a multimedia software using C# which uses a .mdb (MS-Access file) as database. When burning the whole project on the CD, the program coulden't access the database so we had to to install the .mdb file on the user's system HDD and that works.

But I still wonder why it was not possible to read our database on the CD and if it is anyway to do so. perhaps C# needs to write some temporary files beside the .mdb file to work with or what?

Thanks for any note and help,
-nSun

---
"Art happens when you least expect it"

Mazdak2-Sep-03 21:23

2-Sep-03 21:23

nSun wrote:
perhaps C# needs to write some temporary files beside the .mdb file to work with or what?

Yes,there is a lock file that should be written near .mdb file but I don''t think this is specific to C# only.

Mazy

No sig. available now.

J. Dunlap2-Sep-03 21:48

J. Dunlap

2-Sep-03 21:48

Yes, the Jet database engine, which Access DBs are based on, create a *.ldb database lock file. But this has nothing to do with whether or not you use C#.

"Blessed are the peacemakers, for they shall be called sons of God." - Jesus

"You must be the change you wish to see in the world." - Mahatma Gandhi

Tatham2-Sep-03 22:34

Tatham

2-Sep-03 22:34

I'm not experienced in Access so don't quote me - but...

Is it possible to open the database as a shared connection - would this remove the need to write the lock file.

Tatham Oddie (VB.NET/C#/ASP.NET/VB6/ASP/JavaScript)
tatham@e-oddie.com
+61 414 275 989

Braulio Dez3-Sep-03 5:47

3-Sep-03 5:47

Hi,

If you choose "Read Only" AND "Open Exclusive" together, Access won't create
the *.ldb file if it isn't already there.

Another option is to get any "ldb" file, and copy it into the CD as well... not very clean solution, but it seems that it works fine Smile | :)

Good luck
Braulio

One more tip

Braulio Dez3-Sep-03 5:58

3-Sep-03 5:58

Hi,

Have you tried to set "Exclusive Access" and login to the database with an user that only has "Read Data" access ?

Tools >> Security >> User and Group Accounts

Tools >> Security >> User and Group Permissions

HTH
Braulio

Anonymous3-Sep-03 6:52

Anonymous

3-Sep-03 6:52

It is possible to open an Access database which resides on a CD, but you must open it as Exclusive, Read-Only. This prevents the ldb file from being created.

Den2Fly4-Sep-03 0:58

Den2Fly

4-Sep-03 0:58

Thanks all for helps.

-nSun

---
"Art happens when you least expect it"

Grid

Roger Alsing2-Sep-03 20:47

Roger Alsing

2-Sep-03 20:47

Hi ,
ive just published an alpha version of my new grid.

www.compona.com/alphaalphagrid.zip[^]

could someone please help me test it?

//Roger

Re: Grid

Braulio Dez3-Sep-03 5:33

Re: DataSet, DataRows etc.

3-Sep-03 5:33

Hi,

It would be a good idea if you include some Doc or Pdf with some snapshots... just download the Zip... and put the exes in a local computer... just look like a virus or something like that Smile | :)

Greetings
Braulio

Re: Grid

Roger Alsing3-Sep-03 20:53

Roger Alsing

3-Sep-03 20:53

Ok,

actually there are no documentation on this control yet Poke tongue | ;-P

altough some screenshots and info can be found at:
http://www.compona.com/WikiEngine/WikiPageViewer.ascx?ID=48[^]

//Roger

DataSet, DataRows etc.

deanoA2-Sep-03 20:03

deanoA

2-Sep-03 20:03

Hi!
I'm trying to print the values in my DataSet.
It has a single row in it. I used this CommandText: "Select NAME from Authors"
Now the query returns all the names.

Now, I want to print the values in the dataset and I want to use foreach because I do not know how many names I might get. But the problem is, what do I use to traverse my set? I used this ff code but it generates an error:

DataRow dr = dsDBData.Tables[0].Rows[0];
foreach (DataColumn dc in dr)
{
MessageBox.Show(dc.ToString());
}

Please help.

"To teach is to learn twice"

Mazdak2-Sep-03 20:13

Re: DataSet, DataRows etc.

2-Sep-03 20:13

daljv wrote:
foreach (DataColumn dc in dr)

Change it to something like this:

foreach(DataColumn in dr.Table.Columns)

Mazy

No sig. available now.

A.Wegierski2-Sep-03 20:14

A.Wegierski

2-Sep-03 20:14

You have more than one row and DataRow object doesn't contain Columns objects. See help on Data namespace. Should be:

foreach(DataRow dr in dsDBData.Tables[0].Rows)
{
MessageBox.Show(dr[0].ToString());
}

Hi,
AW

Re: DataSet, DataRows etc.

Mazdak2-Sep-03 20:20