Tagged Questions
5
votes
1answer
43 views
Is Data Reader better or Data Set for application where we may have Concurrency issue
I know the difference between Data Reader and Data Set.
The DataReader is a better choice for applications that require optimized read-only, fast and forward-only data access.
The Data set is better ...
0
votes
1answer
31 views
Sending several sql commands in a single transaction
I have a huge list of "insert into..." string.
Currently run it with:
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
foreach (var commandString ...
1
vote
0answers
52 views
SQL Parameters in C# aren't working as expected
I think I'm making a fairly amateur mistake somewhere here, but I can't get SQL Parameters to reliably work in C#. Consider the following code:
protected string[] Query(string dataToFind, ...
0
votes
2answers
31 views
SQL server - inserting a string with a single quotation mark
I iterate over an external source and get a list of strings. I then insert them into the DB using:
SqlCommand command = new SqlCommand(commandString, connection);
command.ExecuteNonQuery();
Where ...
0
votes
0answers
20 views
How to crawl a website/extract data into database C# and SQLSERVER
I want to build an single cumulative webapp where users of my organization can use only one site instead of more than ten sites for different purposes.My organization have different sites for ...
0
votes
0answers
7 views
How do I insert a polygon to a geography column in a stored procedure from code-behind?
I have the below from the MSDN website. I can't figure out how to pass that kinda of data to a stored procedure from .NET code. I see that a single point can be passed in with the Point class, but how ...
0
votes
1answer
20 views
How to check last updated value in the DB with ef and c#
I have a sql server DB which contains a table. I am accessing the data through ef. The table contains a "timestamp" column. I would like to query the table by the timestamp in order to find the last ...
0
votes
0answers
16 views
“Error: Cannot Initialize OLE” When I try to run a SPA?
I'm trying to run the standard ASP.NET MVC 4 Single Page Application, but when I try to run it (Ctrl + F5), I get the following error message:
Unable to launch the IIS Express Web server.
...
1
vote
1answer
23 views
Odbc connection string results in login failed
Hi I have been trying all day to connect to my local sql-server database using ODBC but I seem to be missing something because every time I am trying to conenct I get this error:
ERROR [42000] ...
0
votes
1answer
28 views
how to code on on image button if image button are in listview in asp.net C#
Here is a code tag code of asp.net
and there is a Image button where i want code on click event for download item
i try to code on click event but it was not working
<asp:ListView ...
1
vote
3answers
30 views
How to get result from stored procedure and save result in a class attributes
I have following code:
public static void executeStoredProcedure(SqlCommand sp)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString=Connection.getConnection();
...
2
votes
1answer
46 views
Showing a progress bar for a database insertion
I have an application in which the user uploads an Excel file containing several hundreds rows and when he hits upload the file is converted to a DataTable and sent to the database to be inserted by a ...
0
votes
2answers
30 views
Align data from database to listbox
I tried to align data in listbox using \t but did'nt works for a data that is long
using (SqlConnection myDatabaseConnection = new SqlConnection(myConnectionString.ConnectionString))
{
...
-2
votes
0answers
32 views
Good database for C# deployment? [closed]
I have an application in C# but still not decided on which database to use. I have these choices but still not decided which database is good to deploy? My concern is more on deployment and just ...
0
votes
1answer
30 views
Designing app to load, edit, and save hierarchical data
I am writing a GUI that will be integrated with SAP Business One. I'm having a difficult time determine how to load, edit, and save the data in the best way possible (reliable, fast, easy).
I have ...
