this my error and my code

i have a problem with data fill in database

error is

Conversion failed when converting date and/or time from character string

my data type is date
i put data from text box mode date

Hi experts,
I have wrote the C# API programe to get data from different location.
All used to work fine.Suddenly it's generating error becuase the records not available
in the API records.(requesting records)There is no way to find Candidate avaiable or not.

see below link how the API request send.

https://test/v3/company/18f62e940d1d01/position/771b0f2aff3c01/candidate/05ea659e456a01/stream

Error:

 500 Internal Server Error
{
    "error": {
        "type": "getStreamError",
        "message": "there was an unknown error getting candidate stream."
    }
}

 string urlCandatestream = "/company/" + CompanyID + "/position/" + positionID + "/candidate/" + candidateID + "/stream";
                var request = new RestRequest(urlCandatestream, Method.GET);


                request.AddHeader("Content-Type", "application/json");
                request.AddHeader("cache-control", "no-cache");
                request.AddHeader("authorization", connectAPI.getAccessToken());
                // rqst.Proxy = GlobalProxySelection.GetEmptyWebProxy();

                IRestResponse response;
                varRequest = request.ToString();
                try
                {
                    response = await _restClent.ExecuteTaskAsync(request);
                    VarRequestResults = response.Content;
                }
                catch (Exception ex)
                {
                    throw new Exception("Error executing  request to " + 

Select all Open in new window

…

I am trying to pass a value to a datetime value from a database.  Unfortunately, the my code doesn't exactly like the format.  I get the following error:  

String was not recognized as a valid datetime.

this my c# code

<code>

TextBox reffd = GridView1.Rows[e.RowIndex].FindControl("txt_RefD") as TextBox;
TextBox outd = GridView1.Rows[e.RowIndex].FindControl("txt_Outd") as TextBox;


</code>

and this my sql command

<code>
SqlCommand cmd = new SqlCommand("Update FZMain set Name='" + name.Text + "',Payment = '" + pay.Text + "', Cases = '" + cases.Text + "',  Reffrence = '" + reff.Text + "',ReffrenceDate = " + DateTime.ParseExact(reffd.Text, "dd-mm-yyyy", null).AddHours(-5) + "), OutDate = " + DateTime.ParseExact(outd.Text, "dd-mm-yyyy ", null).AddHours(-5) + "), FamilyRegister = '" + femreg.Text + "',LastOwner='" + lastO.Text + "', ChassisNO='" + Chasses.Text + "', CarModel='" + CarModel.Text + "' where ID=" + Convert.ToInt32(id.Text), con);

</code>

data type in database is date

Why do some of my .aspx pages add this to the URL? (ex. www.url.com/filename.aspx?_ga=2.176514797.910954863.1579199334-2140930447.1563381308

I don't know why it adds ?_ga=2.176514797.910954863.1579199334-2140930447.1563381308 to the end of the URL when I bring the file up in the browser. Is that something that I'm doing wrong?

Hello Experts,

I have a textbox(input) when user enter accept only numbers(digits only) and it should be 10. Once entered we need for format like (123)456-7890. I tried below but not working as expected.
CSHTML

 <input type="text" id="PhoneNumber" name="PhoneNumber" value="" class="form-control" autofocus="autofocus" maxlength="11">
                                <span class="bar" id="ErrMsg" ></span>
                                <label for="PhoneNumber">Phone</label>

Select all Open in new window

JS

$("#PhoneNumber").keypress(function (e) {
    //if the letter is not digit then display error and don't type anything
    if (e.which != 8 && e.which != 0 && (e.which < 48 || e.which > 57)) {
        //display error message
        $("#ErrMsg").html("Digits Only").show();
        return false;
    }
});

$("#PhoneNumber").blur(function (e) {
    phone = $(this).val();
    if (phone.length != 10) {
        $("#ErrMsg").html("Phone number must be 10 digits.").show().fadeOut("slow");
        return false;
    }
    else
        $(this).val($(this).val().replace(/^(\d{3})(\d{3})(\d)+$/, "($1)$2-$3"));
});

Select all Open in new window

I have couple of issues with the above code, first I did Maxlength 11 then only it's accepting 10 digits and also I get format like this (123)456-0 (since my maxlenght was 11). After changing Maxlength to 14, I still get same issue. Please suggest how can I solve this.

Thanks,
ASPDEV

This question needs a little explanation and background

I have  C# asp.net code that talks to a database and I have javascript on the client end. Javascript makes async calls to the backend c# code via a post and waits for results back. On the client code there is a list of items which get altered based on what the backend page returns.

Currently, when I do any db operation, I then query the db again to get the values of all items on the list and return them back to the client. So any addition, update, deletion...causes me to query the db again and return all items rather than just the one that was altered. This assures that the database and what is on the client list is always the same. But this is inefficient for the db to have that second query.

I'm thinking about simply checking for any errors from the db and then just returning a success or fail and then the javascript can update the list based on values it already had from the submission form.

Is there any way that I could KNOW that the db operation definitely succeeded and there is no chance the db will have different data than the client without having to re-query the db again?

Hi,
I have already done some webform development, however I am thinking of developing a new project and I think it makes no sense to use a technology that I think is becoming obsolete.
As I usually develop in .NET I thought about using Blazor, since I don't have many skills in java framework either.
It makes sense to choose blazor, or it would be better to choose asp.net core controls or another java framework. Will blazor succeed?

best regards

Hello Experts,
I have a Console App, which imports some data thru an API call.  In this all the methods are defined inside the Main().  I am trying to define some methods such as xxxSearch and XxxxDetail, return type List, outside of the Main() method.  When I do that, I am getting the Error: CS0120 An object reference is required for the non-static field, method, or property 'XxxxImport.XxxxSearch(DateTime, DateTime)'.

The reason I need to do this, because I need to convert this to a Windows Service Program comfortably.

Please let me know how to define them outside of Main() method and call them,

Thank you very much in advance.

Below is the Skeleton of the Code
----------------------------------------------------

public static void Main(string[] args)
{
    DataSet ds = new DataSet();

    var fromDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(-1);
    var toDate = DateTime.Parse(fromDate.ToString("yyyy-MM-dd")).AddDays(0);

    MainHub(fromDate, fromDate);

    Environment.Exit(0);


    void MainHub(DateTime FromDate, DateTime ToDate)
    {
      var xxxFound = xxxSearch(FromDate, ToDate);

      if (xxxFound != null)
      {
          InsertxxxRaw(xxxFound, FromDate);
      }

      foreach (var xxx in xxxFound)
      {
          var list = new List<string>();
          list.Add(xxx.xxxNumber);

          var details = xxxDetail(xxx.validatingxxxDesignator, list);

          if (details != null)
          {
            …

Hi

I have only built ASP.net we solutions with cloud based sql databases. I have been asked to build a solution on a company server with  local SQL database.  Where would I publish my web app to?
I am only used to publishing web apps to Azure or a web hosting provider's folders

what are the Steps to set up the web server (IIS, Apache)

Hello,

How can I transfer data from the dialog box to the parent window?

I need your help.

I have a parent window and a popup window

1. user open popup window
2. the popup window has a textarea
3. the values that are in the textarea needs to go back to the parent textarea.

I don't know what I'm doing wrong.

Text area in the parent window: 

 @Html.TextArea("ConditionAttributesAndValues", new { @class = "form-control", @style = "width:77%" })

My dialog box in the parent window:

$(function () {
            $('#dialog').dialog({
                autoOpen: false,
                width: 950,
                height:650,
                resizable: true,
                title: 'Condition',
                modal: true,
                open: function(event, ui) {
                    $(this).load("@Url.Action("RulePartialView", "CareAdvanceBusinessRules")")
                    $(".ui-dialog-titlebar-close").hide();
                },
                buttons: {
                    "Close": function () {
                        $(this).dialog("close");
                    }
                },
                closeOnEscape: false,
            });
            $("#opener").click(function (event) {
                event.preventDefault(); 
                $("#dialog").dialog("open");
            });
        });

Select all Open in new window

This is what I have in the dialog box: 

// Here where I need the help 
// I want what ever I have in the textarea to be sent to the parent textarea. 

     $("#AppendConditionToParentBtn").click(function () {
            $('#ContidionsAndAttributesTextArea').text(window.opener.$("#ConditionAttributesAndValues").val());
            $('#dialog').dialog('close');
            return true;
        });

 <button id="AppendConditionToParentBtn" name="AppendConditionToParentBtn" class="btn btn-default" type="button" style="margin-top:10px;margin-bottom:10px;" value="Append">
                        Submit 
                    </button>

Select all Open in new window

I'm getting this error

Unhandled exception at line 513, column 13 in eval code

0x800a138f - JavaScript runtime error: Unable to get property '$' of undefined or null reference