|
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
|
|
|
|
|
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;
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";
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;
cnSurvey.Open();
total = int.Parse(cmdTotal.ExecuteScalar().ToString());
Ans1 = int.Parse(cmdAns1.ExecuteScalar().ToString());
Ans2 = int.Parse(cmdAns2.ExecuteScalar().ToString());
Ans3 = int.Parse(cmdAns3.ExecuteScalar().ToString());
cnSurvey.Close();
}
The data is table like:
username | survey1 | survey2 | survey3
-----------------------------------------------
sea# | 1 | 3 | 2
These are answers of a user to a survey. I need to collect all results from all users +total, so I can calculate statistics on it etc.
TIA,
sea#
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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!
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!
Darth_Sulfur (Sulfurik)
http://www.SulfurSoft.tk
ftp://tsfc.ath.cx
http://tsfc.ath.cx
hotline://tsfc.ath.cx
|
|
|
|
|
Is the PC speaker enabled? (Bios and Control panel) Does it work?
(Sometimes it really is a hardware problem )
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
|
|
|
|
|
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
|
|
|
|
|
|
OK, what's the option in Control Panel, and what's the BIOS option usually called? I can't find 'em!
Thanks!
Darth_Sulfur (Sulfurik)
http://www.SulfurSoft.tk
ftp://tsfc.ath.cx
http://tsfc.ath.cx
hotline://tsfc.ath.cx
|
|
|
|
|
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
|
|
|
|
|
Uhh... "Show hidden devices"? Under View? Hmm... I don't have that! :S I have XP Home with SP2... Is there an alternative? Thanks!
|
|
|
|
|
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
|
|
|
|
|
|
Hi,
How can I print to debug window from a C# Web Service?
Thanks!
|
|
|
|
|
Hello There My Article Updated I soluted Soruce code Problem
Ahmed Erarslan
MCAD,MCDBA,MCP
MCSD.NET
|
|
|
|
|
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
|
|
|
|
|
You call that updated? You still aren't explaining anything your code is doing or why. It's still just a bunch of barely related code snippets, nothing more.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
Guys, Gals
I can't find any info on how to search a treeView, basically I'm dreaming big and would like to find a way that as a user types in the textbox the search method scrolls thru the treeView to find the matching string of text... ie like you see in a windows help search.
any ideas,
|
|
|
|
|
Use a recursive function or a while loop to search through all the nodes in a treeview. When you find a matching TreeNode, call EnsureVisible() or some other function to make the treeview scroll down to it.
FindMatchingNode("http://judahgabriel.blogspot.com", this.treeView1.Nodes);
void FindMatchingNode(string text, TreeNodeCollection nodes)
{
foreach(TreeNode node in nodes)
{
if(node.Text.IndexOf(text) != -1)
{
node.EnsureVisible();
break;
}
else FindMatchingNode(text, node.Nodes);
}
}
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Homosexuality in Christianity
Judah Himango
|
|
|
|