Click here to Skip to main content
15,897,518 members
Home / Discussions / C#
   

C#

 
AnswerRe: Running SQL Server 2008 R2 without user interaction Pin
Richard MacCutchan11-Sep-13 22:26
mveRichard MacCutchan11-Sep-13 22:26 
GeneralRe: Running SQL Server 2008 R2 without user interaction Pin
WaseemAmin12-Sep-13 5:54
WaseemAmin12-Sep-13 5:54 
AnswerRe: Running SQL Server 2008 R2 without user interaction Pin
PIEBALDconsult12-Sep-13 3:03
mvePIEBALDconsult12-Sep-13 3:03 
GeneralRe: Running SQL Server 2008 R2 without user interaction Pin
WaseemAmin12-Sep-13 6:02
WaseemAmin12-Sep-13 6:02 
GeneralRe: Running SQL Server 2008 R2 without user interaction Pin
PIEBALDconsult12-Sep-13 14:11
mvePIEBALDconsult12-Sep-13 14:11 
Generalreadonly keyword Pin
N8tiv11-Sep-13 20:38
N8tiv11-Sep-13 20:38 
GeneralRe: readonly keyword Pin
Pete O'Hanlon11-Sep-13 21:05
mvePete O'Hanlon11-Sep-13 21:05 
GeneralRe: readonly keyword Pin
N8tiv11-Sep-13 21:18
N8tiv11-Sep-13 21:18 
GeneralRe: readonly keyword Pin
Pete O'Hanlon11-Sep-13 22:58
mvePete O'Hanlon11-Sep-13 22:58 
GeneralRe: readonly keyword Pin
N8tiv11-Sep-13 23:12
N8tiv11-Sep-13 23:12 
GeneralRe: readonly keyword Pin
Abhinav S12-Sep-13 8:22
Abhinav S12-Sep-13 8:22 
GeneralRe: readonly keyword Pin
DaveyM6913-Sep-13 9:40
professionalDaveyM6913-Sep-13 9:40 
Questiondelay and back again record Pin
eng.iris11-Sep-13 18:07
eng.iris11-Sep-13 18:07 
AnswerRe: delay and back again record Pin
Eddy Vluggen12-Sep-13 2:58
professionalEddy Vluggen12-Sep-13 2:58 
GeneralRe: delay and back again record Pin
eng.iris12-Sep-13 8:21
eng.iris12-Sep-13 8:21 
GeneralRe: delay and back again record Pin
Eddy Vluggen12-Sep-13 10:42
professionalEddy Vluggen12-Sep-13 10:42 
GeneralRe: delay and back again record Pin
Eddy Vluggen13-Sep-13 7:06
professionalEddy Vluggen13-Sep-13 7:06 
eng.iris wrote:
i dont get ur idea
"Your" idea; we don't do textspeak here. I've recreated a simplification of your tables below, and you said that you'd be moving a record from table A to table B, when a timer-event occurs.
SQL
CREATE TABLE A (
pationt_no   BIGINT
pationt_name VARCHAR(250)
test_time    DATETIME)

CREATE TABLE B (
pationt_no   BIGINT
pationt_name VARCHAR(250)
test_time    DATETIME)
You could remove table B from the design, simply by adding a flag (a boolean/bit field) to table A;
SQL
CREATE TABLE A (
pationt_no   BIGINT
pationt_name VARCHAR(250)
test_time    DATETIME
IsInTableB   BIT)
Whenever you'd want all records that are in A, but not in B, you'd extend the WHERE clause with a filter for the IsInTableB column, like below;
SQL
SELECT *
   FROM A
  WHERE IsInTableB = False


eng.iris wrote:
when delay button clicked i move the current record to another datatabbe and after 2 min i restore it back to the original datatable but unfortunately i get an error

"that deleted records cant be inserted " ? even if i refreshed my datasource
That datatable is an in-memory representation of the real table. I'd recommend using SQL-statements to update the physical table in the database - that way the information doesn't get lost when the application or the power fails.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

Questiontv show control in c# Pin
eng.iris11-Sep-13 17:54
eng.iris11-Sep-13 17:54 
AnswerRe: tv show control in c# Pin
Abhinav S11-Sep-13 18:24
Abhinav S11-Sep-13 18:24 
General"this" keyword Pin
N8tiv11-Sep-13 17:17
N8tiv11-Sep-13 17:17 
GeneralRe: "this" keyword Pin
Ron Beyer11-Sep-13 17:35
professionalRon Beyer11-Sep-13 17:35 
GeneralRe: "this" keyword Pin
N8tiv11-Sep-13 18:08
N8tiv11-Sep-13 18:08 
GeneralRe: "this" keyword Pin
Ron Beyer11-Sep-13 18:15
professionalRon Beyer11-Sep-13 18:15 
GeneralRe: "this" keyword Pin
N8tiv11-Sep-13 18:26
N8tiv11-Sep-13 18:26 
GeneralRe: "this" keyword Pin
Ron Beyer11-Sep-13 18:50
professionalRon Beyer11-Sep-13 18:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.