All Questions
Tagged with sql-server-2005 .net
398
questions
0
votes
1
answer
80
views
Auto applied migrations using EF Core 7.0.14
When I make a new migration (Add-Migration Example) , and then I try to get all the migrations (Get-Migration) I find that the "applied" field is "True" without even using (Update-...
-1
votes
1
answer
647
views
What is the equivalent of SQL Server 2005 IMAGE Datatype in C#
I have a stored procedure that I am calling in C# in data layer. So it has many parameters and one of which is bytes array
byte[] value
However, the column in the stored procedure and hence the ...
0
votes
1
answer
397
views
.Net datetime with milliseconds sql server using bulkcopy thows exception
I have this code, which throws exception.
SqlConnection con;
con = new SqlConnection(connectionStr);
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd....
0
votes
0
answers
27
views
How is it possible to have changes in a database available at a later stage inside a local transaction?
I have a vb.net application that updates a record in table A and then inserts a record in the same table, inside a local transaction (in SQL Server 2005.)
_DbConnection.Open()
Try
_Transaction = ...
0
votes
2
answers
1k
views
String or binary data would be truncated. The statement has been terminated.?
here's my piece of code. when i execute i get an error as give below
If Val(dr("USE_Amount").ToString) >= Val(txtprice.Text) Then
dr.Close()
msg = "Ref No : ...
0
votes
2
answers
3k
views
sql server 2005 connection open error - An existing connection was forcibly closed by the remote host
I am getting following error when trying to open a connection to SQL Server 2005. I am using .Net SqlConnection class and the error is thrown when open() is called. My code runs properly from local ...
0
votes
1
answer
265
views
.net application hangs in iis7.0 at peak time randomly
we have our own webserver in that internal applications are hosted in that one of the application will be used at peak time by around 300 employees
this application get hangs some times in peak time
...
0
votes
0
answers
45
views
SQL Server -> .Net int conversion
I had a line of code in a WinForms app (target platform x86) I made which contained this...
if (dtMax.Rows[0][0] != System.DBNull.Value)
iPrevMax = (Int64)(dtMax.Rows[0][0]);
I know that ...
0
votes
1
answer
493
views
Take Sql server Database backup on network drive
I have created a Database backup job on sql server 2005 and this job is creating daily backup on sql server.
But I want it will take the backup on network drive or location, when I am giving network ...
0
votes
0
answers
29
views
Issue in connecting to SQL DB
I have SQL Express on my machine. I asked the System Admin to attach a DB for me(viz, ACC_DB). I opened my SQL Express and tried to connect to that DB, I couldn't connect. Then someone suggested I ...
-1
votes
2
answers
2k
views
Replacing the appendLine in string builder in c#
I have a StringBuilder that builds a string. After it is all processed, it saves to a SQL Server table to be used as a csv. How do I replace a part of the string including the newline?
The code is:
...
0
votes
1
answer
112
views
SQL server database tables are not accessed
I have created a web-service using asp.NET with SQL Server 2005 database. Then I published it to local IIS, but when I publish it Visual Studio showed me an error stated that:
the process cannot ...
0
votes
0
answers
36
views
web-service hosted on IIS
I create a web-service in asp.NET. It works as I need. i.e. I can test it in the browser and connect to the database properly. After that, I host it in the IIS Manager. Now, when I try to test the ...
0
votes
0
answers
240
views
What is the most efficient way to bring large amount of data from the database?
I have a stored proc that returns 7 data tables from a SQL Server in its resultset. It uses about 400 MB of bandwidth to bring the data to the client for processing.
The code to bring the data ...
0
votes
1
answer
62
views
how display blog post on webapplication+c#+asp.net
I am creating a website which needs to have blogs displayed on the page.I dont have any idea on this.I am using .net with c# language and sql server 2005.i m not using MVC architecture.please suggest ...