How to Convert

[Miro]

How can I convert this part of the line:
Me.dgvmyData.Co lumns.Item("txt CellName") ' "txtCellNam e"
which is within this line -
Me.dgvmyData.So rt(Me.dgvmyData .Columns.Item(" txtCellName"),
System.Componen tModel.ListSort Direction.Ascen ding)

To read something like:
Me.dgvmyData.Co lumns.Item( nonQuotedVariab le )

So I do not have to use a "String" variable to specify the column name.
I made an error in on one of my datagrids and Im sure there is a way to
specify the column name without using a string character that could result
in errors ( like I created ).

Thanks

Miro

[James Hahn]

To use a non-quoted variable as the column identifier, simply assign the
column name to a variable:

nonQuotedVariab le = "txtCellNam e"
Me.dgvmyData.So rt(Me.dgvmyData .Columns.Item(n onQuotedVariabl e),
System.Componen tModel.ListSort Direction.Ascen ding)

You are not using a "String" variable to specify the column name - you are
using a string literal. The change suggested above replaces the string
literal with a string variable. You must use string - either a literal or a
variable, to identify the column.

However, if you know the column index you can use an integer variable to
specify the column in the sort instruction. Is your question that you don't
know how to get the column index of a column where all you know is the
column name?

"Miro" <mi**@beero.com wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

How can I convert this part of the line:
Me.dgvmyData.Co lumns.Item("txt CellName") ' "txtCellNam e"
which is within this line -
Me.dgvmyData.So rt(Me.dgvmyData .Columns.Item(" txtCellName"),
System.Componen tModel.ListSort Direction.Ascen ding)

To read something like:
Me.dgvmyData.Co lumns.Item( nonQuotedVariab le )

So I do not have to use a "String" variable to specify the column name.
I made an error in on one of my datagrids and Im sure there is a way to
specify the column name without using a string character that could result
in errors ( like I created ).

Thanks

Miro

[Miro]

"James Hahn" <jh***@yahoo.co mwrote in message
news:e3******** ******@TK2MSFTN GP02.phx.gbl...

To use a non-quoted variable as the column identifier, simply assign the
column name to a variable:

nonQuotedVariab le = "txtCellNam e"
Me.dgvmyData.So rt(Me.dgvmyData .Columns.Item(n onQuotedVariabl e),
System.Componen tModel.ListSort Direction.Ascen ding)

You are not using a "String" variable to specify the column name - you are
using a string literal. The change suggested above replaces the string
literal with a string variable. You must use string - either a literal or
a variable, to identify the column.

However, if you know the column index you can use an integer variable to
specify the column in the sort instruction. Is your question that you
don't know how to get the column index of a column where all you know is
the column name?

"Miro" <mi**@beero.com wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

>How can I convert this part of the line:
Me.dgvmyData.C olumns.Item("tx tCellName") ' "txtCellNam e"
which is within this line -
Me.dgvmyData.S ort(Me.dgvmyDat a.Columns.Item( "txtCellNam e"),
System.Compone ntModel.ListSor tDirection.Asce nding)

To read something like:
Me.dgvmyData.C olumns.Item( nonQuotedVariab le )

So I do not have to use a "String" variable to specify the column name.
I made an error in on one of my datagrids and Im sure there is a way to
specify the column name without using a string character that could
result in errors ( like I created ).

Thanks

Miro

Hi James,

I am not looking to "assign" my column name to a string variable... I am
looking for something like this:
( I just dont know the right terminology I am looking for - it might be
"IntelliSen se" )
Lets pretend we are just dealing with this part of the line:
Me.dgvmyData.Co lumns.Item("txt CellName")

I am looking to do something like this:
Me.dgvmyData.Co lumns.Item.txtC ellName

(So I get an error at design time if I miss-spell txtCellName to
txtCellTypoName vs getting an error at runtime)

For example...
Here is the same example how it would relate to with a typed dataset:

Lets say I do this:
Dim currentRow As DataRow
'Then fill the datarow
'Then to reference the datarow I would have to do something like this:
currentRow ("AFieldInTheTa ble") = "Hello"

But I am better off writing this example like this:
Dim currentRow as Dataset.DataTab leRow
'Then fill the datarow
'*** Now notice how I cant make an error getting the field name because:
currentRow.AFie ldInTheTable = "Hello"
'is better than type this out currentRow ("AFieldInTypoT heTable") and now I
get an exception error at runtime vs an error at design time.

Thanks

Miro

[Branco Medeiros]

Miro wrote:

How can I convert this part of the line:
Me.dgvmyData.Co lumns.Item("txt CellName") * ' "txtCellNam e"
which is within this line -
Me.dgvmyData.So rt(Me.dgvmyData .Columns.Item(" txtCellName"),
System.Componen tModel.ListSort Direction.Ascen ding)

