ASP.NET Web Page rendering single-quote as ’

How do I fix???

so on a btn click I have this code:  not getting any errors but it's not transferring to the database:

 if (rd.HasRows)
                    if (rdshop.HasRows)
                        if (rdoper.HasRows)
                        {
                            SqlConnection uptime = new SqlConnection();
                            uptime.ConnectionString = ConfigurationManager.ConnectionStrings["gcerp"].ToString();
                            uptime.Open();
                            cmd.CommandText = "Insert into [_lcclockfil](empId, shift, clockin, ord_no, item_no, oper_no, oper_desc) values('" + TxtEmp.Text + "', '" + TxtShift.Text + "','" + TxtTime.Text + "', '" + TxtShop.Text + ",'" + TxtSHOPItem.Text + "','" + TxtOp.Text + "','" + TxtOpDesc.Text + "')";
                            uptime.Close();
                            Response.Write("<script>window.alert('Complete')</script>");
                           
                            TxtEmp.Text = "";
                            txtfullname.Text = "";
                            TxtShift.Text = "";
                            TxtShop.Text = "";
                            TxtOp.Text = "";
                            TxtOpDesc.Text = "";
                        }
                        else
                        { Response.Write("<script>window.alert('Did Not Update')</script>"); }
            }

Hi Guys!!!

I'm new to MVC C# coding and I really need your help.

I have a left menu that I want to be populated from my database and I'm not sure how to do it.

Thank you in advance for taking the time to help me with this.

I have two tables a parent table and a child table 

Parent table called: RuleSet

RuleSetID       |     RuleSet                 |    CreatedDate   |     CreatedBy 
1                             Blended                      11/12/2019            Y000001
2                             OSCMain                     11/12/2019            Y000001
3                             Questionnaire            11/12/2019            Y000001

Child table called: RuleIdentifier

RuleIdentifierId    |    RuleSetId    |    RuleIdentifier            |      CreatedDate   |    CreatedBy
1                                     1                       Blended_00010                 11/12/2019            Y000001
2                                     2                       OSCMain_0049                  11/12/2019           Y000001
3                                     2                       OSCMain_0010                  11/12/2019           Y000001
4                                     2                       OSCMain_0122                  11/12/2019           Y000001
5                                     1                       Blended_0234                    11/12/2019           Y000001
6                                     3                       Questionnaire_02 

Select all Open in new window

…

Hi Expert,
Can you help me to find out where i'm doing mistake or how to call this and also I used  newtonsoft

Following way i have tried to Deserialize Json. The results from REST services working fine
(candidateResults) i iwll get the data.

 var jcCandidate1 = JsonConvert.DeserializeObject<List<candidateDetails>>(candidateResults);

also i tried
 var jcCandidate1 = JsonConvert.DeserializeObject<List<candidateDetails>>(candidateResults);

Select all Open in new window

all classes  created according to Json Results. (go to Edit special paste -> select Json)

namespace TestConsolApp
{
   
    public class candidateMain
    {
        public candidateDetails[] Property1 { get; set; }
    }

    public class candidateDetails
    {
        public string _id { get; set; }
        public DateTime creation_date { get; set; }
        public string email_address { get; set; }
        public string headline { get; set; }
        public string initial { get; set; }
        public string name { get; set; }
        public string origin { get; set; }
        public string phone_number { get; set; }
        public candidateResume resume { get; set; }
        public candidateSource source { get; set; }
        public candidateStage stage { get; set; }
        //public object[] tags { get; set; }
        public DateTime updated_date { get; set; }
    }

    public class candidateResume
    {
        public string url { get; set; }
    }

    public class candidateSource
    {
        public

Select all Open in new window

…

Hi Experts,

I have write following code. This code is working fine and geting results.
But only issue is how to return type designing.

 public async Task<List<Positions>> positionDetails(bool onlyCurrent = true)
        {
var results=response.Content;
var pJson = JsonConvert.DeserializeObject<List<Positions>>(results);

retrun ???

}

Select all Open in new window

Any idea really appriciated

Hi,

How can I make a sub menu using my table menu?

I need a sub menu to Blended or Inpatient or Outpatient.
They each have a submenu. How can I do that?
This is my left menu.

I want on hover over the word "Blended" to list a submenu

 <table class="table">
                                                <tr>
                                                    <td>
                                                        <a id="RuleMenuDiv" href="../Rule" style="color:#0144af;">Rule</a>
                                                        </td>
                                                </tr>
                                                <tr id="BlendedMenu"> 
                                                    <td style="background-color:#5cb85c; color:#fff;font-weight:bold;">
                                                        Blended
                                                    </td>
                                                </tr>
                                                <tr id="InpatientMenu">
                                                    <td style="background-color:#5cb85c; color:#fff;font-weight:bold;">
                                                        Inpatient
                                                    </td>
                                                </tr>
                                                <tr id="OutpatientMenu">
                                                    <td 

Select all Open in new window

…

I have written a page that posts data for a client into the above, It works as part of a new website as the only page (used for testing) when I copy the code or paste the page into the web application I have been developing it for I get an error, I've used Nuget to ensure all the correct dll's are added.

This is the error

"An existing connection was forcibly closed by the remote host
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host"

This line is causing the error:
Dim myresponse As HttpResponseMessage = client.SendAsync(myrequest).Result


Can anyone suggest a solution or reason why the same code fails in one web application but not the other?

Here is the code

Imports System.Net.Http
Imports System.Net.Http.Headers
Imports System.Threading.Tasks
Imports Microsoft.IdentityModel.Clients.ActiveDirectory
Imports Newtonsoft.Json.Linq
Imports System.Collections.Generic
Public Class CRM_Contact
    Inherits System.Web.UI.Page

    Public myclientId As String = Convert.ToString(ConfigurationManager.AppSettings("clientid"))
    Public redirectUrl As String = Convert.ToString(ConfigurationManager.AppSettings("redirecturl"))
    Public serviceUrl As String = …

I need a multiple selection drop down list that looks similar to this.

I currently use Telerik's but we are doing away with using Telerik.

Does anyone know of another jquery/javascript type of solution that does something like this?

We've been using Select2 for our comboboxes, but it doesn't support this kind of look.

Hi I am new to C# core and I come from a VB forms background.  I have been working on a web application project using the latest asp core.  

All i am trying to do at the moment is have a page where you enter a serial number then on leaving that serial number it comes back and displays some additional information from a stored procedure in a grid on the page or it displays an error from the stored procedure.  Then there is another button that will fire another stored procedure that will insert data into a database or return an error on error checks.   If not an error the whole page resets and ready for the next one.

The problem I have been having is that i cannot work out how to fire the stored procedure and return the data after leaving the text box and display an error if needed.  To simply it I have added a button so I enter the serial number then press the button rather than get the on leave event from the text box.

My problem is the data is binded before the page loads with some default data.  I do not know how to do it part of the way through or how to pass a parameter (serial number to it).  I have the ajax to call a function that displays the data from before, but i do not know how to change the lookup to be based on that serial number.  Or in the case of being an error display an error.

My code is below:
Model class:

public class OperationsData
    {

       public string Job { get; set; }
       public string Item { get; set; }
       public 

Select all Open in new window

…

Need to get value of webpage URL (with query string parameters, without, and only string with parameters)
Thank you in advance.