Data columns

Hot Topic

How to Modify Codebase Path for New AppDomain
Fill an irregular shape with color in System.Drawing
Directory.Copy
Strange XmlNodeList behaviour - NullReferenceException
Hai everyone this is new commer may u teach me well with lots of expectations i have joined this forum.
Does NetFx64.exe contain both 32 and 64 bit verions of the Framework?
System.AccessViolationException when accessing DirectoryEntry.Properties
How to count and retrieve the number instances of current process
Overwrite one section of binary file
can ADO.NET use JDBC to get to the SqlServer?

.NET Development

NetworkStream.Read performance
Control Windows Service from Web Application
data transferred through socket exceeds byte buffer size
Assemblies, Versioning, etc....
custom xml output with web service
Generating crystal report in visual web developer express 2005
Webclient gives generic error during Async operations
Interprocess communication between a managed service and an unmanaged application.
TableAdapter Update problem
Loading Access DB in Memory, efficient way ?

Data columns

Howdy

I have several tables on several datagrids and these tables have many rows and columns so to save time and typing ive set them up like so:

Do While count < 6

DtBalance.Columns.Add("", GetType(String))

count = count + 1

Loop

For i = 1 To 37

Row = DtBalance.NewRow

DtBalance.Rows.Add(Row)

DtBalance.AcceptChanges()

Next

Ive then set the rows to clear and be set as nothing like so:

Do While i < DtBalance.Columns.Count

Do While count < 37

DgBalance.Item(count, i) = ""

count = count + 1

Loop

count = 0

i = i + 1

Loop

The problem now is that when i want to input numbers to the tables i cant cause they're all set to string. Can anyone tell me how i can get hold of selected columns to change tier data type

thx

Answer this question

Data columns

  • DTSlurve

    The data type is set on the DataColumn object, which you creating in this line of code:

    DtBalance.Columns.Add("", GetType(String))

    If you want a different type, you need to set it there. For example, instead of GetType(String), use GetType("System.In32").

    Also, you can change the DataType of a column before you have added any data to it, but once the data is added, the type cannot change.

    Thanks,

    Sarah



  • abelegreen

    Yes, as I mentioned in my prevoius reply, you can change the DataType of a column after you have added it, but not after you have added data.

    That means that in your code example, you can change it up until the point where you call Row = DtBalance.NewRow.

    You just need to set the DataType property on the column that you want to change. You can get it from the DataTable.Columns collection after it's already been added. For example, right after your code finishes adding the columns, but before you start adding rows, add this line for a test:

    DtBalance.Columns(0).DataType = GetType(Int32)

    This will change the data type of the first column to Int32 instead of String.

    If this doesn't work for you, please post an updated code sample and any errors that you are seeing.

    Thanks,

    Sarah



  • cyberw&amp;#228;lder

    Ok thats sorted the problem

    thx

  • Knvb1123

    he problem is i want the majority of columns to be string its selected columns i want to be integer. Is there a way to change the data type of a column after ive added them all

    Thx


  • Data columns
Answer this question