Calvary Chapel Sacramento

How can i asign dataset to crystal report

14-Oct-06 13:19

Hello

You can export any DataTable to any Database provider -including excel-, by writing it to an Xml file. So for a table you'd use DataTable.WriteXml(), or for multiple tables use DataSet.WriteXml(). Then use an XmlWriter to write it to a file. There isn't much of a code in it actually.

Regards

please help me....

choorakkuttyil14-Oct-06 0:39

choorakkuttyil

14-Oct-06 0:39

how can we bind DataReader() results to a table in asp.net WebForm (in dynamic format)(without using DataAdapter())??Please help me.... its urgent.... Confused | :confused:

Re: Useless subject

Guffa14-Oct-06 2:54

Guffa

14-Oct-06 2:54

Please don't cross post.

---
b { font-weight: normal; }

picture question

rzvme14-Oct-06 0:34

rzvme

14-Oct-06 0:34

the thing is i have a really large picture (1600 X 1200) and i have to put it in a picture box on a form. The form is at maximum size (1200 X 1000) so only a part of the picture is dyplayed becouse the picture box is larger than the form. The question is can implement some kind of scrollin on the picture and how do i do that?

rzvme

Re: picture question

Stefan Troschuetz14-Oct-06 1:20

Stefan Troschuetz

14-Oct-06 1:20

This should be possible by putting the PictureBox (full size of picture) into a Panel (wanted size) which is a scrollable control.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

btota13-Oct-06 22:35

btota

13-Oct-06 22:35

my project does not depend on virsual connection and virsual dataset

and when i design the report i design it on virsual dataset after i finsh the design i remove the dataset and i asign for the report datasourse {My dataset} but when i run the report does not have the data in my dataset

how can i solve it

thanks for help

fatma

Re: How can i asign dataset to crystal report

Nick Parker14-Oct-06 4:56

Nick Parker

14-Oct-06 4:56

You might find this[^] documentation on MSDN helpful.

- Nick Parker
Microsoft MVP - Visual C#
My Blog | My Articles

.NET 1.1 application performance in Windows 2003 Server

Sushant Duggal13-Oct-06 22:19

Sushant Duggal

13-Oct-06 22:19

Hi Friends,

I developed a desktop applcation in .NET 1.1 frameework using C#.
The application works perfect in Windows XP or Windows 2000 Server environment, but in Windows 2003 server the application is really slow. The performance is degraded upto 200%. i.e. it takes 4 times more time in Windows 2003 server than under Windows XP or Windows 2000 server.

Can anyone tell me what is the problem and can it be rectified.

Thanks,

Sushant Duggal.

Re: .NET 1.1 application performance in Windows 2003 Server

Nick Parker14-Oct-06 4:57

Nick Parker

14-Oct-06 4:57

That's a fairly broad question, have you tried profiling the application? If you don't have a commerical profiler, try the CLR Profiler[^] from Microsoft.

- Nick Parker
Microsoft MVP - Visual C#
My Blog | My Articles

DataGridViewComboBoxCell value is invalid

WillemM13-Oct-06 22:18

WillemM

13-Oct-06 22:18

I was doing some final testing on a program that I build last week, when I encountered the following error in a databound datagridview

DataGridViewComboBoxCell value is invalid

It happend without a real reason, because nothing has changed since the last test and that last test succeeded without error.

Anybody have a clue as what might be going on here? I checked the databinding, but that seems correct to me. So it must be something else.

WM.

What about weapons of mass-construction?

Back link

basumca13-Oct-06 21:43

basumca

13-Oct-06 21:43

I have a "Back" link in aspx page.
If clicked on this link it go to previouspage. For this I wrote back
It is working fine.
But I also Have a continue button which inserts data into db when clicked on it.
So If i go back and click on continue new record is inserte for the same member i don't want that to happen.
I want to maintain state persistence.
how can I do this.
Can Anybody help me
Thanx in Advance

chanti

Re: Back link

Nick Parker14-Oct-06 4:59

Nick Parker

14-Oct-06 4:59

This question belongs in the ASP.NET forum.

- Nick Parker
Microsoft MVP - Visual C#
My Blog | My Articles

need help or advice... [modified]

TheCardinal13-Oct-06 21:12

13-Oct-06 21:12

private void WhatFormToShow(Form   f)
{
    f.MdiParent = this;
    f.Dock = DockStyle.Fill;
    f.Show();
    //
    this.pnlCompositeCon.Controls.Clear();
    this.pnlCompositeCon.Controls.Add(f);
    this.txtCurrentLoadedForm.Text = f.Name.ToUpper();
 }

 WhatFormToShow(FrmAdd);

when i call the function i got this error, that said "its a 'type' but us used like a 'variable'...what is the proper way of doing this? please help

-- modified at 3:18 Saturday 14th October, 2006

mav.northwind13-Oct-06 21:56

mav.northwind

13-Oct-06 21:56

What is the exact (!) error message you get?
The compiler won't tell you "its a 'type'". What is 'its'?

Could it be that FrmAdd is the name of your form class and not the name of a form instance?

Regards,
mav

--
Black holes are the places where God divided by 0...

Nader Elshehabi14-Oct-06 2:59

14-Oct-06 2:59

All I can do is guesses.

I guess that you get the error at this line:

