Re: IntelliTrace not what I thought - .NET (Core and Framework) Discussion Boards

First Prev Next

Re: Switch colums and rows in vb.net datagrid

Ashfield19-Apr-10 22:34

Ashfield

19-Apr-10 22:34

Two things spring to mind initially. One, why not use a real database, SQL Express is free and far superior to Access, and two, usng the species as a column name means every time you need to add a new species you have to alter your table. Put the species in one table and the record of catches in another - probably there ought to be a further table with the fisherman details too. Get a book on database design before going any further, as using your current design is asking for trouble in the future.

In answer to your question, you can manipulate the data within your code to do what you want, but if you use SQL Express 2008 it can be done by using the PIVOT command.

Bob
Ashfield Consultants Ltd

Re: Switch colums and rows in vb.net datagrid

Peter Leipzig20-Apr-10 3:39

Peter Leipzig

20-Apr-10 3:39

Ashfield

I want to thank you and Walt Fair for the response. You both mentioned SQL Express and I will look into it. I do not do a lot of this sort of work, that is why I am still using vb.net 2003. I used an Access database because that it what I had handy, but I am early enough in this project that I can switch easily.

As far as the species names as column headings. I understand your point, but for good or bad, the fishery that this program is to used in is one that is managed by the Federal Governemnt and has a management plan that identifies exactly the species involved, so adding new species will not be an issue.

Re: Switch colums and rows in vb.net datagrid

gmhanna20-Apr-10 5:25

gmhanna

20-Apr-10 5:25

Hi Peter,

I believe you get SQL Express for free with Visual Studio 2005 as part of the VS 2005 installation. With 2003, you will have to download it and install it. I would suggest upgrading.

Glenn

Re: Switch colums and rows in vb.net datagrid

Ashfield20-Apr-10 8:45

Ashfield

20-Apr-10 8:45

Peter Leipzig wrote:
As far as the species names as column headings. I understand your point, but for good or bad, the fishery that this program is to used in is one that is managed by the Federal Governemnt and has a management plan that identifies exactly the species involved, so adding new species will not be an issue.

Even so, you should bear in mind that this is a bad design which, although it may not cause you problems in this instance should really not be used - better to do it right every time rather than taking shortcuts which can soon lead to general sloppiness.

Bob
Ashfield Consultants Ltd

OLE MS-Access Database - Syntax error in FROM clause

gmhanna19-Apr-10 14:33

gmhanna

19-Apr-10 14:33

Hi,

This should be very straight forward but I am missing something. I have a database in MS-Access to keep track of my Class Reunion information. The table is called "Reunion-Table". I'm trying to read this table with C# and fill a dataGrid. However, I'm receiving an OleDbException from the adapter.fill method, which is saying, Syntax error in FROM clause. Here's my code:

private void DataSetFromOleDb()
        {
            string strSQL =
              "SELECT * FROM Reunion-Table"; // WHERE YOG=1979";


            try
            {
                using (OleDbDataAdapter adapter =
                  new OleDbDataAdapter(strSQL,
                  Properties.Settings.Default.OleDbConnectionString2))
                {

                    DataSet ds = new DataSet();
                    adapter.Fill(ds, "Reunion-Table");
                    dataGridClassReunion.DataSource = ds.Tables["Reunion-Table"];                    
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

and here's my Connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="H:\users\glenn\documents and settings\db1-0706.mdb"

Any help would be greatly appreciated.

Thank you,

Glenn

Re: OLE MS-Access Database - Syntax error in FROM clause

Eddy Vluggen20-Apr-10 9:13

Eddy Vluggen

20-Apr-10 9:13

Hi,

The name of the table might be interpreted as two separate words. Can you try out the syntax below?

string strSQL = "SELECT * FROM [Reunion-Table]";

I are Troll Suspicious | :suss:

Message Removed

19-Apr-10 3:56

N_tro_P

19-Apr-10 3:56

Message Removed

Re: IntelliTrace not what I thought

Dave Kreskowiak19-Apr-10 4:06

Dave Kreskowiak

19-Apr-10 4:06

Intellitrace wasn't designed to be used in an end-user debugging situation. It was designed for use during development and especially during testing. Your testers can create or recreate problems problems and send you the log files so that you can see the steps that were used to get to the problem as well as what the code was thinking as the steps were being followed.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Message Removed

19-Apr-10 4:12

N_tro_P

19-Apr-10 4:12

Message Removed

Re: IntelliTrace not what I thought

Dave Kreskowiak19-Apr-10 10:33

Dave Kreskowiak

19-Apr-10 10:33

http://www.microsoft.com/visualstudio/en-us/products/2010-editions/test-professional[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

difference between abstract class and interface

Balaji_Reddy19-Apr-10 0:37

Balaji_Reddy

19-Apr-10 0:37

hi their, i just wanna to know the major difference between abstract class and interface...

till now i knew like Abstract class will have connection of internally related method's declaration but in interface will have collection of unrelated methods... am i correct? Confused | :confused:

Re: difference between abstract class and interface

Eddy Vluggen19-Apr-10 2:45

Eddy Vluggen

19-Apr-10 2:45

balajict wrote:
i just wanna to know the major difference between abstract class and interface

It's not a "major difference", but a few subtle differences. There's an article[^] on CodeProject that highlights the differences.

Enjoy Smile | :)

I are Troll Suspicious | :suss:

Re: difference between abstract class and interface

Balaji_Reddy19-Apr-10 4:49

Balaji_Reddy

19-Apr-10 4:49

HI THEIR,

i gone throw the article .its good but they were explained only about how to implement and syntax
differences n multiple inherit but wat i expert na why we need tat? almost both does the same thing
but why we need tat apart from the given explanation ....

Re: difference between abstract class and interface

Richard MacCutchan19-Apr-10 5:01

Richard MacCutchan

19-Apr-10 5:01

Take a look at this article[^] by Microsoft.

It's time for a new signature.

Re: difference between abstract class and interface

Eddy Vluggen19-Apr-10 5:32

Eddy Vluggen

19-Apr-10 5:32

balajict wrote:
why we need tat?

I don't think that both have been thought up simultaneously with a distinct idea "let's use A in circumstance one and B in circumstance two". You got a sledgehammer and a warhammer, both have similar uses but different advantages and disadvantages in different situations.

I are Troll Suspicious | :suss:

Re: difference between abstract class and interface

Luc Pattyn19-Apr-10 6:28

Luc Pattyn

19-Apr-10 6:28

subtle and instructive, I like it. Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

Re: difference between abstract class and interface

Peace ON19-Apr-10 6:27

Peace ON

19-Apr-10 6:27

In addition to the major differences between abstract class and interface
you should also aware proper use of it at proper place and requirement.

Following links helps you to understand when to use abstract class and
when to use interface.

http://codeofdoom.com/wordpress/2009/02/12/learn-this-when-to-use-an-abstract-class-and-an-interface/[^]

http://geekswithblogs.net/mahesh/archive/2006/07/05/84120.aspx[^]

Hope this will help!

Jinal Desai

Re: difference between abstract class and interface

Balaji_Reddy21-Apr-10 3:47

Balaji_Reddy

21-Apr-10 3:47

hi Jinal Desai,

thanks man.now i got clear idea about it thanks again. Laugh | :laugh:

How to force Setup project to use prerequisites with older version

rahul.kulshreshtha18-Apr-10 21:32

rahul.kulshreshtha

18-Apr-10 21:32

I have created a VSTO Excel addin. It's deployment is really a headache.
I want to set VSTO 2.0 RunTime in prerequisite but I am using VS 2008 and it shows VSTO 3.0 Runtime in prerequisite list. I can not select that because that will use .NET 3.0 or above. My applicaiton is .NET framework 2.0 compatible and it requires VSTO 2.0 not 3.0 as a minimum requirement.

How to set VSTO runtime 2.0 as a minimum requirement ?

I want that If any dependency is not found on client PC then either it should be download from internet(in case of .NET framework) or it should be packaged with installation (in case of VSTO 2.0)

Re: How to force Setup project to use prerequisites with older version

Eddy Vluggen19-Apr-10 2:49

Eddy Vluggen

19-Apr-10 2:49

Are all your projects set to use and compiled to the 2.0 framework?

To verify, go to the menuitem "Project", and select "Properties". There's an "Application" tab, and it should state that it's using the 2.0 framework in the textbox labeled "Target Framework".

I are Troll Suspicious | :suss:

Re: How to force Setup project to use prerequisites with older version

rahul.kulshreshtha19-Apr-10 2:59

rahul.kulshreshtha

19-Apr-10 2:59

Yes my both projects(SetSecurity & Excel Addin) in soltion are targeting to Framework 2.0
My setup project is also showing dependence "Microsoft .NET Framework" with version 2.0.50727

Re: How to force Setup project to use prerequisites with older version

Eddy Vluggen19-Apr-10 3:22

Eddy Vluggen

19-Apr-10 3:22

VSTO 3 isn't supported on the 2.0 framework, I hoped that the installer would drop everything that would require a newer version of the framework.

Can you uninstall VSTO3 (to make sure there's no references at all), building[^] the setup using VS2005 & VSTO2?

I are Troll Suspicious | :suss:

Re: How to force Setup project to use prerequisites with older version

rahul.kulshreshtha19-Apr-10 3:35

rahul.kulshreshtha

19-Apr-10 3:35

unfortunately it is not getting uninstall. On uninstall it crashes and shows "Send \ Don't Send". Any VSTO run-time cleanup tool available ? Frown | :(

LayOut In . Net

SajjadZare17-Apr-10 6:38

SajjadZare

17-Apr-10 6:38

Hi I want types of layout in .net
please help me

Re: LayOut In . Net

Abhinav S17-Apr-10 6:48

Abhinav S

17-Apr-10 6:48

You will have to be more specific as different technologies provide different layouts.

If you are looking for WPF layouts, see here.

Silverlight, too, provides different panels for layouts.

Last Visit: 31-Dec-99 18:00 Last Update: 13-May-24 2:43

Refresh

ᐊ Prev 1...342 343 344 345346347 348 349 350 351 Next ᐅ

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