How do we know which rows got deleted in DataTable? - C# Discussion Boards

Lord Kixdemp16-Jul-05 8:18

16-Jul-05 8:18

Well, just set the width of the columnheader of the second control to that of the first control. Hope that helps. Wink | ;)

Darth_Sulfur (Sulfurik)
http://www.SulfurSoft.tk
ftp://tsfc.ath.cx
http://tsfc.ath.cx
hotline://tsfc.ath.cx

SQL SELECT statement syntax

sea#15-Jul-05 21:32

sea#

15-Jul-05 21:32

I'm using this SQL SELECT statement:
int surveyNo
sqlTotal= string.Format("SELECT COUNT(survey{0}) FROM ResultsTbl WHERE survey{0}<>0", surveyNo);

I know the syntax is wrong in the parentheses after the COUNT. How do I fix this syntax, to put the variable value in?

sea#

Re: SQL SELECT statement syntax

Dave Kreskowiak16-Jul-05 6:45

Dave Kreskowiak

16-Jul-05 6:45

First, you should be using parameterized queries to do this.

Your SQL statement should look like this:

SELECT COUNT survey FROM ResultsTbl WHERE survey = @surveyNum

The @surveyNum is a placeholder for a SQL parameter. More information can be found in this[^] article by Colin Angus Mackay.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: SQL SELECT statement syntax

sea#16-Jul-05 9:10

sea#

16-Jul-05 9:10

I need to bring the column no. as parameter. The table has 4 columns: username, survey1, survey2, survey3. SrNo is an int variable the method get. I want to find out How do take this SrNo and "glue" it with survey

This is what I got from the article

sqlTotal= "SELECT COUNT(survey@SrNo) FROM ResultsTbl "+<br />
"WHERE survey@SrNo<>0";<br />
cmdTotal.Parameters.Add("0", survey@SrNo);

not to sue about survey@SrNo syntax. Got error in
cmdTotal.Parameters.Add("0", survey@SrNo);
under survey@SrNo.

sea#

Re: SQL SELECT statement syntax

Dave Kreskowiak16-Jul-05 15:49

Dave Kreskowiak

16-Jul-05 15:49

sea# wrote:
sqlTotal= "SELECT COUNT(survey@SrNo) FROM ResultsTbl "+
"WHERE survey@SrNo<>0";
cmdTotal.Parameters.Add("0", survey@SrNo);

Parameters don't work that way.

I don't know what your trying to return and I don't know what the conditions are. You need to explain how the data is setup in your table and what you want to accomplish.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: SQL SELECT statement syntax

sea#17-Jul-05 6:02

sea#

17-Jul-05 6:02

This is my full method:

public void CalcResults(int SrNo, out int total, out int Ans1, out int Ans2, out int Ans3)
		{
			string sqlTotal;
			string sqlAns1;
			string sqlAns2;
			string sqlAns3;
			
			//SQL statements
			if (SrNo>=1 & SrNo<=3) 
			{
				sqlTotal= string.Format("SELECT COUNT(survey2) FROM ResultsTbl WHERE survey{0}<>0",SrNo);
				sqlAns1= string.Format("SELECT COUNT(survey2) FROM ResultsTbl WHERE survey{0}=1",SrNo);
                sqlAns2= string.Format("SELECT COUNT(survey2) FROM ResultsTbl WHERE survey{0}=2",SrNo);
				sqlAns3= string.Format("SELECT COUNT(survey2) FROM ResultsTbl WHERE survey{0}=3",SrNo);
			}
			
			else
				sqlAns1=sqlAns2=sqlAns3=sqlTotal="No answer was chosen"; 
		
			//Command objects
			OleDbCommand cmdTotal = new OleDbCommand(sqlAns1, cnSurvey);
			OleDbCommand cmdAns1=new OleDbCommand();
			OleDbCommand cmdAns2=new OleDbCommand();
			OleDbCommand cmdAns3=new OleDbCommand();



			cmdTotal.Connection = cnSurvey;
			cmdTotal.CommandType = CommandType.Text;
			cmdTotal.CommandText = sqlTotal;

			cmdAns1.Connection = cnSurvey;
			cmdAns1.CommandType = CommandType.Text;
			cmdAns1.CommandText = sqlAns1;

			cmdAns2.Connection = cnSurvey;
			cmdAns2.CommandType = CommandType.Text;
			cmdAns2.CommandText = sqlAns2;

			cmdAns3.Connection = cnSurvey;
			cmdAns3.CommandType = CommandType.Text;
			cmdAns3.CommandText = sqlAns3;

			//Connect
			cnSurvey.Open();

			//Execute command
			total = int.Parse(cmdTotal.ExecuteScalar().ToString());
			Ans1 = int.Parse(cmdAns1.ExecuteScalar().ToString());
			Ans2 = int.Parse(cmdAns2.ExecuteScalar().ToString());
			Ans3 = int.Parse(cmdAns3.ExecuteScalar().ToString());
				
			//Disconnect
			cnSurvey.Close();
		}

