471,354 Members | 1,500 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

datacolumn

im Trying to set a Datacolumn type for a new table

boolean is not working, What is the correct waty

//column.DataType = System.Type.GetType"System.Data.SqlTypes.SqlBoolea n");

column.DataType = System.Type.GetType"System.Boolean"); //"System.Boolean");

tia

Dave


Sep 16 '07 #1
3 6033
the above is corrected....
but im haveing a problem creating a datacolumn for sqlmoney
examples plz

DaveP

"DaveP" <dv*****@sbcglobal.netwrote in message
news:aP****************@newssvr14.news.prodigy.net ...
im Trying to set a Datacolumn type for a new table

boolean is not working, What is the correct waty

//column.DataType = System.Type.GetType"System.Data.SqlTypes.SqlBoolea n");

column.DataType = System.Type.GetType"System.Boolean");
//"System.Boolean");

tia

Dave


Sep 16 '07 #2
hello,
check this sample

public DataTable MakeDataTable(){

DataTable myTable;
DataRow myNewRow;
// Create a new DataTable.
myTable = new DataTable("My Table");

// Create DataColumn objects of data types.
DataColumn colString = new DataColumn("StringCol");
colString.DataType = System.Type.GetType("System.String");
myTable.Columns.Add(colString);

DataColumn colInt32 = new DataColumn("Int32Col");
colInt32.DataType = System.Type.GetType("System.Int32");
myTable.Columns.Add(colInt32);

DataColumn colBoolean = new DataColumn("BooleanCol");
colBoolean.DataType = System.Type.GetType("System.Boolean");
myTable.Columns.Add(colBoolean);

DataColumn colTimeSpan = new DataColumn("TimeSpanCol");
colTimeSpan.DataType = System.Type.GetType("System.TimeSpan");
myTable.Columns.Add(colTimeSpan);

DataColumn colDateTime = new DataColumn("DateTimeCol");
colDateTime.DataType = System.Type.GetType("System.DateTime");
myTable.Columns.Add(colDateTime);

DataColumn colDecimal = new DataColumn("DecimalCol");
colDecimal.DataType = System.Type.GetType("System.Decimal");
myTable.Columns.Add(colDecimal);

// Populate one row with values.
myNewRow = myTable.NewRow();

myNewRow["StringCol"] = "Item Name";
myNewRow["Int32Col"] = 2147483647;
myNewRow["BooleanCol"] = true;
myNewRow["TimeSpanCol"] = new TimeSpan(10,22,10,15,100);
myNewRow["DateTimeCol"] = System.DateTime.Today;
myNewRow["DecimalCol"] = 64.0021;
myTable.Rows.Add(myNewRow);
return myTable;
}

Cheers !

Husam Al-A'araj
www.aaraj.net
"DaveP" wrote:
im Trying to set a Datacolumn type for a new table

boolean is not working, What is the correct waty

//column.DataType = System.Type.GetType"System.Data.SqlTypes.SqlBoolea n");

column.DataType = System.Type.GetType"System.Boolean"); //"System.Boolean");

tia

Dave


Sep 16 '07 #3
thanks alot
Davep

"Husam Al-A''araj" <Hu**********@discussions.microsoft.comwrote in message
news:BE**********************************@microsof t.com...
hello,
check this sample

public DataTable MakeDataTable(){

DataTable myTable;
DataRow myNewRow;
// Create a new DataTable.
myTable = new DataTable("My Table");

// Create DataColumn objects of data types.
DataColumn colString = new DataColumn("StringCol");
colString.DataType = System.Type.GetType("System.String");
myTable.Columns.Add(colString);

DataColumn colInt32 = new DataColumn("Int32Col");
colInt32.DataType = System.Type.GetType("System.Int32");
myTable.Columns.Add(colInt32);

DataColumn colBoolean = new DataColumn("BooleanCol");
colBoolean.DataType = System.Type.GetType("System.Boolean");
myTable.Columns.Add(colBoolean);

DataColumn colTimeSpan = new DataColumn("TimeSpanCol");
colTimeSpan.DataType = System.Type.GetType("System.TimeSpan");
myTable.Columns.Add(colTimeSpan);

DataColumn colDateTime = new DataColumn("DateTimeCol");
colDateTime.DataType = System.Type.GetType("System.DateTime");
myTable.Columns.Add(colDateTime);

DataColumn colDecimal = new DataColumn("DecimalCol");
colDecimal.DataType = System.Type.GetType("System.Decimal");
myTable.Columns.Add(colDecimal);

// Populate one row with values.
myNewRow = myTable.NewRow();

myNewRow["StringCol"] = "Item Name";
myNewRow["Int32Col"] = 2147483647;
myNewRow["BooleanCol"] = true;
myNewRow["TimeSpanCol"] = new TimeSpan(10,22,10,15,100);
myNewRow["DateTimeCol"] = System.DateTime.Today;
myNewRow["DecimalCol"] = 64.0021;
myTable.Rows.Add(myNewRow);
return myTable;
}

Cheers !

Husam Al-A'araj
www.aaraj.net
"DaveP" wrote:
>im Trying to set a Datacolumn type for a new table

boolean is not working, What is the correct waty

//column.DataType =
System.Type.GetType"System.Data.SqlTypes.SqlBoole an");

column.DataType = System.Type.GetType"System.Boolean");
//"System.Boolean");

tia

Dave



Sep 16 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by J | last post: by
1 post views Thread by Chris | last post: by
5 posts views Thread by JC Voon | last post: by
1 post views Thread by Jay Balapa | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.