All Questions
5,605
questions
1
vote
2
answers
120
views
Multiple tables query with repository pattern
I have an ASP.NET Web API project, and have implemented repository and unitOfWork patterns.
I currently have a big SQL query that I want to implement in code, it includes a lot of tables and joins.
My ...
1
vote
2
answers
62
views
Read a SQL-DOUBLE column as raw
I have data defined as double saved in a PSQL-Database (Actian) and I'm using DbDataReader to read the values. I know I can use GetDouble to read the value, but I would like read the raw value into a ...
0
votes
1
answer
33
views
Transaction Log for database is full because update file about 100mb
I try to insert the data of a file about 100mb in size by splitting it into parts, each about 65,000 characters into the sql server. The first time I insert it and the next time I update that data. ...
0
votes
2
answers
101
views
How to use a parameterized query with "GO" statements in .NET?
I am using ASP.NET as a backend to an application to update some data in a separate system's SQL Server.
I have a query that needs to insert many rows to a table. In each row, the values being ...
-1
votes
1
answer
98
views
Getting a 'Conversion failed when converting date and/or time from character string' error [duplicate]
I have this code:
String strDateFormat = "yyyy-MM-dd";
DateTime startDateDate = string.IsNullOrEmpty(startDate) ? DateTime.Today.AddYears(-10) : DateTime.ParseExact(startDate, strDateFormat, ...
0
votes
0
answers
46
views
select value from a div/script
i have an array with a lot of elements and with that im doing a dependent ddl of departments cities and districts
function showDepartamento(retValue, controlClass) {
if (controlClass == null) { ...
0
votes
0
answers
22
views
Azure Function C# dotnet API Service dependencies issues with System.Diagnositcs.DiagnosticSource [duplicate]
I am trying to create a Microsoft azure function in VS Code on my Mac, I have tried other OS and machines but this issue has happened with various libraries etc.
The error is this :
For detailed ...
0
votes
1
answer
84
views
ASP.NET MVC code-first authentication page, can not upload files
I created an ASP.NET MVC project with authentication and I want to add a new field to register page for uploading an user image. The problem is when I save the new account, the image column is empty.
...
0
votes
1
answer
68
views
Fatal error encountered during command execution, i dont sure is command problem or connection
this is the code behind and now is the problem of while submit and update to sql have a problem. And i dont sure where the problem is it
protected void Page_Load(object sender, EventArgs e)
{
...
0
votes
0
answers
47
views
ASP.NET GridView not showing updated data from database
I have a page where users can search for a PO Number and it will pull up the relevant data for that order from a DataSource that is a SQL database. I have a field in the database, OrderStatus, where ...
0
votes
0
answers
37
views
How to highlight duplicate columns?
This is what I have so far but I'm just confused how it works.
protected void GridView1_PreRender(object sender, EventArgs e)
{
HashSet<string> uniqueValues = new HashSet<string>();
...
0
votes
0
answers
38
views
Many to many relationship using ASP.NET with HTML, CSS and Javascript
I need your help. I am developing a web application with C# ASP.NET and I have a problem. I am using the N-layer architecture and I am using services. So, I don't know how to implement the many-to-...
0
votes
0
answers
53
views
How safe is cookie authentication/authorization in asp.net?
How safe is Cookie based Authentication/Authorization in ASP.NET C#? Take a look at the example below, don't worry about password hashing, is this a secure/semi-secure method, or sufficient enough to ...
0
votes
1
answer
199
views
What are other ways to Authenticate and authorize users/page?
There are multiple ways to authenticate/authorize users. I took a look at Oauth, token based, and identity authentication, and I didn't like any of them. What I ended up doing is when I come to let ...
0
votes
1
answer
58
views
SQL table column name with comma should be saved exactly in same manner in csv file header
I am having SQL table column name as 10,000 and I want it to be saved as 10,000 in csv file. But the problem is when I save the data in csv file 10,000 is saved as 10 in a separate cell and 000 in a ...