find blue tooth lan connection from registry

ksanju100015-Jul-05 21:18

ksanju1000

15-Jul-05 21:18

Hi My computer has Two lan connection and ONe is conneted through modem.
I am able to find out the only one Lan connection(Ethernet Lan Card) (This setting is retrieved from the registry) and Modem connection is also showing on Winform.
But i am not able to identify Blue Tooth Lan Connection Where it stores inside the registry if Blue tooth lan connection is connected.

I have winform and List box and one button When i press the button it displays all the avaliable Lan and modem and blue tooth lan connection of local host displays inside the list box.
I am able to retrive only two connection right now (Ethernet Lan card and one modem through) but i am not able to identify Bluet tooth connection

Can anoy body tell me how will identify

thanks
sanjeev

How do we know which rows got deleted in DataTable?

rudy.net15-Jul-05 20:09

rudy.net

15-Jul-05 20:09

I have a method in a class that updates an xml file based on an input parameter which is a DataTable.
To update my xml file I use the DataTable methods

 <br />
GetChanges(DataRowState.Modified)<br />
GetChanges(DataRowState.Added)<br />
GetChanges(DataRowState.Deleted)<br />

The problem is that when I call GetChanges(DataRowState.Deleted) I do get a datatable of the rows that were deleted but all I can access is the number of rows but not the row contents so I can't figure out which rows were deleted.

Any help appreciated in advance.

Re: DataGrid's row Color Change

rudy.net15-Jul-05 20:16

rudy.net

15-Jul-05 20:16

See following link: http://www.codeproject.com/csharp/custom_datagridcolumnstyl.asp[^]

Re: DataGrid's row Color Change

rudy.net16-Jul-05 10:12

rudy.net

16-Jul-05 10:12

The only way I could think of doing it is by having a method that when called to set a row color, the method loops through each item in that row and sets the color.

using custom actions

sianatia15-Jul-05 19:13

sianatia

15-Jul-05 19:13

hi,

i want to use a custom action in my deployment project conditionaly but it does not work even when i use the custom action unconditionaly,
let me know how to activate the custom action?

thanks

Load rtf file into a richtextbox while retaining format information

sparks_lu15-Jul-05 12:58

sparks_lu

15-Jul-05 12:58

I am trying to load an rtf file which is created by using Wordpad into a richtextbox. However, the text seems lost some of its format information, e.g. text set to bold and different sizes, after been loaded into the richtextbox. How can I add these texts while retaining their format properties?

Re: Load rtf file into a richtextbox while retaining format information

Dave Kreskowiak15-Jul-05 17:13

Dave Kreskowiak

15-Jul-05 17:13

The RTB control doesn't support all of the formatting that Wordpad or Word saves into their RTF files.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Questions about Kernel32.dll's Beep()

Lord Kixdemp15-Jul-05 11:52

Lord Kixdemp

15-Jul-05 11:52

OK, I have 2 questions about this function:

1. Why does this function stop working? On one machine (WinXP), this happened already, it won't beep. On another computer (WinXP also), it beeped fine until today that I loaded my project and tried it... I put that same project on another computer (Win2k) and it worked fine, so I grabbed its Kernel32.dll, renamed it, and then put it on the second PC I listed, but the program crashes, it returns to VS.NET without any exception message and then it puts the cursot on the "public static extern bool Beep();" line... How can I fix this? I really need this function! Frown | :(

2. I used to code in a Windows scripting language that did all the datatype conversion stuff for you (http://www.autoitscript.com), and when I called the Beep function with decimal parameters, it worked, but when I try floats, doubles, and decimals in C# it doesn't beep!

If anyone can help, I'd be thankful for life! Thanks! Wink | ;)

Darth_Sulfur (Sulfurik)
http://www.SulfurSoft.tk
ftp://tsfc.ath.cx
http://tsfc.ath.cx
hotline://tsfc.ath.cx

Re: Questions about Kernel32.dll's Beep()

Rob Graham15-Jul-05 12:50

Rob Graham

15-Jul-05 12:50

Is the PC speaker enabled? (Bios and Control panel) Does it work?

(Sometimes it really is a hardware problem Smile | :)

)

BTW, copying Kernel32.dll from one OS to another really is a bad idea...

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

Re: Questions about Kernel32.dll's Beep()

Dave Kreskowiak15-Jul-05 17:12

Dave Kreskowiak

15-Jul-05 17:12

I agree with Ron. Either you've got a hardware problem, or someone turned the volumn down on the speakers or in the Sound control panel or the little Volume slider, or muted either.

And yeah, copying Kernel32.dll from another machine is a REALLY bad idea. If you replaced with one in System32, it's amazing your machine even booted!

