ASP.NET

23-Jan-19 9:48

But this never happened to me in the past, can't you please use some better words than dramatizing? Now you know that I am not a spammer, you defense yourself Sir, but when you know that a person is not a spammer, can you please remove the filters now? What is stopping you from doing it?

Mycroft Holmes23-Jan-19 10:23

Mycroft Holmes

23-Jan-19 10:23

Individual posters are not addressed by spam filters, they are a RULES based system and cannot be refined to suit 1 person in millions.

Oh and don't post the entire error message in the heading. Do you see anyone else posting multiple lines as their heading?

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

simpledeveloper23-Jan-19 13:46

23-Jan-19 13:46

Hi Holmes, thanks for the reply my friend

Quote:
Oh and don't post the entire error message in the heading. Do you see anyone else posting multiple lines as their heading?

I have not seen many peoples posts as I don't like to put nose into some others issues until I really need to read about that topic.

Do you think, is that the reason why I am being spammed here in this post? Actual post didn't give me any filters though, I got hit by the filter when I was responding to Richards answer - anyways, I felt like alienated man, I felt it bad buddy. I am feeling like somebody is pointing at me my friend.

Mycroft Holmes23-Jan-19 14:42

Mycroft Holmes

23-Jan-19 14:42

It would not have been your header but something in your response content.

simpledeveloper wrote:
anyways, I felt like alienated man, I felt it bad buddy. I am feeling like somebody is pointing at me my friend.

Don't be such a pussy, how can a business rule possibly be personal.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

simpledeveloper23-Jan-19 16:55

23-Jan-19 16:55

Oh really I'm pu**y are you human? Be a human first before becoming anything, I guess you're born to human parents at least.

Is no one seeing this? Why are your hands tied up to flag this message?

modified 23-Jan-19 23:29pm.

simpledeveloper23-Jan-19 17:36

On web form button, prevent user from clicking the button more than 1 time

23-Jan-19 17:36

Quote:
Thanks Rick, it has been resolved my friend.

This was the message I replied to Richard, what is there in this message that can catch me as spammer? I am not able to understand?

Nelek23-Jan-19 19:05

Nelek

23-Jan-19 19:05

Go to the Bug&Suggestions forum and ask the admins, if you want.

For me, this topic is ended.

M.D.V.

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.

dcof17-Jan-19 5:10

dcof

17-Jan-19 5:10

In a vb.net 2010 web form application that uses web form controls, there is a 'process' button where the user can click on the button lots of times.
This causes problems in the application for every time the button is clicked on, that many records are created in the sql server 2016 database.

I would like a solution on how to prevent the user from clicking on the button more than one time. I have a 'click button' code to catch when the button is clixked right away.
But I would like to know what I can do so the user knows they cannot click the button more than once:
1. I could make the button invisible.
2. However I would either like to have a popup message and/or somewhere on the webpage saying they can click on the process button only one time.
Thus can you show me the code on preferable setting up a popup menu? If not, can you show me the code on how to display the message on the web form page?

Re: On web form button, prevent user from clicking the button more than 1 time

Richard MacCutchan17-Jan-19 5:20

how do I disable Button asp.net - Stack Overflow[^].

17-Jan-19 5:20

how to Import Excel file into Data base using Entityframework in MVC

Member 1408535316-Jan-19 17:55

Member 14085353

16-Jan-19 17:55

give me better suggetions

Re: how to Import Excel file into Data base using Entityframework in MVC

Member 1408535316-Jan-19 18:03

Member 14085353

16-Jan-19 18:03

Make a .CS file with name of ImportExcel.CS
:----

public class FileExt : ValidationAttribute
    {
        public string Allow;
        protected override ValidationResult IsValid(object value, ValidationContext validationContext)
        {
            if (value != null)
            {
                string extension = ((System.Web.HttpPostedFileBase)value).FileName.Split('.')[1];
                if (Allow.Contains(extension))
                    return ValidationResult.Success;
                else
                    return new ValidationResult(ErrorMessage);
            }
            else
                return ValidationResult.Success;
        }
    }

    public class ImportExcel
    {
        [Required(ErrorMessage = "Please select file")]
        [FileExt(Allow = ".xls,.xlsx", ErrorMessage = "Only excel file")]
        public HttpPostedFileBase file { get; set; }
    }

And Add this code to your controller
:-----

public ActionResult ImportExcel()
       {
           return View();
       }

       [HttpPost]
       public ActionResult importexcel(ImportExcel importExcel)
       {
           if (ModelState.IsValid)
           {
               string path = Server.MapPath("~/library/ExcelFile/" + importExcel.file.FileName);
               importExcel.file.SaveAs(path);

               string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source='" + path + "';Extended Properties='Excel 12.0;'";
               OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);

               //Sheet Name
               excelConnection.Open();
               string tableName = excelConnection.GetSchema("Tables").Rows[0]["TABLE_NAME"].ToString();
               excelConnection.Close();
               //End

               OleDbCommand cmd = new OleDbCommand("Select * from [" + tableName + "]", excelConnection);

               excelConnection.Open();

               OleDbDataReader dReader;
               dReader = cmd.ExecuteReader();
               SqlBulkCopy sqlBulk = new SqlBulkCopy(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);

               //Give your Destination table name
               sqlBulk.DestinationTableName = "ExcelFile";

               //Mappings
               sqlBulk.ColumnMappings.Add("Userid", "Userid");
               sqlBulk.ColumnMappings.Add("Name", "Name");
               sqlBulk.ColumnMappings.Add("TelephoneNo", "TelephoneNo");
               sqlBulk.ColumnMappings.Add("Address", "Address");
               sqlBulk.ColumnMappings.Add("EmailAddress", "EmailAddress");


               sqlBulk.WriteToServer(dReader);
               excelConnection.Close();

               ViewBag.Result = "Successfully Imported";
           }
           return View();
       }