To read something like:
Me.dgvmyData.Co lumns.Item( nonQuotedVariab le )

So I do not have to use a "String" variable to specify the column name.

<snip>

If you are defining the DataGridView content at design time, then the
designer creates named columns for you, which you can use instead of
refering to the columns by index or name.

These automaticaly created columns will have names such as
DataGridViewTex tBoxColumn1, DataGridViewTex tBoxColumn2, etc, or
something like it, depending on how you created the association
between the GridView and the data source.

Suppose then, that the column you want to sort is for a field named
CustomerName in the data source. Chances are you'll have a control
named CustomerNameDat aGridViewTextBo xColumn (ouch!). You can use this
control explicitly in your call to Sort:

<example>
Me.dgvmyData.So rt(Me.CustomerN ameDataGridView TextBoxColumn, _
System.Componen tModel.ListSort Direction.Ascen ding)
</example>

(Personaly, I change all column names upon creation to something more
manageable. You can do that by selecting "Edit Columns..." in the
properties window and edit the column's (Name) field in the Design
section)
Hope this helps.

Branco.

[James Hahn]

Since the column name can be changed at run time, it's not possible to hard
code the name and be certain that there will not be an error at run time.
Use the column index instead of the name. That virtually eliminates the
possibility of a typo.

"Miro" <mi**@beero.com wrote in message
news:Om******** ******@TK2MSFTN GP05.phx.gbl...

>
"James Hahn" <jh***@yahoo.co mwrote in message
news:e3******** ******@TK2MSFTN GP02.phx.gbl...

>To use a non-quoted variable as the column identifier, simply assign the
column name to a variable:

nonQuotedVaria ble = "txtCellNam e"
Me.dgvmyData.S ort(Me.dgvmyDat a.Columns.Item( nonQuotedVariab le),
System.Compone ntModel.ListSor tDirection.Asce nding)

You are not using a "String" variable to specify the column name - you
are using a string literal. The change suggested above replaces the
string literal with a string variable. You must use string - either a
literal or a variable, to identify the column.

However, if you know the column index you can use an integer variable to
specify the column in the sort instruction. Is your question that you
don't know how to get the column index of a column where all you know is
the column name?

"Miro" <mi**@beero.com wrote in message
news:%2******* *********@TK2MS FTNGP05.phx.gbl ...

>>How can I convert this part of the line:
Me.dgvmyData. Columns.Item("t xtCellName") ' "txtCellNam e"
which is within this line -
Me.dgvmyData. Sort(Me.dgvmyDa ta.Columns.Item ("txtCellName") ,
System.Compon entModel.ListSo rtDirection.Asc ending)

To read something like:
Me.dgvmyData. Columns.Item( nonQuotedVariab le )

So I do not have to use a "String" variable to specify the column name.
I made an error in on one of my datagrids and Im sure there is a way to
specify the column name without using a string character that could
result in errors ( like I created ).

Thanks

Miro

Hi James,

I am not looking to "assign" my column name to a string variable... I am
looking for something like this:
( I just dont know the right terminology I am looking for - it might be
"IntelliSen se" )
Lets pretend we are just dealing with this part of the line:
Me.dgvmyData.Co lumns.Item("txt CellName")

I am looking to do something like this:
Me.dgvmyData.Co lumns.Item.txtC ellName

(So I get an error at design time if I miss-spell txtCellName to
txtCellTypoName vs getting an error at runtime)

For example...
Here is the same example how it would relate to with a typed dataset:

Lets say I do this:
Dim currentRow As DataRow
'Then fill the datarow
'Then to reference the datarow I would have to do something like this:
currentRow ("AFieldInTheTa ble") = "Hello"

But I am better off writing this example like this:
Dim currentRow as Dataset.DataTab leRow
'Then fill the datarow
'*** Now notice how I cant make an error getting the field name because:
currentRow.AFie ldInTheTable = "Hello"
'is better than type this out currentRow ("AFieldInTypoT heTable") and now
I get an exception error at runtime vs an error at design time.

Thanks

Miro

[Miro]

"Branco Medeiros" <br************ *@gmail.comwrot e in message
news:a4******** *************** ***********@a70 g2000hsh.google groups.com...
Miro wrote:

How can I convert this part of the line:
Me.dgvmyData.Co lumns.Item("txt CellName") ' "txtCellNam e"
which is within this line -
Me.dgvmyData.So rt(Me.dgvmyData .Columns.Item(" txtCellName"),
System.Componen tModel.ListSort Direction.Ascen ding)

To read something like:
Me.dgvmyData.Co lumns.Item( nonQuotedVariab le )

So I do not have to use a "String" variable to specify the column name.

<snip>

If you are defining the DataGridView content at design time, then the
designer creates named columns for you, which you can use instead of
refering to the columns by index or name.