BTW: Beep takes two parameters: unsigned integers, NOT floats, doubles, decimals, ... floating point numbers will not work. The proper DllImport should look like this:

static extern bool Beep(uint dwFreq, uint dwDuration);

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Questions about Kernel32.dll's Beep()

leppie15-Jul-05 22:11

leppie

15-Jul-05 22:11

I disconnected my PC speaker in case (actually I ripped it out completely) and my PC doesnt beep either.

^{xacc-ide 0.0.15 now with C#, MSIL, C, XML, ASP.NET, Nemerle, MyXaml and HLSL coloring - Screenshots}

Re: Questions about Kernel32.dll's Beep()

Lord Kixdemp16-Jul-05 7:45

Lord Kixdemp

16-Jul-05 7:45

OK, what's the option in Control Panel, and what's the BIOS option usually called? I can't find 'em! Frown | :(

Thanks!

Darth_Sulfur (Sulfurik)
http://www.SulfurSoft.tk
ftp://tsfc.ath.cx
http://tsfc.ath.cx
hotline://tsfc.ath.cx

Re: Questions about Kernel32.dll's Beep()

Rob Graham16-Jul-05 12:29

Rob Graham

16-Jul-05 12:29

On XP:
MyComputer->manage->device manager

select the view menu and check (select) "show hidden devices"

expand the "non-plug and paly devices" node of the tree.

find "beep" and open its properties window. ensure it is enabled. (I hate the thing, mine is disabled)

Different BIOS will have differen places (or sometimes none at all) for this.

also, sttings->control panel -> sounds and audio devices: sounds tab - make sure the sounds scheme is not 'no sounds'. Make sure some sound is associated with 'default beep' On the volume tab, make sure 'mute' is not checked..

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

Re: Questions about Kernel32.dll's Beep()

Anonymous18-Jul-05 14:41

Anonymous

18-Jul-05 14:41

Uhh... "Show hidden devices"? Under View? Hmm... I don't have that! :S I have XP Home with SP2... Is there an alternative? Thanks! Wink | ;)

Inheriting from Constraint ???

Besinci15-Jul-05 10:58

Besinci

15-Jul-05 10:58

Hi there,

Can anyone supply me with code sample on this issue???

...
...

public class Constraint : System.Data.Constraint
{
public Constraint() : base()
{
}
}

When compiling the code I get these error messages:

'DataBase.Constraint' does not implement inherited abstract member 'System.Data.Constraint.CanBeRemovedFromCollection(System.Data.ConstraintCollection, bool)'

'DataBase.Constraint' does not implement inherited abstract member 'System.Data.Constraint.CanEnableConstraint()'

'DataBase.Constraint' does not implement inherited abstract member 'System.Data.Constraint.CheckCanAddToCollection(System.Data.ConstraintCollection)'

'DataBase.Constraint' does not implement inherited abstract member 'System.Data.Constraint.CheckConstraint(System.Data.DataRow, System.Data.DataRowAction)'

'DataBase.Constraint' does not implement inherited abstract member 'System.Data.Constraint.CheckState()'

'DataBase.Constraint' does not implement inherited abstract member 'System.Data.Constraint.Clone(System.Data.DataSet)'

'DataBase.Constraint' does not implement inherited abstract member 'System.Data.Constraint.ContainsColumn(System.Data.DataColumn)'

'DataBase.Constraint' does not implement inherited abstract member 'System.Data.Constraint.IsConstraintViolated()'

'DataBase.Constraint' does not implement inherited abstract member 'System.Data.Constraint.Table.get'

I don't know how to implement these members... pls help Cry | :((

Re: Inheriting from Constraint ???

leppie15-Jul-05 22:13

leppie

15-Jul-05 22:13

Besinci wrote:
I don't know how to implement these members... pls help

Why are you inheriting then? What is your goal with this? I suggest you read MSDN docs for the Constraint class. D'Oh! | :doh:

^{xacc-ide 0.0.15 now with C#, MSIL, C, XML, ASP.NET, Nemerle, MyXaml and HLSL coloring - Screenshots}

Printing to debug window from Web Service

maskeen15-Jul-05 10:41

maskeen

15-Jul-05 10:41

Hi,

How can I print to debug window from a C# Web Service?

Thanks!

My Article Updated

Ahmed Erarslan15-Jul-05 10:21

Ahmed Erarslan

15-Jul-05 10:21

Hello There My Article Updated I soluted Soruce code Problem

Ahmed Erarslan
MCAD,MCDBA,MCP

MCSD.NET

Re: My Article Updated

Judah Gabriel Himango15-Jul-05 10:36

Judah Gabriel Himango

15-Jul-05 10:36

Ahmed, perhaps a link to your article would be helpful, along with a description of your article.

Also, the C# forum is not the best location to post this.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Homosexuality in Christianity
Judah Himango

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