ASP.NET

how to dynamically generate a SQL server query based on the application server received input from the user

Hello

I am getting the following error:

System.Data.OleDb.OleDbException: Operation must use an updateable query.

when I type in a valid user's email (he exists in the Access mdb) on this page:

and have set my permissions accordingly. The folder that houses my Access database, App_Data, has the following permissions: SYSTEM, Steve, and Administrators have full permissions, and Home Users have all permissions apart from Full Control. 

After compiling my project, that folder is now on the server of my Web hosting service and these are the file permissions of App_Data on the server:

However, I am still getting the same error. Do I need to do anything in the Control Panel of the server, too (I have a Web hosting service) or is what I have already enough>

Thank you.

I want to implement Crud operation with generic repository ,unit of work, repository and service layer. I did all the layers but i don't know how to implement it in the controller.Please Help!!

@model ProjectName.Models.Goals
<div>
   <form asp-controller="Goals" asp-action="Create">
      Other form elements

      <select name="months" asp-for="MonthId" class="form-control" asp-items="ViewBag.Months">

      </select>

      <input type="submit" value="Save" class="btn btn-primary" />
   </form>
</div>

public class Goals
    {
        [Display(Name = "Code")]
        public Int32 GoalId { get; set; }

        public String GoalName{ get; set; }
        public Months Month{ get; set; }
        public Int32 MonthId{ get; set; }
        ....
        Other properties

    }

public class Months
{
    [Key]
    [Display(Name = "Code")]
    public Int32 MonthId { get; set; }
    [Display(Name = "Designation")]
    public String Designation{ get; set; }
}

