How to create a new SQL Server database from ASP.NET without using script
We have a production database that we apply changes to its structure frequently.
sql-server
Would using TOP (N) and OPTION(FAST N) interfere with GridView’s built-in Optimizations?
I am using a GridView which could potentially display half a million records (depending on the options the user selects in filtering the data).
Specifying windows account for SSIS SourceConnectionOLEDB
I’m starting an SSIS package from an .aspx using sp_start_job on the SQL-server.
What will be the best practices in my code to prevent sql injection?
What will be the best practices to prevent sql injection? My client asked me to prevent sql injection. I used this structure for data inserting or updating public bool Add(GreenItem aGreenItem, Employee emp) { aGreenItem.GreenItemCode = new CommonBLL().GetMaxId("[GreenItemCode]", "[Processing].[GreenItem]", "GTM"); using (SqlConnection objConnection = Connection.GetConnection()) { SqlTransaction transaction = objConnection.BeginTransaction("SampleTransaction"); try { string query = … Read more
Conversion of varchar into datetime data type
This is in Microsoft SQL Server Management Studio; I have a column Order_Date in my table, and the data type is datetime.
Unable to access data in an ASP.NET MVC web application using Entity Framework and SQL Server database
In an ASP.NET MVC web application, I have created the following entity:
SQL connection string is not recognised and throws and exception in C#
CONTEXT: I am writing a WPF app. It works with a SQL Server database in which I put some data, concretely the strings Titulo and Descripcion, the int XP and the string fotoMision. When I click a button the program is supposed to save this data in the database.
Conversion failed when converting the varchar value ‘Batsman’ to data type int
This is my C# code – I am running the query
How to make components disappear when I select something from the list?
What I’m trying to do: When I select “PRODUSE” from the dropdownlist the following happens. “nume1” and “salariu” disappear / become inaccessible. The same goes for the other components in the list. What’s wrong with my if? Why doesn’t it work.
SQL Network Interfaces, error: 50 – Local Database Runtime error occurred. Cannot create an automatic instance
I am trying to build an ASP.NET MVC 5 Web Application which has a MyDatabase.mdf file in the App_Data folder. I have SQL Server 2014 Express installed with a LocalDb instance. I can edit the database tables using the Server Explorer, however when I debug the application and go to a page where the database is needed I get the following error.