Tagged Questions
60
votes
12answers
7k views
Are Parameters really enough to prevent Sql injections?
I've been preaching both to my colleagues and here on SO about the goodness of using parameters in SQL queries, especially in .NET applications. I've even gone so far as to promise them as giving ...
43
votes
9answers
34k views
EF 4.1 exception “The provider did not return a ProviderManifestToken string”
I am trying to replicate an example found on MSDN. I am using ASP.NET and EF 4.1 (CTP?). I've used NuGet to install the EntityFramework package.
I am getting this error: "The provider did not return ...
32
votes
6answers
61k views
Default port for SQL Server
I need to know the default port settings for the following services
SQL Server
SQL Browser
SQL Reporting services
SQL Analysis services
I neeed to know the port settings for these services for ...
29
votes
11answers
5k views
Images in database vs file system
We have a project coming up where we will be building a whole backend CMS system that will power our entire extranet and intranet with one package. The question I have been trying to find an answer to ...
23
votes
9answers
21k views
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
I make an outer join and executed successfully in the informix database but I get the following exception in my code:
DataTable dt = TeachingLoadDAL.GetCoursesWithEvalState(i, bat);
Failed to ...
21
votes
6answers
26k views
Howto? Parameters and LIKE statement SQL
I am writing a searching function, and have thought up of this query using parameters to prevent, or at least limit, SQL injection attacks. However, when I run it through my program it does not ...
20
votes
3answers
8k views
Connect to AS400 using .NET
I am trying to build a .NET web application using SQL to query AS400 database. This is my first time encountering the AS400.
What do I have to install on my machine (or the AS400 server) in order to ...
8
votes
2answers
1k views
EntityFramework Same Table Many to Many Relationship
I have a table called Products which obviously contains products.
However, I need to create related products. So what I've done is create a junction table called product_related which has two PKs. ...
5
votes
8answers
4k views
Preventing SQL Injection in ASP.Net VB.Net
I have this code
UPDATE OPENQUERY (db,'SELECT * FROM table WHERE ref = ''"+ Ref +"'' AND bookno = ''"+ Session("number") +"'' ')
How would I prevent SQL Injections on this?
Thanks
Jamie
UPDATE
...
1
vote
1answer
603 views
Using DropDownList as paging function in ASP.Net Formview
I have a Formview that gets populated with SQL data when a dropdown is selected, but when I click edit, it wants to edit the first item on the dropdown list, because technically it still thinks its on ...
1
vote
1answer
57 views
MySQL query taking forever to run, what is wrong?
I am using this to make a query where i goes upto 20 in c#.net mysql connectivity.
This query takes forever to execute and when I run it in MySQL shell it takes 3 mins.
All other queries run fine.
...
1
vote
2answers
31 views
how to write a update query for asp.net using session variables?
Newbie alert!
I am currently working on a asp.net project on visual studio without having any previous experience or knowledge with it. I need to write a query which updates according to a where ...
1
vote
2answers
420 views
Using LINQ and a dropdownlist to enter a new record into an SQL Database
Hi Everyone I'm a new and I'm struggling with my asp.net website, Our remit is to make a Veterinary Surgery Booking System.
I have an asp.net page that has 4 fields, one of the fields is populated on ...
1
vote
3answers
111 views
How to avoid sql deadlock?
I use MS SQL 2008 and coding with C# in a web project.
Currently, I got stuck with sql deadlock.
I have 2 transaction, one of two is a long transaction.
When both transaction run simultaneously, ...
0
votes
1answer
21 views
Asp.Net multiple join tables issue from Sqldatasoruce Query Builder into one gridview
In Visual Studio 2010 with ASP.NET 4, I am trying to join several tables together to put the results in a gridview and details view with sqldatasource. In the sqldatasource wizard I have chosen to ...
