Questions




Answers
0
How to show date time with am/pm using C# in ASP.NET?

I have datetime saved in the database as "2019-04-06 15:22:23.150" now, how can show this date time value to user with am/pm using C# or Razor syntax in MVC View?

Sample output : 09/04/2019 03:52 PM

Thanks

...
Read More
ASP.NET MVC C# datetime-format
Answers
1
How to check or uncheck checkbox using jQuery?

I have some filters on page so when clicking on "x" button of a selected filter, need to remove the filter and uncheck the checkbox using jQuery, so How can I do that on dynamically created element using jQuery?

...
Read More
jQuery HTML check-uncheck-checkbox
Answers
1
Error "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." in SQL server

I was trying to run my amazon RDS account using MS SQL server management studio, and was able to login succesfully but when using that values in web.config and loading page in browser, I am getting error as below

"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

How Can I resolve this issue, here is my Connection string

...
Read More
SQL SQL-Server
Answers
1
Not able to start SQL server browser in windows

Today, I was trying to Start my SQL server browser using SQL server configuration manager in windows 10, but I cannot see any option to start it as it is blurred and not clickable, so cannot start SQL server browser, here is the screenshot of my pc

...

Read More
SQL SQL-server sql-server-browser
Answers
1
How do I update .edmx file to get new columns in Visual Studio 2017 (ASP.NET MVC)?

I was trying to update my .edmx (ADO.NET) file to get updated or you can say newly added columns, but I wasn't able to get it, what is the proper way to update  or refresh the model to get new database table columns, when the database changes.

I do not want the process of deleting the complete Models and again adding them from database.

...
Read More
ASP.NET entity-framework ado-net-edmx-file
Answers
1
Fetch multiple table data using Single Query in ASP.NET using Entity framework.

I want to get data from related entity based on multiple conditions in a single query

I have two tables Employee(EmpId,EmpName) and Attendance(AttId,ScanType,ScanTime,EmpId), I want to display data for each month for all Employees. In Attendance table Scan type have multiple values for in-time and out-time. I want to select smallest value as in-time and largest value as out-time for each employee and store for each employee in view model. ViewModel(EmpId,In-time,Outtime).

What will be the query for this?

 

...
Read More
ASP.NET C# Entity-framework-core-2
Answers
0
Error System.NullReferenceException while accessing Parent entity property in child entity

I am trying to access a property of parent entity which is on one side of relation while in child entity but it is giving me null reference exception. May be its problem of lazy loading which is not available in entity framework core 2.0. How to access it in core 2.0. These are details of problem

...
Read More
ASP.NET NullReferenceException Entity Framework Core 2.0
Answers
1
How to delete a file, after checking if it exists or not using C#?

I would like to know, how can I delete a file, after checking if it exists on the hard disk, if yes, then delete it, using C# in asp.net?

Thanks

...
Read More
C# ASP.NET Delete a file using C#
Answers
1
Remove duplicates from datatable in C#

Hello

based on this

https://www.technical-recipes.com/2017/obtaining-combinations-of-k-elements-from-n-in-c/#comment-52343

I create my data and I store them in a datatable.

Now I have another datatable which I fill it from my database.

I need to remove the duplicates from the first datatable and fill a datagridview.

This is what I have so far

...
Read More
C# remove-duplicates-from-datatable
Answers
1
How to disable auto-complete in HTML Form input field?

Hello, I would like to know, how I can disable HTML form input field auto-complete, done by chrome and other majore browsers.

Thanks

...
Read More
HTML autocomplete off

Page 1 of 42