WhatFormToShow(FrmAdd);

and I guess that FrmAdd is a class name. Is this the case? If so you have to pass an object no a class to the method.

Regards

TheCardinal14-Oct-06 3:38

14-Oct-06 3:38

thanks for reply Smile | :)

Yup i want to pass the form class name so i can instantiate the form by using the function.

Im tired of typing...

FrmNew myF = new FrmNew();
//
// insert additional form setting.
// ex: .windowstate/.location
//
myF.Show();

or if there are more form setting to setup.

i want to pass the form name so the function can create it and instantiate it automatically.

Im new to c# any links to enlighten me more on this subject please dont hesitate to point me to the right direction Smile | :)

Thanks

mav.northwind14-Oct-06 6:08

mav.northwind

14-Oct-06 6:08

While you can achieve something like this using reflection, I strongly doubt that you should do it.
Giving "I'm tired of typing..." as the reason simply isn't enough. What are the advantages you get for the flexibility you lose?

Regards,
mav

--
Black holes are the places where God divided by 0...

Nader Elshehabi14-Oct-06 6:46

14-Oct-06 6:46

Well, you want to make some sort of a Froms factory!! This is possible, but as Mav said... Why?? Each form has its own special properties to be initialized. Why don't you initialize them at design time once??

Anyway, I'm not in the position to judge or modify your coding style. All I wanted was to guide you to what I think is better than what you want. Trust me, this isn't the reason to make such a factory method.

Anyway, you can do it -like Mav said again- using Reflection namespace.

1- Declare your method as

MyMethod(Type TheForm)

2- Call it as

MyMethod(typeof(FormClassName));

3- In the Form you can call Assembly.CreateInstance() to create your form. Then using this object you can initialize it.

Yet, again... Does it really worth all this??

Regards

TheCardinal14-Oct-06 17:54

14-Oct-06 17:54

I see. Thanks mav and nader Smile | :)

I really wanted to implement this as part of my UI. I have created an mdi application that mimic the MS MONEY 2006 tab bar

tab ---> HOME BILLING INVENTORY

So if i click on the HOME TAB, it will only load a single form. this is all done in my FrmMain. this is why i have this sub.

private void SelectTabToView(string sWhatTab)
       {
           switch (sWhatTab.ToUpper()) {
               case "HOME":
                   FrmHome F1 = new FrmHome()
                   F1.MdiParent = this;
                   F1.Dock = DockStyle.Fill;
                   F1.Show();
                   //
                   this.pnlCompositeCon.Controls.Clear();
                   this.pnlCompositeCon.Controls.Add(F1);
                   this.txtCurrentLoadedForm.Text = F1.Name.ToUpper();
                   break;
               case "BILLING":
                   FrmHome F2 = new FrmHome()
                   F2.MdiParent = this;
                   F2.Dock = DockStyle.Fill;
                   F2.Show();
                   //
                   this.pnlCompositeCon.Controls.Clear();
                   this.pnlCompositeCon.Controls.Add(F2);
                   this.txtCurrentLoadedForm.Text = F2.Name.ToUpper();

                   break;
               case "INVENTORY":
                   FrmHome F3 = new FrmHome()
                   F3.MdiParent = this;
                   F3.Dock = DockStyle.Fill;
                   F3.Show();
                   //
                   this.pnlCompositeCon.Controls.Clear();
                   this.pnlCompositeCon.Controls.Add(F3);
                   this.txtCurrentLoadedForm.Text = F3.Name.ToUpper();

                   break;
           }
       }

So i could have used the function

private void SelectTabToView(string sWhatTab)
       {
           switch (sWhatTab.ToUpper()) {
               case "HOME":
                   WhatFormToLoad(FrmHome);
                   break;
               case "BILLING":
                   WhatFormToLoad(FrmBilling);
                   break;
               case "INVENTORY":
                   WhatFormToLoad(FrmInventory);
                   break;
           }
       }

This is much easier than typing all those redundant settings Smile | :)

Thats why i have decide to create a generic routine or a form factory to catter the loading of forms by just passing the form name.

If im not on the right path in doing this please advice on what to do Smile | :)

Maybe i was just looking how to hammer a nail with a jackhammer Smile | :)

Nader Elshehabi14-Oct-06 18:09

14-Oct-06 18:09

Well, you can use generics;P

Or much simpler, this:

private void SelectTabToView(string sWhatTab)
        {
            switch (sWhatTab.ToUpper()) {
                case "HOME":
                {
                    FrmHome frm = new FrmHome();
                    WhatFormToLoad(Frm);
                    break;
                }
                case "BILLING":
                {
                    FrmBilling frm = new FrmBilling();
                    WhatFormToLoad(Frm);
                    break;
                }
                case "INVENTORY":
                {
                    FrmInventory frm = new FrmInventory();
                    WhatFormToLoad(Frm);
                    break;
                }
            }
        }

private void WhatFormToLoad(Form MyForm)
{
    MyForm.MdiParent = this;
    MyForm.Dock = DockStyle.Fill;
    MyForm.Show();
    //
    this.pnlCompositeCon.Controls.Clear();
    this.pnlCompositeCon.Controls.Add(MyForm);
    this.txtCurrentLoadedForm.Text = MyForm.Name.ToUpper();
}

Regards

TheCardinal14-Oct-06 18:45