ASP.NET

Where did i get asp.net project in linux with mysql database.?

19-Dec-21 8:02

I added the following code to PM model:

public int userId { get; set; }

and changed the navigation property to the following code:

//Navigation property
[ForeignKey("userId ")]
public virtual AppUser user { get; set; }

Tushar Surve 202115-Dec-21 6:11

Tushar Surve 2021

15-Dec-21 6:11

ASP.NET

Re: Where did i get asp.net project in linux with mysql database.?

Richard Deeming15-Dec-21 6:22

Re: Where did i get asp.net project in linux with mysql database.?

15-Dec-21 6:22

How would we possibly know where you got something? Confused | :confused:

If you want help, you need to ask better questions.

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

Mycroft Holmes15-Dec-21 13:31

Mycroft Holmes

15-Dec-21 13:31

I think the question deserves an upvote for the depth of thought that went into that question!

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

Two ReportViewers on the same project

Member 1077312213-Dec-21 1:01

Member 10773122

13-Dec-21 1:01

I want to have two ReportViewer controls in my VS project. I have two completely different types of reports and I want to split them between two RepportViewers that would be processed in two ReportViewer.aspx.cs. I have create copies of three files:

ReportViewer1.aspx
ReportViewer1.aspx.cs
ReportViewer1.aspx.designer.cs

in ReportViewer1.aspx.designer.cs I changed this line:
protected global::Microsoft.Reporting.WebForms.ReportViewer ReportViewer2;

In ReportViewer1.aspx.cs I name dthe class like this:
public partial class ReportViewer1

Inside of this class I changed all ReportViewer1 to ReportViewer2.

I also modified ReportViewer1.aspx.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ReportViewer1.aspx.cs" Inherits="PrismWeb.reports.ReportViewer1" EnableEventValidation="false" %>
rsweb:ReportViewer1 ID="ReportViewer2" runat="server" Height="100%" Width="100%">

Call from UI:
/reports/ReportViewer1.aspx crashes somewhere on the server, cannot fine where.

However, if I call /reports/ReportViewer.aspx with same changes I did in ReportViewer1.aspx then it works fine. I just can't figure out why calling ReportViewer1.asx is not working.

Please note, I am not a c# developer, I might be doing something abviously wrong. Please help.

Thanks

Re: Two ReportViewers on the same project

CHill6013-Dec-21 1:09

CHill60

13-Dec-21 1:09

Quote:
crashes somewhere on the server

What are the symptoms of that "crash" - any errors reported?

An unhandled exception occurred while processing the constructor in ASP.NET Core MVC

Alex Dunlop6-Dec-21 7:51

Re: An unhandled exception occurred while processing the constructor in ASP.NET Core MVC

6-Dec-21 7:51

I use the following code for dependency injection of Register/Login controller. The problem is that I cannot use Repository pattern I have created previously.

private readonly UserManager<AppUser> _userManager;
        private readonly SignInManager<AppUser> _signInManager;
        private readonly IUserRepository _userRepository;

        public HomeController(UserManager<AppUser> userManager, SignInManager<AppUser> signInManager, IUserRepository userRepository)
        {
            _userManager = userManager;
            _signInManager = signInManager;
            _userRepository = userRepository;
        }

When I run the code, the following error is occured:

Quote:
InvalidOperationException: Unable to resolve service for type 'CustomizedIdentity.Repositories.IUserRepository' while attempting to activate 'CustomizedIdentity.Controllers.HomeController'.

modified 6-Dec-21 14:00pm.

Richard Deeming6-Dec-21 21:54

Re: An unhandled exception occurred while processing the constructor in ASP.NET Core MVC

6-Dec-21 21:54

You haven't registered an implementation of your IUserRepository service in your DI container. You need to fix your service registration code to register that service, and any services it depends on.

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

Alex Dunlop7-Dec-21 7:09

Use Active Directory for authentication

7-Dec-21 7:09

Thanks, Solved.

Joseline Riker2-Dec-21 5:50

Joseline Riker

2-Dec-21 5:50

I am trying to create a site on IIS that can allow users to manually thru their mobile phones (yes they will have access to this internal site), and use their AD username/password to login. Anyone that's valid is allowed in. Once authenticated will present the next page. Plus that next page wouldn't allow them on it unless they are authenticated. Does anyone have any sample ASP.NET Web examples to get me started? Don't usually develop applications within IIS other than HTML pages so looking for any samples to get me started. Having a hard time finding one that isn't how to use Azure online.

Is this data annotation correct for date and time?

Alex Dunlop25-Nov-21 22:26

Re: Is this data annotation correct for date and time?

25-Nov-21 22:26

Hi,
I'm creating models for my ASP.NET Core project. I want to use "Code First" approach to create database and tables. Please check these annotations to be correct:

[Required]
       [DataType(DataType.Date)]
       [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]
       public DateTime creationDate { get; set; }
       [Required]
       [DataType(DataType.Time)]
       [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:HH:mm:ss}")]
       public DateTime creationTime { get; set; }

And please tell me that what 0 means inside the curly braces.

