datatable not binding entity framework core..pls help..

Question

datatable not binding entity framework core..pls help.i am using namespace system.data

Shweta Lodha · Answer

DataTable table = POPULATE DATA TABLE BY CALLING YOUR FUNCTION var param = new SqlParameter( "@myValues" , table) { TypeName = "dbo.CustomSqlType" , SqlDbType = SqlDbType.Structured }; await dbContext.Database.ExecuteSqlCommandAsync( "EXEC dbo.UpdateValues @myValues" , param);

swapna · Answer

public static DataTable tdt(tr aty) { DataTable dtn= new DataTable(); dtn.Columns.Add("col1", typeof(string)); dtn.Columns.Add("col2", typeof(string)); return dtn; } above is my dattable in .net core 5.0 but data not binding in my datatable.plz help

Asma Khalid · Answer

Look into this https://bit.ly/3mmOY75 Mark answer as accepted if helpful Thanks & Regards, Asma Khalid

Shweta Lodha · Answer

If you are getting any specific error, please share.

Shweta Lodha · Answer

Hello swapna, You can try like this: var dataTable = new DataTable(); var connection = context.Database.Connection; using (var cmd = connection .CreateCommand()) { cmd.CommandText = "YOUR TEXT" ; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add( new SqlParameter( param1 , param2, param3)); using (var reader = cmd.ExecuteReader()) { dataTable.Load(reader); } }

datatable not binding entity framework core..pls help..

Answers (5)