These automaticaly created columns will have names such as
DataGridViewTex tBoxColumn1, DataGridViewTex tBoxColumn2, etc, or
something like it, depending on how you created the association
between the GridView and the data source.

Suppose then, that the column you want to sort is for a field named
CustomerName in the data source. Chances are you'll have a control
named CustomerNameDat aGridViewTextBo xColumn (ouch!). You can use this
control explicitly in your call to Sort:

<example>
Me.dgvmyData.So rt(Me.CustomerN ameDataGridView TextBoxColumn, _
System.Componen tModel.ListSort Direction.Ascen ding)
</example>

(Personaly, I change all column names upon creation to something more
manageable. You can do that by selecting "Edit Columns..." in the
properties window and edit the column's (Name) field in the Design
section)
Hope this helps.

Branco.

=============== ==

Hi Branco,

How did you get this example to work:
<example>
Me.dgvmyData.So rt(Me.CustomerN ameDataGridView TextBoxColumn, _
System.Componen tModel.ListSort Direction.Ascen ding)
</example>

By putting 'just the txtColumnName' in the first variable of the sort - you
will get a runtime error that the column does not exist in the datagridview.

By going back to my original example, and using the
Me.dgvmyData.Co lumns.Item("txt ColName") example, this only allows 2
overloads. 1 is the column index, and 2 is the Name as string.
I am looking for some overload to put the actual column name in there.

I do not want to use the 'string' example cause I came accross this by
making a type.
I do not want to use a column index cause if i forget this 'sort' is in my
code and i reference the index as a number and go re-arrange my grid later
on - i will cause another bug.

I am starting to think there is no way for intellisense to do this, Unless I
create a quick 'do loop' and fly thru the columns in my datagrid view.
Search for my "txtColName " - if it found it - use that column index, if it
didnt, do not sort.
Kind of silly but thats my only current solution.

Miro

[Branco Medeiros]

Miro wrote:

(1)
<snip>

How did you get this example to work:
<example>
Me.dgvmyData.So rt(Me.CustomerN ameDataGridView TextBoxColumn, _
* System.Componen tModel.ListSort Direction.Ascen ding)
</example>

By putting 'just the txtColumnName' in the first variable of the sort - you
will get a runtime error that the column does not exist in the datagridview.

</snip>

(2)
<snip>

By going back to my original example, and using the
Me.dgvmyData.Co lumns.Item("txt ColName") example, this only allows 2
overloads. *1 is the column index, and 2 is the Name as string.
I am looking for some overload to put the actual column name in there.

</snip>

Hi, Miro!

1) Of course, you must use the actual control name, I don't know how
the editor named the controls for the columns you are using. To see
the actual control name, right-click the grid, select "Edit
columns...", select the column in the left panel (under "selected
columns") and verify its name in the right panel (under "Bound Column
Properties"). The control name will be in the (Name) field.

2) Maybe I'm not being clear enough. I'm talking about the actual
column control as parameter for the **DataGridView. Sort** method, not
the parameter for the **DataGriView.C olumn.Item** property.

These column controls were created automatically for you and are
accessible at form level, just type Me, dot, and presto!, the control
list will appear, pick the column control name from there! =))).
(That's why I rename then, it's way easier to pick then up when you
actually know the control's name! =))

You are correct in not wanting to use the "string name" or the
column's index. If you ever need a column's name or index, you can get
then from the control itself (from the properties "Name", "Index" or
"DisplayIndex") .

Hope this helps.

Branco.

[Miro]

"Branco Medeiros" <br************ *@gmail.comwrot e in message
news:16******** *************** ***********@y38 g2000hsy.google groups.com...
Miro wrote:

(1)
<snip>

How did you get this example to work:
<example>
Me.dgvmyData.So rt(Me.CustomerN ameDataGridView TextBoxColumn, _
System.Componen tModel.ListSort Direction.Ascen ding)
</example>

By putting 'just the txtColumnName' in the first variable of the sort -
you
will get a runtime error that the column does not exist in the
datagridview.

</snip>

(2)
<snip>

By going back to my original example, and using the
Me.dgvmyData.Co lumns.Item("txt ColName") example, this only allows 2
overloads. 1 is the column index, and 2 is the Name as string.
I am looking for some overload to put the actual column name in there.

</snip>

Hi, Miro!

1) Of course, you must use the actual control name, I don't know how
the editor named the controls for the columns you are using. To see
the actual control name, right-click the grid, select "Edit
columns...", select the column in the left panel (under "selected
columns") and verify its name in the right panel (under "Bound Column
Properties"). The control name will be in the (Name) field.

2) Maybe I'm not being clear enough. I'm talking about the actual
column control as parameter for the **DataGridView. Sort** method, not
the parameter for the **DataGriView.C olumn.Item** property.