And create view page of ImportExcel method with name of ImportExcel.cshtml and add this code
:-----

@model Models.GeneralModel.ImportExcel



<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>ImportExcel</title>
</head>
<body>
    <div style="float:right"> 
        <h4>@ViewBag.Result</h4>
        @using (Html.BeginForm("ImportExcel", "NewCustomer", FormMethod.Post, new { enctype = "multipart/form-data" }))
        {
            @Html.TextBoxFor(m => m.file, new { type = "file" })
            <button id="submitButton" type="submit">Submit</button>
            @Html.ValidationMessageFor(model => model.file)
        }
    </div>
</body>
</html>

Re: how to Import Excel file into Data base using Entityframework in MVC

Richard Deeming17-Jan-19 1:52

Richard Deeming

17-Jan-19 1:52

You do realise we can all see you talking to yourself, don't you? D'Oh! | :doh:

Quote:

string extension = ((System.Web.HttpPostedFileBase)value).FileName.Split('.')[1];

Lots of problems with that line. For example, what if the uploaded file doesn't contain an extension? What if it contains multiple "." characters? What if the extension is .lsx? Etc.

Try:

protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
    var file = value as System.Web.HttpPostedFileBase;
    if (file != null)
    {
        string extension = System.IO.Path.GetExtension(file.FileName);
        string[] allowedExtensions = Allow.Split(',');
        if (!Array.Exists(allowedExtensions, ext => string.Equals(ext, extension, StringComparison.OrdinalIgnoreCase)))
        {
            return new ValidationResult(ErrorMessage);
        }
    }
    
    return ValidationResult.Success;
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

ASP.Net code won't run

Member 1406015916-Jan-19 11:43

Member 14060159

16-Jan-19 11:43

i have been trying to get my program to start but it keeps refusing to.can anyone help me find a solution to the error below.thanks

This site can’t be reached localhost refused to connect.
Search Google for localhost 58962
ERR_CONNECTION_REFUSED

Re: ASP.Net code won't run

F-ES Sitecore17-Jan-19 0:15

F-ES Sitecore

17-Jan-19 0:15

You're trying to access a web server running on port 58962 of your local machine, but there is on web server running there. We can't access your machine so we can't tell you why that is. Typically you only use non-standard ports when running the site in debug mode from Visual Studio. So either you are trying to access your site outside of VS, or VS's internal web server isn't working for some reason.

An exception of type 'System.Data.Entity.Core.EntityException' occurred in EntityFramework.SqlServer.dll but was not handled in user code

RedPandinus15-Jan-19 12:34

RedPandinus

15-Jan-19 12:34

I am new to ASP.NET MVC, getting error at below code :

<div id="wrapper" style="background-color:#fff;">
       <nav class="navbar navbar-default navbar-cls-top " role="navigation" style="margin-bottom: 0">
           <div class="navbar-header">

               <a class="navbar-brand" href="/Home/EmployeeDashboard" target="_blank">
                   @{
                       string comnameup = "";
                       using (PMEntities dc = new PMEntities())
                       {
                           var data = dc.tblGenerals.SingleOrDefault();
                           comnameup = data.CompanyName;
                           @comnameup
                       }
                   }

               </a>
           </div>

also adding connection string :

<connectionStrings>
  <add name="PMEntities" connectionString="metadata=res://*/PMData.csdl|res://*/PMData.ssdl|res://*/PMData.msl;provider=System.Data.SqlClient;provider connection string="data source=localhost\SQLEXPRESS;initial catalog=eee;integrated security=SSPI;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
 </connectionStrings>

Re: An exception of type 'System.Data.Entity.Core.EntityException' occurred in EntityFramework.SqlServer.dll but was not handled in user code

Richard Deeming16-Jan-19 8:12

Richard Deeming

16-Jan-19 8:12

You need to look at the full details of the exception, including the InnerException, to see what the error is.

NB: SingleOrDefault will return null if there are no records. When you try to read the property on the next line, you could potentially get a NullReferenceException. It would be better to use Single in this instance.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Import Tabulor form data from PDF file

Member 1411436712-Jan-19 20:34

Member 14114367

12-Jan-19 20:34

Is anyone help me out for import tables data from PDF file and show them on front using C#,.Net ,please suggest me a piece of code for random column and row and also recommend library OR 3RD party such as RadDocumentProcessing,telerikdocument processing ,Itextsharp etc .

Richard MacCutchan12-Jan-19 22:54

12-Jan-19 22:54

You already have the names of 3rd party libraries. If you go and study them you should be able to decide which one suits your needs.

Member 1411436714-Jan-19 1:13

Member 14114367

14-Jan-19 1:13

yes ok but i need a piece of code to extract tables from pdf and show on datatable in c#.

Richard MacCutchan14-Jan-19 1:46

14-Jan-19 1:46

Yes, but you need to write the code first.

What layers required for make asp.net core 2 project for prevent repeat data ?

Nitin S25-Jan-19 1:40

Nitin S

25-Jan-19 1:40

checkout their documentation

=====================================================
The grass is always greener on the other side of the fence

ahmed_sa2-Jan-19 21:53

ahmed_sa

2-Jan-19 21:53

Problem
What layers required for make asp.net core 2 project for prevent repeat data ?
I need to make new project with asp.net core 2.1 using Generics and i have more questions
How many layers used ?
which layer must have initialize of connections ?

Re: What layers required for make asp.net core 2 project for prevent repeat data ?

Richard MacCutchan2-Jan-19 23:37