|
bprada wrote:
C# code invariably boinks on a sytax error in the INSERT INTO command.
Well, you show us the list of words, but not the INSERT command.
But it should look like this:
OleDbCommand cmd = new OleDbCommand("INSERT INTO Table3Letters VALUES (?);", conn);
cmd.Parameters.Add("@param1", strMy3LetterWord);
cmd.ExecuteNonQuery();</code>Good luck!
Check the syntax of the INSERT statement here[^].
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Thanks for the quick response.
Here is a snippet:
I've read the text word and am trying to put a one Char string in each field.
switch (nCharCount)
{
case 3:
cmd.CommandText = "INSERT INTO 3 VALUES ca[0], ca[1], ca[2]";
cmd.ExecuteNonQuery();
break;
case 4:
cmd.CommandText = "INSERT INTO 4 VALUES ca[0], ca[1], ca[2], ca[3]";
cmd.ExecuteNonQuery();
break;
case 5:
cmd.CommandText = "INSERT INTO 5 VALUES ca[0], ca[1], ca[2], ca[3], ca[4]";
cmd.ExecuteNonQuery();
break;
case 6: /* The first word in Nouns.txt has 6 letter so I am trying different thinggs here */
try
{
OleDbDataAdapter myAdapter = new OleDbDataAdapter();
DataSet ds = new DataSet("six");
myAdapter.Update(ds, "C:\\Keep\\Gloss\\Working Data\\Gloss.mdb.6");
cmd.CommandText = "INSERT INTO '6' (1, 2, 3, 4, 5, 6) VALUES ('cA[0].String()', cA[1].ToString(), cA[2].ToString(), cA[3].ToString(), cA[4].ToString(), cA[5].ToString()";
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
break;
I hope this shows what I am doing wrong
Best Regards,
Bill Prada
|
|
|
|
|
From that code, I suppose your tables have one field for each character (so, the 3-char-words table has 3 fields).
Your INSERT commands, in cases 3, 4 and 5, are missing parenthesis:
INSERT INTO Table VALUES <big><big><big><big>(</big></big></big></big>field1, field2, ...<big><big><big><big>)</big></big></big></big>; -- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
bprada wrote:
cmd.CommandText = "INSERT INTO 3 VALUES ca[0], ca[1], ca[2]";
And also, the ca[n] are variables, so you should put them out of the string literal, and since their data type is char, enclose them in single quotes in the SQL statement:
cmd.CommandText = "INSERT INTO 3 VALUES ('" + ca[0] + "','" + ca[1] + "','" + ca[2] + "')";But I don't recommend string concatenation as it is any easy way to allow SQL-injecton attacks. So I'd use the Parameters property of the OleDbCommand as I mentioned in my first post:
OleDbCommand cmd = new OleDbCommand("INSERT INTO 3 VALUES (?, ?, ?);", conn);
cmd.Parameters.Add("@param1", ca[0]);
cmd.Parameters.Add("@param1", ca[1]);
cmd.Parameters.Add("@param1", ca[2]);
cmd.ExecuteNonQuery();And by the way, in your case 6, you also need to change your SQL statement so you take your variables our of the string literal (or better yet, use parametized queries.)
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
hi,
basically I am a VB/ASP developer, and I am poor in OOP's concepts. I just started learning C#, and when I am trying to execute my first C# program which i got in one book, after execution it is not returning any line to out put screen. plz help me in this.
CODE:
<br />
using System;<br />
<br />
namespace Wrox.ProCSharp.Basics<br />
{<br />
class MyFirstCSharpClass<br />
{<br />
static void Main()<br />
{<br />
Console.WriteLine("This isn't at all like Java!");<br />
Console.ReadLine();<br />
return;<br />
}<br />
}<br />
}<br />
nagarajuepuri
|
|
|
|
|
Check if you created a console application or a windows application. On project properties, check "Output Type", and set it to "Console Application".
If you set it to "Windows Application", it will have no console and all your Console.WriteLine will be ignored.
Yes, even I am blogging now!
|
|
|
|
|
Thanks for you intrest...
actually, i didn't get you exactly.
I have written this code in a text file and saved it with .CS extension, then i have executed this "sample.cs" file through command line like....
"csc sample.cs"
Here i am not at all creating any application nor project, i am executing all my code through command line only.
thanking you in advance,
nagarajuepuri
|
|
|
|
|
You've only compiled the program, you need to execute it. By default, the executable is placed in the same directory where you compiled it and is named after the source file you compiled. So go to the directory where you compiled and run sample.exe .You'll see the output.
Regards
Senthil
|
|
|
|
|
hi ...
first of all u should add the path of the .Net framework to ur system variables (environment variables -> PATH).
to create an exe file u should ask for this in the command u r using to compile the code sample ... to know the exact syntax of all options u can use with CSC , write "csc /?" (of coursr without the double qoutes).
i hope this helps.
|
|
|
|
|
Thanks you all, I got the solution, once again thanks to you all.
.exe file is created when i compiled the code, then when i executed that, i got the desired output of the program.
but let me clear one thing, can't we get that output at the time of compilation it self???
thanks once again
|
|
|
|
|
Only if you write a batch file to do the compile first, then execute the program. The command line compiler will not launch the finished .EXE for you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Does anyone know how to hide the icon on a windows form?
i have an MDI app and when i call a child form, an icon is displayed in the top left of the child. i dont want this for my child forms because it throws off the main Parent forms toolbar.
any help would be appreciated.
thanks,
.gonad.
|
|
|
|
|
you can change the type of the frame of ur forms to fixedDialog.
i hope this helps
|
|
|
|
|
thanks for the reply but it still shows on the form. when the child form is maximized inside the parent, the icon for the child form shows in the top left of the parent form (directly to the left of the 'file' menu). its the 'control' icon (restore,move,size,min,max,close). there is no way to remove this icon from what ive seen or tried.
thanks,
.gonad
|
|
|
|
|
I am trying to create a card selection screen like the one in Windows Solitaire program in C#. I know how to use the cards.dll and can make the card back draw on the screen but what I am trying to figure out is how to:
1) Make them Clickable objects
2) Make it so that when one is clicked, it is highlighed with a border to indicate it is the one selected.
If anyone can help, it would be appreciated.
Thanks.
|
|
|
|
|
Ok, I know there is File.Exists and there are ways to pull out comments from the FileInfo but is there a way in C# .NET to find out if a certain file is signed with a security certificate or not?
|
|
|
|
|
fast way to find the index of the first letter in a richTextBox?
|
|
|
|
|
A regular expression.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
How???(Do you know?) I need the position of the letter
|
|
|
|
|
Yes, you need the position of the letter, we understood this in your first posting.
But unless you're telling us exactly what you want we'll have to guess what you mean.
If you want the location of the first character in a RichTextBox on your screen your should use RichTextBox.GetPositionFromCharIndex().
mav
|
|
|
|
|
mav.northwind, I'm sorry.
My English is not good. I mean the index is what I want.
|
|
|
|
|
Hello,
I have a ToolBar in my MDI child form. My toolbar buttons are set to display text to the right of the image.
My problem is that all the buttons are sized equal, and I wish each to have a different size, depending on the length of the text. The button size is 22 x 22, which is about enough for a 16 x 16 image with no text. One would think about the AutoSize property, but it relates to the toolbar and not the buttons.
Any ideas? Thanks!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Create your own derived toolbar item class ( I forget the class name ) and then you can set the item size to be whatever you want.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
ToolBarButton.
I was looking at the ToolBarButton docs, and I didn't find any property, public or protected that I could override. Any pointers?
Thanks,
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
In a very large richTextBox I want to find all letters.
Is there something faster than :
char[] letters={ 'a','b','c','d','e','f','g','h','i', 'j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S',<br />
'T','U','V','W','X','Y','Z'} ;<br />
richTextBox1.Text.IndexOfAny(letters, i);
OR
richTextBox1.Text[i].IsLetter;
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
