Cannot implicitly convert type 'int' to 'System.Data.DataTable'

Question

I am trying to update some field in my data table. While using the given below code shows one error. Help me to find a proper solution. Thank you.

Code:

ShadingAnalysisDataSetTableAdapters.tbl_AutoAssignJrEngineersTeamTableAdapter tm;
tm = new ShadingAnalysisDataSetTableAdapters.tbl_AutoAssignJrEngineersTeamTableAdapter();
DataTable dt = new DataTable();
dt = tm.UpdateTeam(AssignedTeam,userName,DateTime.Now,ID); // error popup here

SQL:

UPDATE tbl_AutoAssignJrEngineersTeam 
SET Assigned_Team = @Assigned_Team, 
    Updated_By = @Updated_By, 
    Updated_Date = @Updated_Date 
WHERE (Id = @Id)

DataBase:

enter image description here

Somewhere you have an int and try to cast it explicitly or implicitly to a DataTable. My guess would be the tm.UpdateTeam method returns an int. — Dirk
– Dirk, Commented Nov 7, 2014 at 10:59
possible duplicate of Cannot implicitly convert type 'int' to 'string' ? c#4 — Jad
– Jad, Commented Nov 13, 2014 at 4:33

Tim Schmelter · Accepted Answer · 2014-11-07 11:07:19Z

4

The TableAdapter-method returns an int which is the count of affected records, so how many records were updated. But you are assigning it to a DataTable variable.

int updatedRows = tm.UpdateTeam(AssignedTeam,userName,DateTime.Now,ID);

You either have to

load the table again with the appropriate GetData- or Fill(dt) methods from the TableAdapter
or update the rows in the table and use tm.Update(modifiedDataTable) instead which will execute the UpdateCommand of the adapater for every row with RowState=Modified.

edited Nov 7, 2014 at 11:07

answered Nov 7, 2014 at 11:00

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

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

Collectives™ on Stack Overflow

Cannot implicitly convert type 'int' to 'System.Data.DataTable'

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related