Visual Basic

Re: DataGridView.Column("name").DefaultCellStyle.Format applied to all columns (it shouldn't be)

23-Apr-15 3:46

Hi Dave,

Would it suffice if I tell you the steps (in pseudo code) ?
1. Open Visual Studio 2012 Express
2. Start new Windows Forms project (.NET 4)
3. Drag DataGridView and button controls onto Window
4. Press button =
- Use SqlCommand to run MS SQL stored procedure that returns a table
- Use SqlDataAdapter to enter data into DataSet
5. BindingSource.DataSource = DataSet
6. DataGridView.DataSource = BindingSource
7. Run Method as in my original post

Regards,
Johan

My advice is free, and you may get what you paid for.

Dave Kreskowiak23-Apr-15 4:05

Re: DataGridView.Column("name").DefaultCellStyle.Format applied to all columns (it shouldn't be)

23-Apr-15 4:05

Johan Hakkesteegt wrote:
Would it suffice if I tell you the steps (in pseudo code) ?

No, because that is what you THINK the code is doing. The real code is required to show what the code is ACTUALLY doing.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Johan Hakkesteegt23-Apr-15 22:21

Re: DataGridView.Column("name").DefaultCellStyle.Format applied to all columns (it shouldn't be)

23-Apr-15 22:21

Hi Dave,

You were right (as usual).

I found that I was calling another method (see below) before using the one I posted originally. When I commented this one out, the first method worked as expected. Looking at it though, I don't see how this method caused the unexpected behavior. As far as I can tell, it is pretty much doing the same thing.

Public Sub FormatTable(ByVal dgv As DataGridView)
        Dim cs_Default As New DataGridViewCellStyle(dgv.DefaultCellStyle)
        Dim cs_Money As New DataGridViewCellStyle(cs_Default)
        Dim cs_Date As New DataGridViewCellStyle(cs_Default)
        Dim cs_String As New DataGridViewCellStyle(cs_Default)
        Dim cs_Integer As New DataGridViewCellStyle(cs_Default)
        Try
            With cs_Date
                .Alignment = DataGridViewContentAlignment.MiddleLeft
            End With
            With cs_Money
                .Alignment = DataGridViewContentAlignment.MiddleRight
                .Format = "F"
            End With
            With cs_Integer
                .Alignment = DataGridViewContentAlignment.MiddleRight
                .Format = "N0"
            End With
            With cs_String
                .Alignment = DataGridViewContentAlignment.MiddleLeft
            End With
            For Each clm As DataGridViewColumn In dgv.Columns
                Select Case clm.ValueType
                    Case Type_Double, Type_Long, Type_Decimal
                        clm.DefaultCellStyle = cs_Money
                    Case Type_Integer
                        clm.DefaultCellStyle = cs_Integer
                    Case Type_String
                        clm.DefaultCellStyle = cs_String
                End Select
            Next
        Catch ex As Exception
            EC(ex)
        End Try
    End Sub

Regards,
Johan

My advice is free, and you may get what you paid for.

Dave Kreskowiak24-Apr-15 3:49

Re: DataGridView.Column("name").DefaultCellStyle.Format applied to all columns (it shouldn't be)

24-Apr-15 3:49

There is probably something in between this method and the other one. Having multiple methods to format a grid is a bad idea because of the problem you're running into, though it's, sadly, kind of common.

If I have multiple grids I need formatted differently, but overall styled the same, I normally create my own DGV class, inheriting from the .NET DGV, setup the base styles common to all grids, then use that I my forms.

When I need to setup formatting, I have a method on the form that hosts the grid explicitly setting up the one grid instance with the things that are over and above the items setup in the base grid. This sometimes results in a duplication of code but I consider that a small price to pay for flexibility when I need to change a grid here and there.

Now, you might want to step through this code and the other code. It would appear that you're replacing the entire style of a column instead of making changes to it. If this code is called to setup your grid and then you call the other method to further change it you could be replacing the styles from one method with the styles from another instead of making changes to the style that is in place.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Johan Hakkesteegt24-Apr-15 4:03

Re: DataGridView.Column("name").DefaultCellStyle.Format applied to all columns (it shouldn't be)

24-Apr-15 4:03

Thanks Dave, I will look into that.

Thanks for the help !

My advice is free, and you may get what you paid for.

Eddy Vluggen22-Apr-15 4:51

Eddy Vluggen

22-Apr-15 4:51

I think "SELECT CASE TRUE" would always select the same case. Did you want to switch on the name?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: DataGridView.Column("name").DefaultCellStyle.Format applied to all columns (it shouldn't be)

Johan Hakkesteegt22-Apr-15 20:31

Re: DataGridView.Column("name").DefaultCellStyle.Format applied to all columns (it shouldn't be)

22-Apr-15 20:31

Hi,

In VB the switch works like this. In other words, "Select the first case which' outcome conforms to the main statement".

It appears that the codeproject editor dropped the stars from the pattern matching.

Regards,
Johan

My advice is free, and you may get what you paid for.

Eddy Vluggen22-Apr-15 22:38

Eddy Vluggen

22-Apr-15 22:38

Johan Hakkesteegt wrote:
In VB the switch works like this.

Never seen it before; nice to learn something new Thumbs Up | :thumbsup:

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Unsure How to Approach New Personal Project

cyberphreak198121-Apr-15 7:06

cyberphreak1981

21-Apr-15 7:06

Im starting a new personal project and it is years since I have done any coding. I do understand C++ to a basic level, however Im looking for convenience here and not attempting to program the next OS of the future.

Anyway Im basically wanting to write a program that stores basic rehearsal scripts for a language class I am part of.

I want to be able to quickly create a script to practice various language techniques from.

The basic scripts will fall into categories.

The basic structure goes something like this (I want to be able to alter this if needs be, in fact I probably will want to alter this).

Script Type 1

Script Type 2 part a
Script Type 2 part b
Script Type 2 part c

Script Type 3

Script Type 4 part a
Script Type 4 part b
Script Type 4 part c

For example script Type 1 will be an introductionary statement
Type 2 will be information about me. And so forth. The idea being I can print off a sheet of conversation for someone to speak from. SO they dont need to think what they are saying just how to say it.

For each of these script types I will have a collection of different scripts of varying length.

Each type will have multiple lines in the structure of

ME:
YOU:
ME:
YOU:
....

Im sure you get the idea.

I want to be able to select which scripts I use for each of the Types and Parts from a growing collection.

Now here is where my issues arise.

Should I create a database or use some sort of text file parsing?

I am unsure how many Script types that I want (basic at the minute but this could grow).

If I use text file parsing, will it make sense to have a different (small) text file for each script and some sort of header at the top so it can be recognised?

Or should I do one big text file with Headers?

Or a text file for each script type?

As for printing this off, I am planning on having it outputted in HTML to a web browser so that the print out looks attractive.

My other thought is to maybe use a database, but I think this is possibly overkill for this.

I also want to create a script input screen so I can input new scripts to be stored, using whatever storage medium is the best.

Please advise. I have used text parsing in the past and I have used databases in the past. But for this project I am just wondering what would bee most effective.

By the way when I say language I mean foreign language.

Please advise.

Sascha Lefèvre21-Apr-15 7:24

Sascha Lefèvre

21-Apr-15 7:24

I would suggest you to go with a database. While certainly possible, I would find a collection of text files where I have to parse headers a bit messy. And updates to the data and structure would be more convenient with SQL (with the exception of single-file updates where you otherwise could just use a text editor). If you would ever decide to introduce more relational data you would start running into trouble with single files.

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

cyberphreak198121-Apr-15 7:27

cyberphreak1981

21-Apr-15 7:27

Thank you for your response.

Final question should I store all the scripts in the database or just use the database to point to a file name.

This might sound a dumb question, but I have only used databases for storing specific information such as personal info and billing info?

Sascha Lefèvre21-Apr-15 7:36

Sascha Lefèvre

21-Apr-15 7:36

I would store the scripts in the database. The only advantage I could see not doing this (and just storing the file name instead) would be the ease of editing a script by opening it with a text editor - so you wouldn't have to implement a functionality for that. But the drawback would be that you give up one of the database's benefits: data integrity.

If you probably want to offer your application to your class mates you might want to choose a single-file database system for ease of setup (SQLite would be my recommendation).

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

cyberphreak198121-Apr-15 7:40

cyberphreak1981

21-Apr-15 7:40

Thanks, I am looking into SQLite now.

What I am planning on doing is having two tables.

One table as follows

Script_ID (PK, FK)
Script Name
Type

And the other

Line_ID (PK)
Script_ID (FK)
Line
Speaker (Me/You)

Then I can leave the formatting for when an HTML file is created.

Cheers for your help. Makes sense now on how I can make this work.

modified 21-Apr-15 14:03pm.

Entity framework : How to get DBcontext.ChangeTracker.Entries(of ???)) for a class known only at runtime

Sascha Lefèvre21-Apr-15 8:34

Sascha Lefèvre

21-Apr-15 8:34

Your schema draft looks alright.

cyberphreak1981 wrote:
Cheers for your help.

You're welcome!

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

dilkonika20-Apr-15 18:22

Re: Entity framework : How to get DBcontext.ChangeTracker.Entries(of ???)) for a class known only at runtime

20-Apr-15 18:22

I'm using entity framework I'm trying to make a general function that works for an object for which the class is known only at runtime. I have an instruction that use an expression similar to this :

context.ChangeTracker.Entries(of Myobj1)

Of course that if I know the class name "MyObj1" the above expression is working correctly.

But at runtime , I only have an variable :

Dim tp as type

which contain the class , and i need an expression like this :

context.ChangeTracker.Entries(of tp)

Thank you !

Dave Kreskowiak21-Apr-15 1:50

Continue to next step in a for..next loop only when the user press a button.

21-Apr-15 1:50

My bad. I misunderstood what you were doing.

In order for a Generic to work, the types used must be known at compile-time, not run-time.

I've never done what you're trying to do, nor seen it done specifically with EF before, but you may want to look into these[^] possibilities. You'd have to create a method that generates the entire ChangeTracker.Entities() call at runtime.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

modified 21-Apr-15 8:42am.

dilkonika18-Apr-15 17:59

Re: Continue to next step in a for..next loop only when the user press a button.

18-Apr-15 17:59

I'm using vb.net , and I have this situation :

I have a button on the form( Mybutton1 ) .

I have also a sub that contains a for..next loop :

.....
for I=1 to nr1 
    {.... some instructions...}
   if condition1 then  Mybutton1.enable=true
Next

On every step of this For loop , the button became enabled when a condition is true .In this case I want that this loop to stop until the user press the Button. ( the button's click event , at the end has some instructions that makes the button disabled again )

Is there any way to do this behavior ?

Thank you !

PIEBALDconsult18-Apr-15 18:52

PIEBALDconsult

18-Apr-15 18:52

You probably don't want a for loop.

Re: Continue to next step in a for..next loop only when the user press a button.

dilkonika18-Apr-15 19:01

Re: Continue to next step in a for..next loop only when the user press a button.

18-Apr-15 19:01

I described my problem in my post.
So I need response for the case when I need a for loop.

PIEBALDconsult18-Apr-15 19:21

PIEBALDconsult

18-Apr-15 19:21

Contrarywise; you described a case where you don't want a for loop.

Re: Continue to next step in a for..next loop only when the user press a button.

dilkonika18-Apr-15 19:41

Re: Continue to next step in a for..next loop only when the user press a button.

18-Apr-15 19:41

I described a case when I already have a for loop.
And if in one step of this loop , the button became enabled , the loop should be stopped , and to go to to the next step the user should press the button.
If the condition is always false , the for loop should continue until the end without interruption.

This is my case.
Is there any solution for this case ?

Thank you !

( I'm not asking if there's another way to do , because you can't give an opinion since you don't know nothing about my program , except the little part that I have described here)

Richard MacCutchan18-Apr-15 21:11

Richard MacCutchan

18-Apr-15 21:11

You should add a test in your loop to see if the button is enabled, so you can exit the loop if it is. There are other ways to do this, which is why PIEBALDconsult[^] made the comments that he did.

dilkonika wrote:
you can't give an opinion since you don't know nothing about my program

Comments like that do not endear you to people here. And given the number of questions you have posted recently, you really do not want to get a reputation as someone who does not accept well meaning advice.

Re: Continue to next step in a for..next loop only when the user press a button.

dilkonika19-Apr-15 4:54

Re: Continue to next step in a for..next loop only when the user press a button.

19-Apr-15 4:54

I think you misunderstand what I mean with my words.
I mean that someone can't give an opinion that should I use or not an For..Next loop because he don't know all the logic of my program.

So why you want to comment the question instead of try to give a response. The question is very clear.
If there's no answer , respond "it's not possible.".

And about the reputation , I'm not interested , because I'm more interested about the answers of my questions.

Dave Kreskowiak19-Apr-15 5:26