Loading

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

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

swapna

5y931.NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

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

swapna5y ago

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

+1

Asma Khalid

Asma Khalid5y ago

Look into this https://bit.ly/3mmOY75

Mark answer as accepted if helpful

Thanks & Regards,

Asma Khalid

+1

Shweta Lodha

Shweta Lodha5y ago

If you are getting any specific error, please share.

+1

Shweta Lodha

Shweta Lodha5y ago

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);
}
}

+1