Richard MacCutchan26-Nov-21 0:02

Re: Is this data annotation correct for date and time?

26-Nov-21 0:02

The DataFormatString value is a format string to convert a date to a string in the format shown. The zero gives the position of the data parameter (following the format string) when the format is used, like:

string theDate = string.Format(DataFormatString, someDateTimeValue);

See String.Format Method (System) | Microsoft Docs[^]

Alex Dunlop26-Nov-21 0:28

Re: Is this data annotation correct for date and time?

26-Nov-21 0:28

Is data annotation for the time correct?

[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:HH:mm:ss}")]

Richard MacCutchan26-Nov-21 0:39

Re: Is this data annotation correct for date and time?

26-Nov-21 0:39

I deliberately did not answer that part because I don't know the answer. Does it correspond to the documentation?

Alex Dunlop26-Nov-21 0:45

Re: Is this data annotation correct for date and time?

26-Nov-21 0:45

No, I did not find any reference for time format. Can I use String type instead?

Richard MacCutchan26-Nov-21 0:56

Re: Is this data annotation correct for date and time?

26-Nov-21 0:56

As I said above: DataType Enum (System.ComponentModel.DataAnnotations) | Microsoft Docs[^].

jkirkerx28-Nov-21 9:12

jkirkerx

28-Nov-21 9:12

I get what you want to do here, which is to create models to match your database perhaps, so each table has a matching model. But your over thinking this, and don't need that much detail. Keep it simple and flexible at first, and only add detail when needed. For some reason Microsoft likes to capitalize the first letter, and will nag you later about the first letter being lower case.

This is an example model in c# to match a DB table or collection. Your example is a like a model used to present data in the view. Even when presenting data in the view, I would keep that simple as well. You want to craft models as simple as possible, and try to make them as reusable as possible to keep models down in count.

public class PORTFOLIOS
    {
        // standard BsonId generated by MongoDb 

        public string Id { get; set; }
        public DateTime TimeStamp { get; set; }        
        public string Name { get; set; }
        public string Description { get; set; }
        public string CreatedBy { get; set; }
        public string UpdatedBy { get; set; }
        public DateTime UpdateDate { get; set; }
        public string HTML { get; set; }
        public string AvatarB64 { get; set; }
        public string AvatarName { get; set; }
        public string AvatarType { get; set; }
        public string AvatarUrl { get; set; }
        public int AvatarX { get; set; }
        public int AvatarY { get; set; }        
    }

If it ain't broke don't fix it
Discover my world at jkirkerx.com

Cannot establish local connection to SQL SERVER

Alex Dunlop24-Nov-21 23:15

Re: Cannot establish local connection to SQL SERVER

24-Nov-21 23:15

Hi,
I'm using ASP.NET Core 6. I'm trying to establish a local connection with SQL SERVER. The authentication method is Windows Auth. I used the following code in appsettings.json:

ASP

"ConnectionStrings": {
    "AuthConnectionString": "Server=.;Database=AspNetAuth;Trusted_Connection=True"
  }

And following code in program.cs:

ASP

builder.Services.AddDbContext<AuthDbContex>(options => options.UseSqlServer(builder.Configuration.GetConnectionString("AuthConnectionString")));
builder.Services.AddIdentity<IdentityUser, IdentityRole>().AddEntityFrameworkStores<AuthDbContex>();

I created Migration, but when I try to update database, the following error is occured:

Quote:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Richard MacCutchan25-Nov-21 0:37

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 0:37

Are you sure that . is a valid server address?

Richard Deeming25-Nov-21 1:15

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 1:15

In a SQL connection string, . resolves to the local computer.

You can even use it with a named instance - for example: server=.\SQLEXPRESS

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

Richard MacCutchan25-Nov-21 1:18

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 1:18

Thanks, not seen it used before.

Richard Deeming25-Nov-21 1:19

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 1:19

There are many possible causes of that error. For example, do you have a default instance[^] (not a named instance) of SQL Server running on your local computer? Is it properly configured to accept named pipe connections[^]? Is your Windows account correctly configured for access[^]?

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

jsc4225-Nov-21 2:56

jsc42

25-Nov-21 2:56

A SO answer at "sql server - What is a Trusted Connection? - Stack Overflow[^]" has 'Trusted_Connection=Yes;', not 'Trusted_Connection=True;'. Worth a try?

Re: Cannot establish local connection to SQL SERVER

Richard Deeming25-Nov-21 3:33

Re: Cannot establish local connection to SQL SERVER

25-Nov-21 3:33

Both the System.Data.SqlClient and Microsoft.Data.SqlClient libraries say that you can use true, yes, or SSPI for the value, and either Trusted_Connection or Integrated Security as the key.

The "strongly recommended" version is Integrated Security=SSPI.

SqlConnection.ConnectionString Property (Microsoft.Data.SqlClient) | Microsoft Docs[^]
SqlConnection.ConnectionString Property (System.Data.SqlClient) | Microsoft Docs[^]

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

Alex Dunlop25-Nov-21 9:02