Tagged Questions
0
votes
2answers
37 views
How to fetch the next records from a table in sql database one after other
I am developing an application where I need to send the Emails to all the users in the table. Since the number of users is in millions, so to select all the users at once won’t do any good. Is there ...
0
votes
3answers
57 views
Removing data from returned information.
I am making an SQL Query that brings back a list of files and their paths. They have different file paths and different file names ofc.
The file names are dates and time in the following format:
...
0
votes
0answers
13 views
Cascad Add/Update tree (Parent/Child) data using EntityFramework 5
I have some problem
This is database structure
CREATE TABLE [EvaluationProcess].[CriteriaHeader](
[CriteriaHeader_No] [uniqueidentifier] NOT NULL,
[CriteriaHeader_Type] [int] NOT NULL,
...
0
votes
0answers
41 views
best way to display 200 fields from each table (15 tables) on web
I am developing an intranet application with C# and JavaScript. I need to retrieve data from 15 tables and there are 200 fields on each table. I know we can use some asp.net controls (listview, ...
0
votes
1answer
42 views
Retrieve data from database and show in detailsview
I want to retrieve data from database on the current logged in SharePoint user and show it on a control in a detailsview. But I really don't know how to achieve that on the best way. This is a code ...
0
votes
2answers
34 views
Storing data of rich text box to database with formatting
I am new at wpf and I want to store the data of the rich text box along with its formatting (Italic, colored, Bold..) into a database (Mysql).
currently when i save the data, formatting is ignored.
...
1
vote
4answers
51 views
Change the datetime display format on datagridview date column
I want to change the default format(MM/dd/yyyy) of the datetime in the database table to (dd/MM/yyyy) when select and write the date with (dd/MM/yyyy) on the datagridview's date column.
Below is my ...
0
votes
1answer
32 views
Dropdownlist adding list items
I have added some data from the local database to a List, and now I need to show the values this List has inside a dropdownlist. The List contains the following data:
Java
.net
JavaScript
Ruby
...
1
vote
3answers
57 views
Splitting the data in ASP.NET
I am trying to display a column from my local database into a dropdown list. The problem is that I would need to split the data so that they are not displayed all in one line. I have used the ";" to ...
0
votes
2answers
52 views
Cannot run multiple insert record query in firebird via C#
I am generating a multiple insert records query in C# and trying to execute in FireBird.
When I am running it on FlameRobin it works so well. But When I am running it via C# it throws exception.
SET ...
1
vote
3answers
30 views
Will this process affect database availability?
http://rockingtechnology.blogspot.co.uk/2011/06/oracle-backup-and-restore-code-in-cnet.html
As per the proposed code in the above article, more specifically:
ProcessStartInfo psi = new ...
0
votes
2answers
56 views
C#- How to get the days in word in computer current time instead of numbers?
I am building a program in windows form c# which records a daily report. I tried using NOW(); in my MySql database and so far it works but my concern is I want only to get its Days which is not a ...
0
votes
1answer
54 views
Error when trying to update values in database
I have the following c#/Query:
TrackDuration =TimeSpan.Parse( Request.Form["TrackDuration"].ToString());
string InsertQuery = string.Format("UPDATE tblTracks SET TrackLength={0}, ...
-8
votes
1answer
57 views
i keep getting syntax errors c#
I'm doing a music database program and i have added buttons to update the database through the program. eg: edit / new track / delete. but it keeps dragging up syntax errors making the updates only ...
0
votes
1answer
36 views
Entity Framework Transaction not rolling back
The following code is in a loop which executes many times. When I execute the following code it occasionally generates a foreign key exception, which is fine because it is handled and I attempt to ...
