Re: Problems with Sql Express - C# Discussion Boards

Re: how do i execute file in program

7-Aug-06 4:56

System.Diagnostic.Process.Start("help.chm");

bspman7-Aug-06 5:01

bspman

7-Aug-06 5:01

Thanks

Problems with Sql Express

kulile7-Aug-06 4:43

kulile

7-Aug-06 4:43

Good day

Im writing a little application sends information to a Sql Express database for a duration of time (maybe 5 minutes). The application works fine but when I run it from two workstations at the same time, i get deadlocks. I have gone through my code a lot of times and i dont see anything wrong there.

Could there be a problem with Sql Express and concurrent transaction?

Kulile --- RSA

Re: Problems with Sql Express

Guffa7-Aug-06 8:45

Guffa

7-Aug-06 8:45

Where does it say that the deadlocks occur, and what do you do with those tables?

If I'm not mistaken, SQL Express uses the same transaction handling as SQL Server, which is up to version 9.0, so it's rather well tested. It's quite more likely that the problem is in your code than the database server.

---
b { font-weight: normal; }

Re: Problems with Sql Express

Colin Angus Mackay7-Aug-06 8:47

Colin Angus Mackay

7-Aug-06 8:47

Damn! You beat me to it. Big Grin | :-D

* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: Problems with Sql Express

Colin Angus Mackay7-Aug-06 8:46

Colin Angus Mackay

7-Aug-06 8:46

kulile wrote:
Im writing a little application sends information to a Sql Express database for a duration of time (maybe 5 minutes).

Are you saying that you have a transaction that lasts 5 minutes?

If yes, then I guess this would cause a deadlock because while the transaction is in progress on one workstation it will lock things in the database untill the transaction is committed or rolledback. Obviously the other workstation needs those resources too.

kulile wrote:
Could there be a problem with Sql Express and concurrent transaction?

No. SQL Server 2005 Express is unlikely to be the problem.

* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

How do I listen packets sent between a server/client application?

Igor Lima7-Aug-06 3:52

Igor Lima

7-Aug-06 3:52

I want to make a 3rd party program that listen packets sent between a server/client application running on my PC. I think that it’s done by placing a hook that capture the packets sent, but I don’t know how to do it. Can anyone help me please?

Re: How do I listen packets sent between a server/client application?

stancrm7-Aug-06 4:48

Re: How do I listen packets sent between a server/client application?

7-Aug-06 4:48

There are lots of articles in codeproject for that:

http://www.codeproject.com/cs/internet/sharppcap.asp
http://www.codeproject.com/csharp/pacanal.asp
http://www.codeproject.com/dotnet/dotnetwinpcap.asp
http://www.codeproject.com/csharp/pktcap.asp

Eric Dahlvang7-Aug-06 5:27

Eric Dahlvang

7-Aug-06 5:27

clickety:
http://www.codeproject.com/cs/internet/sharppcap.asp[^]
http://www.codeproject.com/csharp/pacanal.asp[^]
http://www.codeproject.com/dotnet/dotnetwinpcap.asp[^]
http://www.codeproject.com/csharp/pktcap.asp[^]

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Re: How do I listen packets sent between a server/client application?

Shy Agam7-Aug-06 5:33

Shy Agam

7-Aug-06 5:33

lol... I voted 5 for your reply! Laugh | :laugh:

Automatic Update

pirogramci7-Aug-06 3:37

pirogramci

7-Aug-06 3:37

Hello everybody.

I create a relation between two table by using below code.

ds.Relations.Add("REL", ds.Tables["Parent"].Columns["A"], ds.Tables["Child"].Columns["B"]);

After that I delete a record from table Parent which is parent table. Deleting proccess running truly however child rows have not been deleted from other table.
What must I do.

Thanks.

Re: Automatic Update

wheelerbarry7-Aug-06 3:52

wheelerbarry

7-Aug-06 3:52

I believe you need to set up the relation with a cascade delete to remove the child rows.

This can be done by setting delete rule of the relation to Cascade.
e.g.
DataRelation rel = new DataRelation(ect);
rel.ChildKeyConstraint.DeleteRule = Rule.Cascade;
ds.Relations.Add(rel);

(I have not tried this so am not 100% sure it will work)

Re: Automatic Update

pirogramci7-Aug-06 4:15

pirogramci

7-Aug-06 4:15

I used below codes but it didn't work.

ds.EnforceConstraints = true;
ds.Relations["REL"].ChildKeyConstraint.DeleteRule = System.Data.Rule.Cascade;
ds.Relations["REL"].ParentKeyConstraint.DeleteRule = System.Data.Rule.Cascade;

Re: Automatic Update

wheelerbarry7-Aug-06 4:46

wheelerbarry

7-Aug-06 4:46

Sorry.

There is a Constraints property on the DataTable. Try creating a ForeignKeyConstraint object and setting the DeleteRule = Rule.Cascade, then add it to the child table.

tab controle

john347-Aug-06 3:29

7-Aug-06 3:29

Hi all,

I have a tabcontrole with a usercontrole placed on one of the tabs.
on this usercontrole is a button, when the user clicks the button i need to change the selected tab on the tabcontrole.

anybody got any ideas ???
any help would be most appreciated !!!

Thanks
John

stancrm7-Aug-06 3:36

7-Aug-06 3:36

this.tabControl1.SelectedIndex = 1;

Just fill .SelectedIndex with the TabIndex what you want.

john347-Aug-06 3:54

7-Aug-06 3:54

thanks for the answer but this doesnt work Frown | :-(

The problem is that this. refares to the usercontrole and not the form with the tabcontrole on it.

any more help would be great !!!!

Thanks
John

stancrm7-Aug-06 4:55

7-Aug-06 4:55

What is "this" ?

Is "this" a TabControl ?

If yes, then use this.SelectedIndex = 1; (for example)

john347-Aug-06 5:07

7-Aug-06 5:07

What is "this" ?

The this keyword refers to the current instance of the class.

My problem is how to reference the form from within a usercontrole placed on the form.

for example tabcontrol.SelectedIndex = 1; would not be able to escape the usercontrole subsequently it would not work because the tabcontrole is placed on the form not the usercontrole

Hope this makes my prob clearer !

Thanks once again for your time Smile | :)

Stefan Troschuetz7-Aug-06 5:17

Stefan Troschuetz

7-Aug-06 5:17

john34 wrote:
My problem is how to reference the form from within a usercontrole placed on the form.

Use the FindForm method.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

john347-Aug-06 5:55

7-Aug-06 5:55

this wont let me at the tabcontrol.selectedindex or any of the public methods on the form Frown | :-(

Thanks again though Smile | :)

john347-Aug-06 6:07