Accessing a .mdb database on a CD - C# Discussion Boards

IrishSonic2-Sep-03 22:39

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~~!!

Re: scroll events detecting

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

Re: scroll events detecting

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

Re: scroll events detecting

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

Re: scroll events detecting

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??

GAC and Versioning Question

Mazdak2-Sep-03 21:20

Mazdak

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.

Accessing a .mdb database on a CD

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"

Re: Accessing a .mdb database on a CD

Mazdak2-Sep-03 21:23

Mazdak

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.

Re: Accessing a .mdb database on a CD

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

Re: Accessing a .mdb database on a CD

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

Re: Accessing a .mdb database on a CD

Braulio Dez3-Sep-03 5:47

Braulio Dez

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

Braulio Dez

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

Re: Accessing a .mdb database on a CD

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.

Re: Accessing a .mdb database on a CD

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

Braulio Dez

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"

Re: DataSet, DataRows etc.

Mazdak2-Sep-03 20:13

Mazdak

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.

Re: DataSet, DataRows etc.

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

Mazdak

2-Sep-03 20:20

A.Wegierski wrote:
DataRow object doesn't contain Columns objects

DataRow.Table.Columns

Mazy

No sig. available now.

Re: DataSet, DataRows etc.

A.Wegierski3-Sep-03 19:28

A.Wegierski

3-Sep-03 19:28

Thx

Hi,
AW

How to loop through a currencyManager

Ista2-Sep-03 16:58

Ista

2-Sep-03 16:58

I have a data grid I have extended.

in the paint event a need to draw a red line through each row that contains a void. how would i from

DataGrid.BindingContext loop through each one. one by one

nicl

I'm not an expert yet, but I play one at work. Yeah and here too.

Overriding DataGrid::OnPaint

Ista2-Sep-03 16:57

Ista

2-Sep-03 16:57

Does anyone have a link ro what not to override this method

I need to customize the row header icon and draw a line through the row if the void property is true

and ideas?

nbick

I'm not an expert yet, but I play one at work. Yeah and here too.

Last Visit: 31-Dec-99 18:00 Last Update: 25-Apr-24 2:15

Refresh

ᐊ Prev 1...14527 14528 14529 145301453114532 14533 14534 14535 14536 Next ᐅ

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