Error"Cannot implicitly convert type 'string' to 'System.Type'

Question

I am getting an error for the sorting in the format "dd-mmm-yyyy" it should sort date,month,year wise when binding to grid

"Cannot implicitly convert type 'string' to 'System.Type'"

DataView dw = PurchaseRequestDetails.Tables[0].DefaultView;
DateTime NowDate = System.DateTime.Now;
string NewDate = NowDate.ToString("dd-MMM-yyyy");
dw.Table.Columns["RequiredDate"].DataType = NewDate.ToString();

dw.Sort = "RequiredDate ASC";
foreach (DataRowView dr in dw)
{
    System.Diagnostics.Debug.WriteLine("RequiredDate: " + dr["RequiredDate"].ToString());
}

dgvPurReq.DataSource = dw;
dgvPurReq.DataBind();

Use camelCase (instead of PascalCase) for local variables if you want to be consistent with the .NET Framework naming conventions. — zneak
– zneak, Commented Aug 10, 2010 at 4:45

Ivan Butsyrin · Accepted Answer · 2010-08-10 04:47:29Z

3

The error is in the line: dw.Table.Columns["RequiredDate"].DataType = NewDate.ToString();

The DataType property gets or sets the type of data stored in the selected column. http://msdn.microsoft.com/en-us/library/system.data.datacolumn.datatype.aspx

answered Aug 10, 2010 at 4:47

Ivan Butsyrin

1631 gold badge1 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Muad'Dib · Accepted Answer · 2010-08-10 04:45:43Z

2

you are setting the data type of the column to the contents of the string which is the current date-time. The current date-time is NOT a valid type. Also, I am pretty sure that changing the data-type of an existing column with data in it will throw an exception as well.

if you remove these three lines

DateTime NowDate = System.DateTime.Now;
string NewDate = NowDate.ToString("dd-MMM-yyyy");
dw.Table.Columns["RequiredDate"].DataType = NewDate.ToString();

I suspect this will work the way you are trying to get it to work.

answered Aug 10, 2010 at 4:45

Muad'Dib

29.4k5 gold badges58 silver badges71 bronze badges

Comments

STW · Accepted Answer · 2010-08-10 04:50:52Z

2

string NewDate = NowDate.ToString("dd-MMM-yyyy");
dw.Table.Columns["RequiredDate"].DataType = NewDate.ToString();

The second line is key; you're assinging a string (NewDate.ToString()) to a property that accepts a Type as a value.

In .NET everything has a Type, but there are also instances of System.Type. It's basically a special/specific class which describes another class (but isn't actually an instance of that class). A rough simile is that it's like a blueprint--it describes something but it's not the real thing.h

To retrieve an instance of a Type you can use the typeof() operator

answered Aug 10, 2010 at 4:50

STW

46.8k17 gold badges109 silver badges170 bronze badges

Comments

Fadrian Sudaman · Accepted Answer · 2010-08-10 04:53:22Z

2

You can fix it by setting the DataType to a type using typeof(DateTime) or DateTime.Now.GetType(). But what I dont understand is why do you do that? The DataView is returned with a list of rows and columns and from the code above, you are just using it, why do you want to change the data type? Perhaps what you want is to format the data on display?

answered Aug 10, 2010 at 4:53

Fadrian Sudaman

6,47524 silver badges29 bronze badges

2 Comments

Kajah User Over a year ago

i need a sorting in this format according the date,year,month in server side coing dd-MMM-yyyy

Fadrian Sudaman Over a year ago

Alright I get it now. But then your code is not representative enough. You have added the column and using it but you havent assigned the value to that new column.

Gishu · Accepted Answer · 2010-08-10 06:08:25Z

Please include the line number of the error next time... as that helps.
It seems that you're assigning a string to the DataType property of DataColumn, which expects a Type object. So the fix would be...

dw.Table.Columns["RequiredDate"].DataType = NewDate.GetType(); // or typeof(DateTime)

Update (for problem#2 - sort doesn't happen) Adapted from the code snippet from this MSDN Page (look here for implementation of the helper methods). Formatting of the DataColumn should be the responsibility of the presentation layer/consumer. However if you really need to do this in the DataView - link

private static void DemonstrateDataView(){
   // Create one DataTable with one column.
   DataTable myTable = new DataTable("myTable");
   DataColumn colItem = new DataColumn("item",typeof(DateTime));

  myTable.Columns.Add(colItem);
   // Add five items.
   DataRow NewRow;
   for(int i = 0; i <5; i++){
      NewRow = myTable.NewRow();
      NewRow["item"] = DateTime.Now.AddDays(-i);
      myTable.Rows.Add(NewRow);
   }
   myTable.AcceptChanges();
   // Print current table values.
   PrintTableOrView(myTable,"Current Values in Table");

   DataView secondView = new DataView(myTable);
   secondView.Sort = "item";

   PrintTableOrView(secondView, "Second DataView: ");
}

Output:

Current Values in Table
        8/10/2010 11:34:28 AM
        8/9/2010 11:34:28 AM
        8/8/2010 11:34:28 AM
        8/7/2010 11:34:28 AM
        8/6/2010 11:34:28 AM

Second DataView: 
        8/6/2010 11:34:28 AM
        8/7/2010 11:34:28 AM
        8/8/2010 11:34:28 AM
        8/9/2010 11:34:28 AM
        8/10/2010 11:34:28 AM

@vigna... it worked for me. Second DataView is sorted in Asc order of date. Compare your code against the above and look for differences.

Collectives™ on Stack Overflow

Error"Cannot implicitly convert type 'string' to 'System.Type'

5 Answers 5

Comments

Comments

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related