public IActionResult Create(Goals goal)
{
   if (ModelState.IsValid)
   {
      _context.Goals.Add(goal);
      _context.SaveChanges();
   }
   return View("~/../Create.cshtml");
}

        var template;
        if (paramType === 'Date Range') {
            var multiple = "multiple='multiple'";
            template =
            '<div id="Param_' + Id + '">' +
                '<div class="parameterHeader ui-widget-header ui-corner-top">' + paramDisplayName + '</div>' +
                '<div class="parameterItem ui-widget-content ui-corner-bottom" ' + multiple + '>' +
                    '<div class="parameterFieldResize parameterField">' +
                        '<input class="parameterDateRangePicker clearable" placeholder="Start" type="text" name="' + paramName + '_1_Start" id="' + paramName + '_1_Start" />' +
                        '<input class="parameterDateRangePicker clearable" placeholder="End" type="text" name="' + paramName + '_1_End" id="' + paramName + '_1_End" />' +
                    '</div>' +<br />
                '</div>' +
            '</div>';

<pre>
        //Insert HTML
        this.JQElem = $(template);
        initialParent.append(this.JQElem);            

        $('#' + paramName + '_1_Start').datepicker({
            onSelect: function (dateText) {
                $(this).trigger("input");
                if (typeof me.values[this.id.split('_')[1]] === 'undefined')
                    me.values[this.id.split('_')[1]] = {};
                me.values[this.id.split('_')[1]]['Start'] = dateText;
            }
        });
        $('#' + paramName + '_1_End').datepicker({
            onSelect: function (dateText) {
                $(this).trigger("input");
                if (typeof me.values[this.id.split('_')[1]] === 'undefined')
                    me.values[this.id.split('_')[1]] = {};
                me.values[this.id.split('_')[1]]['End'] = dateText;
            }
        });
        $("#" + paramName + '_1_Start').change(function (event) {
            //convert to 4 digit year (always will be in the 20's)
            var dateString = this.value;
            if (/^\d{1,2}\/\d{1,2}\/\d{2}$/.test(dateString)) {
                dateString = dateString.substring(0, dateString.length - 2) + '20' + dateString.substring(dateString.length - 2, dateString.length);
                this.value = dateString;
            }
            if (isValidDate(dateString)) {
                if (typeof me.values[paramName + '_1'] === 'undefined')
                    me.values[this.id.split('_')[1]] = {};
                me.values[this.id.split('_')[1]]['Start'] = dateString;
            } else if (typeof me.values[this.id.split('_')[1]] !== 'undefined' && typeof me.values[this.id.split('_')[1]]['Start'] !== 'undefined') {
                if (typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
                    delete me.values[this.id.split('_')[1]];
                else
                    delete me.values[this.id.split('_')[1]];
            }
        });
        $("#" + paramName + '_1_End').change(function (event) {
            //convert to 4 digit year (always will be in the 20's)
            var dateString = this.value;
            if (/^\d{1,2}\/\d{1,2}\/\d{2}$/.test(dateString)) {
                dateString = dateString.substring(0, dateString.length - 2) + '20' + dateString.substring(dateString.length - 2, dateString.length);
                this.value = dateString;
            }
            if (isValidDate(dateString)) {
                if (typeof me.values[this.id.split('_')[1]] === 'undefined')
                    me.values[this.id.split('_')[1]] = {};
                me.values[this.id.split('_')[1]]['End'] = dateString;
            } else if (typeof me.values[this.id.split('_')[1]] !== 'undefined' && typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
                if (typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')                        
                    delete me.values[this.id.split('_')[1]];
                else
                    delete me.values[this.id.split('_')[1]];
        });

I want to create a single page on which i can perform full crud operation using dropdownlist, radiobuttonlist, checkbox ,checkbox inside dropdown in a gridview.

and at the left side of each row in gridview should be insert, delete and update.

and should be a button on which click we can see the deleted rows.

please send the code with database script file.

<div class="col-md-3">
                       
                <label class="switch2">
                <input class="switch-input2" type="checkbox" id="contractselection" name="contractselection" runat="server"/>
                  
                  
             </label>            
          </div>
          <div class="col-xs-4">  
           
            <div class="contractrow">                  
            <label for="exampleInputCity">Contract:*:</label>
             <asp:TextBox ID="contractnumber" class="form-control" name="contractnumber" placeholder="" runat="server"></asp:TextBox>           
            </div>  
             <asp:RequiredFieldValidator ID="rfvcontractnumber"    runat="server" ControlToValidate ="contractnumber"   ErrorMessage="Please enter a Contract">   
                </asp:RequiredFieldValidator>           
             <div class="orderrow">                  
            <label for="exampleInputCity">Solicitation:*:</label>
             <asp:TextBox ID="ordernumber" class="form-control" name="ordernumber" placeholder="" runat="server"></asp:TextBox>           
            </div> 
             <asp:RequiredFieldValidator ID="rfvsolicitationnumber"    runat="server" ControlToValidate ="ordernumber"   ErrorMessage="Please enter a Order">   
                </asp:RequiredFieldValidator>                
             </div>   
          </div>
          </div>       

<script type="text/javascript">
    $(function () {
        $(".contractrow").show();
        $(".switch-input2").click(function () {
            if ($(this).is(":checked")) {
                $(".contractrow").show();
            } else {
                $(".solicitationrow").hide();
            }
        });
    });
</script>

<label class="switch">
	<input class="switch-input" type="checkbox" id="orderselection" name="orderselection" runat="server" />
	 
	 
</label>

<label for="exampleOrderNumber">Are Redelegations Authorized?<label for="exampleInputCity">:</label>           
             <label class="switch">
                <input class="switch-input" type="checkbox" id="authredelegation" name="authredelegation" runat="server" />
                  
                  
             </label>

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load

        Dim table As New DataTable()
        Using con = New SqlConnection(ConfigurationManager.ConnectionStrings("PersonnelPolicyDB").ConnectionString)
            Using cmd = New SqlCommand("usp_AddABCD", con)
                Using da = New SqlDataAdapter(cmd)
                    cmd.CommandType = CommandType.StoredProcedure
                    cmd.Parameters.AddWithValue("@oderno", "orderno.text")
                    cmd.Parameters.AddWithValue("@orderdate", "orderdate.text")
                    da.Fill(table)
                End Using
            End Using
        End Using
      End Sub



        Dim table As New DataTable()
        Using con = New SqlConnection(ConfigurationManager.ConnectionStrings("PersonnelPolicyDB").ConnectionString)
            Using cmd = New SqlCommand("usp_GetABCD", con)
                Using da = New SqlDataAdapter(cmd)
                    cmd.CommandType = CommandType.StoredProcedure
                    cmd.Parameters.AddWithValue("@orderno", "orderno.text")
                   da.Fill(table)
                End Using
            End Using
        End Using
    End Sub
        
       Private Sub SendPDFEmail(dt As DataTable)
           Using sw As New StringWriter()
               Using hw As New HtmlTextWriter(sw)
                   Dim companyName As String = "my Company"
                   Dim orderNo As Integer = 2303
                   Dim sb As New StringBuilder()
                   sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>")
                   sb.Append("<tr><td align='center' style='background-color: #18B5F0' colspan = '2'>Order Sheet</td></tr>")
                   sb.Append("<tr><td colspan = '2'></td></tr>")
                   sb.Append("<tr><td>Order No:")
                   sb.Append(orderNo)
                   sb.Append("</td><td>Date: ")
                   sb.Append(DateTime.Now)
                   sb.Append(" </td></tr>")
                   sb.Append("<tr><td colspan = '2'>Company Name : ")
                   sb.Append(companyName)
                   sb.Append("</td></tr>")
                   sb.Append("</table>")
                   sb.Append("<br />")
                   sb.Append("<table border = '1'>")
                   sb.Append("<tr>")
                   For Each column As DataColumn In dt.Columns
                       sb.Append("<th style = 'background-color: #D20B0C;color:#ffffff'>")
                       sb.Append(column.ColumnName)
                       sb.Append("</th>")
                   Next
                   sb.Append("</tr>")
                   For Each row As DataRow In dt.Rows
                       sb.Append("<tr>")
                       For Each column As DataColumn In dt.Columns
                           sb.Append("<td>")
                           sb.Append(row(column))
                           sb.Append("</td>")
                       Next
                       sb.Append("</tr>")
                   Next
                   sb.Append("</table>")
                   Dim sr As New StringReader(sb.ToString())
   
                   Dim pdfDoc As New Document(PageSize.A4, 10.0F, 10.0F, 10.0F, 0.0F)
                   Dim htmlparser As New HTMLWorker(pdfDoc)
                   Using memoryStream As New MemoryStream()
                       Dim writer As PdfWriter = PdfWriter.GetInstance(pdfDoc, memoryStream)
                       pdfDoc.Open()
                       htmlparser.Parse(sr)
                       pdfDoc.Close()
                       Dim bytes As Byte() = memoryStream.ToArray()
                       memoryStream.Close()
   
                       Dim mm As New MailMessage("NoReply@domain.com", "myemail@domain.com")
                       mm.Subject = "iTextSharp PDF"
                       mm.Body = "iTextSharp PDF Attachment"
                       mm.Attachments.Add(New Attachment(New MemoryStream(bytes), "iTextSharpPDF.pdf"))
                       mm.IsBodyHtml = True
                       Dim smtp As New SmtpClient()
                       smtp.Host = "myhostname"
                       smtp.EnableSsl = False
                       Dim NetworkCred As New System.Net.NetworkCredential()
                       NetworkCred.UserName = "myusername"
                       NetworkCred.Password = "mypassword"
                       smtp.UseDefaultCredentials = True
                       smtp.Credentials = NetworkCred
                       smtp.Port = 25
                       smtp.Send(mm)
                   End Using
               End Using
           End Using
    End Sub