Posts

Showing posts from July, 2019

Dynamic row with pass data to controller

-
View -------------------------------------------------------------------------------------------------------------------------- @model IEnumerable<Insert_Multiple_Rows_EF_MVC.Models.CustomerModel> @using Insert_Multiple_Rows_EF_MVC.Models @{     Layout = null; } <!DOCTYPE html> <html> <head>     <meta name="viewport" content="width=device-width" />     <title>Index</title>     <style type="text/css">         body {             font-family: Arial;             font-size: 10pt;         }         .table {             border: 1px solid #ccc;             border-collapse: collapse;         }             .table th {           ...
Post a Comment
Read more

Pass user defined table value in store procedure using Entity framework.

-
public int RequestTypeInsert<T>(int companyId, IEnumerable<T> data)         {             using (CustomerServicesManagementModelContainer context = new CustomerServicesManagementModelContainer())             {                 //// convert source data to DataTable                 DataTable table = data.ToDataTable();                 List<SqlParameter> _sqlParameters = new List<SqlParameter>() {                     new SqlParameter { ParameterName= "@CompanyID",Value=companyId,SqlDbType = SqlDbType.Int },                     new SqlParameter { ParameterName= "@tvpRequestType",Value=table,SqlDbType = SqlDbType.Structured,TypeName="SERTICRequestTypeInsert" }}; ...
Post a Comment
Read more