0
votes
2answers
45 views
Sql server Caching issue
I am using Sql Server 2008 R2, vs 2008, C# on .Net 3.5 and SqlHelper.
A method, say, updateData(int id) loads some data related to "id", does lots of calculations and processing and recommits the ...
2
votes
2answers
61 views
Dynamically change outcome of JOIN using select parameters
I have a select query I am using that involves a join for a grid view display:
SELECT [Theme].[Name], [ThemeType].[Type]
FROM [Theme]
Left Outer Join [ThemeType] ON [Theme].[ThemeTypeId] = ...
1
vote
3answers
20 views
i want to make conditional trigger in sql server…
i have a table named test and another table named trigg..... what i want is.... whenever data having 'name' as 'rakesh' is being inserted to test...it should fire a trigger to insert the age in the ...
1
vote
4answers
35 views
Error while getting values between dates
I am trying to get a chart date vs number of patients .I am trying to make a chart using MS Chart in asp.net where I get date on x axis and number of patients on y axis.
I am accepting from date and ...
5
votes
1answer
49 views
Can I insert a large text value into SQL Server from ASP.net without having the whole file in memory on the webserver?
As it says in the question, given a large text file, how can I get its contents into a nvarchar(max) column in sql server without loading the entire file contents into memory (either to build a ...
0
votes
2answers
18 views
Insert function to insert record in SQL table working properly but Update Function to Update Record is not working properly
These are my functions to Update student record and Insert Student record in SQL batabase.
public void UpdateStudent(ref student stu, string rollno) //Update the values to corresponding roll number ...
1
vote
0answers
10 views
Converting SMO Data Types to SqlDataTypes
I am using SMO to compare one database against another.
This compare utility is NOT using drop and replace type of logic, It's using ALTER statements.
So, when I compare one column against another ...
0
votes
0answers
15 views
How can I update data in an entity using EF5 when the update json contains linked objects?
I have the following classes:
public partial class Content : AuditableTable
{
public int ContentId { get; set; }
public string Title { get; set; }
public string Text { get; set; }
...
1
vote
5answers
48 views
Time displaying in a date only field from SQL
I have a date field in a SQL table coming in to a DataGridView in c#. But for some reason, it comes with a time too, even though its just a date field.
0
votes
1answer
32 views
Mail alert with new insert in mvc database
How can I send an email alert to my gmail when there is a new entry into a table in the database. My project including database is in MVC4. I have tried the syntax below, but I get the error:
...
0
votes
4answers
19 views
SQL Syntax Error: Remove/Disclude Apostrophe's?
I use the below code to update a Business' information on one of my Windows Forms. When a user puts the Business name in txtBusName as something like "Sandy's Place" I receive Incorrect Syntax near ...
0
votes
0answers
18 views
windows application deployment with custom installer wizard guide and sql database for sql configuration
I've developed my C# windows forms application in MS Visual Studio 2008, .NET framework 3.5 I also have a database in MS SQL Server 2005. I've deployed my application just to test if it works in my ...
-10
votes
0answers
55 views
show result sql search in multi textbox [on hold]
how display sql search in multi rows(for example result more than 1 record)
(per row have multi textbox for fields 1 record)
and how I can update multi row whit 1 command button .
thanks
(asp.net c# ...
1
vote
1answer
24 views
XML Fields with Entity Framework Code First
I'm using Entity Framework with the Code First model (pet project, and I love editing simple classes and having my schema updated automatically). I have a class like follows:
[Table("Polygons")]
...
1
vote
1answer
48 views
query time-out after database restore
I have a CLR compiled stored procedure in SQL server 2008 which has always worked fine.
But after a database restore it suddenly stopped working. It times out. Running the query with the same ...