These column controls were created automatically for you and are
accessible at form level, just type Me, dot, and presto!, the control
list will appear, pick the column control name from there! =))).
(That's why I rename then, it's way easier to pick then up when you
actually know the control's name! =))

You are correct in not wanting to use the "string name" or the
column's index. If you ever need a column's name or index, you can get
then from the control itself (from the properties "Name", "Index" or
"DisplayIndex") .

Hope this helps.

Branco.
=============== ===============

Hi Branco,

I must still be missing something:

My datagrid name is dgvRounds
My column ( or one of them ) is named 'txtRounds' - i have already renamed
it.
I have my data filled in the datagrid.

What I am understanding is that I can sort my datagrid like this ( by your
code )

Me.dgvRounds.So rt(Me.txtRound,
System.Componen tModel.ListSort Direction.Ascen ding)

The error I get - during runtime is:
Column provided does not belong to this DataGridVew control

The way I am adding the column is like this:
On the form load:
Dim index As Integer
Dim dgvMaskedEdit As DataGridViewMas kedEditColumn 'custom class
that is a masked edit column

'find old column that is just a text box and remove it and add the
masked edit text box in its place.
index = dgvRounds.Colum ns.IndexOf(dgvR ounds.Columns(" txtRound"))
dgvRounds.Colum ns.Remove("txtR ound")
' create a new custom column
dgvMaskedEdit = New DataGridViewMas kedEditColumn
dgvMaskedEdit.M ask = "###"
dgvMaskedEdit.P romptChar = " "c
dgvMaskedEdit.V alidatingType = GetType(Integer )
dgvMaskedEdit.N ame = "txtRound"
dgvMaskedEdit.D ataPropertyName = "PlayRound"
dgvMaskedEdit.H eaderText = "Round"
' some more tweaking
dgvMaskedEdit.S ortMode = DataGridViewCol umnSortMode.Pro grammatic
' insert the new column at the same location
dgvRounds.Colum ns.Insert(index , dgvMaskedEdit)
------
so i can access Me.txtRound as a control, but I cannot figure out how to
sort it by that column using the datagridview, unless i use "txtRound"
You mentioned the "method"... im looking for help here:
http://msdn.microsoft.com/en-us/library/ms171608.aspx
and cant seem to find what you are refering to.
I have found this link:
http://msdn.microsoft.com/en-us/library/0868ft3z.aspx

In the example given, it gets the index thru searching which column is
selected.

I know my index by index =
dgvRounds.Colum ns.IndexOf(dgvR ounds.Columns(" txtRound"))
Thank you for your patients.

Miro

[Steve Gerrard]

Miro wrote:

"Branco Medeiros" <br************ *@gmail.comwrot e in message
news:16******** *************** ***********@y38 g2000hsy.google groups.com...
Miro wrote:
Me.dgvRounds.So rt(Me.txtRound,
System.Componen tModel.ListSort Direction.Ascen ding)

This will be compiled at compile time to refer to the existing column in the
datagrid.

dgvRounds.Colum ns.Remove("txtR ound") ' create a new custom

Now it is not in the grid.

dgvMaskedEdit.N ame = "txtRound"
' insert the new column at the same location
dgvRounds.Colum ns.Insert(index , dgvMaskedEdit)

That's not the same column, even if it has the same name. :(

[Branco Medeiros]

Miro wrote:
<snip>

My datagrid name is dgvRounds
My column ( or one of them ) is named 'txtRounds' - i have already renamed
it.
I have my data filled in the datagrid.

What I am understanding is that I can sort my datagrid like this ( by your
code )

Me.dgvRounds.So rt(Me.txtRound,
System.Componen tModel.ListSort Direction.Ascen ding)

The error I get - during runtime is:
Column provided does not belong to this DataGridVew control

The way I am adding the column is like this:
On the form load:
* * * * Dim index As Integer
* * * * Dim dgvMaskedEdit As DataGridViewMas kedEditColumn *'custom class
that is a masked edit column

* * * * 'find old column that is just a text box and remove it and add the
masked edit text box in its place.
* * * * index = dgvRounds.Colum ns.IndexOf(dgvR ounds.Columns(" txtRound"))
* * * * dgvRounds.Colum ns.Remove("txtR ound")

<snip>

* * * * dgvRounds.Colum ns.Insert(index , dgvMaskedEdit)

<snip>

As Steve pointed out, once you remove txtRound from the grid, it
doesn't belong to the gridview anymore. The column you must use to
sort is dgvMaskedEdit.

<example>
Me.dgvRounds.So rt(Me.dgvMasked Edit, _
System.Componen tModel.ListSort Direction.Ascen ding)
</example>

The runtime "Name" property has (almost) nothing to do with the
control's name, which is what you must use =))

Hope that helped.

Branco.