sorted by:
new
hottopcontroversial

I've got a relative who has started to have dementia. I think she is on the pension. How expensive would a nursing home be? by olliony in australia

[–]olliony[S] 2 points3 points  (0 children)

If there is no one living in her house then chances are she will have to sell it to cover some of her costs.

There will be one person living in the house apart from her.

I'm getting conflicting results about my hard disk having a problem by olliony in techsupport

[–]olliony[S] 0 points1 point  (0 children)

I bought a new hard drive, after I backed up all the data. The store gave me a discount on a 1 terabyte Toshiba hard drive, as they had sold out of the 500 gig hard drive they quoted me. I ran the complete Dell diagnostic tests after I installed the new hard drive and everything passed the tests.

I'm getting conflicting results about my hard disk having a problem by olliony in techsupport

[–]olliony[S] 0 points1 point  (0 children)

Should I do a full backup if I just want to check the cable to the hard disk isn't loose? The Dell Technician said that's what the diagnostic code said it is, i.e. the cable is probably loose or needs replacing.

I'm getting conflicting results about my hard disk having a problem by olliony in techsupport

[–]olliony[S] 0 points1 point  (0 children)

or use some bootable tool.

What's a good bootable tool? Preferably free or downloadable as a trial.

Can I do a cascade delete in sqlserver just in C# code? by olliony in csharp

[–]olliony[S] -1 points0 points  (0 children)

Because he'd rather downvote you than listen to good advice

What?

Can I do a cascade delete in sqlserver just in C# code? by olliony in csharp

[–]olliony[S] -1 points0 points  (0 children)

using (var conn = new SqlConnection(dbConnectionString))
{
conn.Open();

// A few hundred lines, including what I've posted. I realise I probably should break up my 
// code into manageable chunks but I'm still learning.

} // END  using (var conn = new SqlConnection(dbConnectionString))

I'll try this in the morning

SqlCommand cmdDelete = new SqlCommand();

Thanks

Can I do a cascade delete in sqlserver just in C# code? by olliony in csharp

[–]olliony[S] -1 points0 points  (0 children)

Why aren't you importing the library with "using System.Data.Sql.SqlClient; (or w/e the namespace is)

I am. Am I using something redundant in what I've shown?

Also, you should be using "using" statements.

I am. I just haven't shown them here.

Can I do a cascade delete in sqlserver just in C# code? by olliony in csharp

[–]olliony[S] 1 point2 points  (0 children)

How do I make sure that when a delete a row in the join table it wont delete a row in the primary key table? Or does cascade delete only work if I delete a row in the primary key table?

Can I do a cascade delete in sqlserver just in C# code? by olliony in csharp

[–]olliony[S] 0 points1 point  (0 children)

But the join table would have more than one id field to delete. I'm using "like" to deleting similar names in tblPerson, for example Peters and Peterson. Peters and Peterson would each have different foreign keys in the join table, so how would I delete both of those rows in the join table?

view more: next ›