Hello,

           System.Data.OleDb.OleDbCommandBuilder cb = new System.Data.OleDb.OleDbCommandBuilder(dAdapter);
           
            if (current\_list == "list1")
           {
               DataRow row = myset.Tables\["list"\].NewRow();
                   
               int y;
               y = myset.Tables\["list"\].Rows.Count;

               row\["ID"\] = y + 1;
               row\["word"\] = s; // s is user input
               row\["perc"\] = 0.5;
               
                myset.Tables\["list"\].Rows.Add(row);
               
               dAdapter.Update(myset, "list");
              
           } 

I used break points to confirm that the data is updated here, however, for some reason when I check the database another table is updated instead of "list" Where could be the problem? I checked the code several times, but I'm not sure :confused:

[Message Deleted]

Just tried it, groupbbox can't be used among many other controls. Is there something I'm missing?

I have a a windows application which works great written in C#, and I was wondering what are the steps to take to convert it to a mobile device application? Is the process just a copy and paste process? Or is there more to it? It would be helpful if you tell me what the difference between the two? Thanks in advance.

Thank you! It worked :)

No I haven't. I used this.Close() before and it worked fine.

yesb.Click += new System.EventHandler(this.Show());
nob.Click += new System.EventHandler(this.Close());

this is the error I keep getting: An object reference is required for the nonstatic field, method, or property 'System.Windows.Forms.Control.Show()' Same thing for this.Close() as well. I have two buttons, one should reload the application, and the other closes it.

Thank you!!!!:thumbsup: (double)(1/7) I keep adding the parentheses, something so simple could make you go crazy...but I guess that's coding for you..lol Thanks again

I don't get it? :doh: Can you please explain? too much coffee and a lot less sleep :(( --Star

Still result is zero.

MessageBox.Show(Convert.ToString(1/7)); The result is always zero, when it should have been 0.1428571429 Any ideas? --Star

Thanks, it worked!

It says I can't power up a double and a double

double a = 1.8;
double b = 2.9;

a = a ^ b ;

any ideas?

Could you explain?

Runtime error: Syntax Error in FROM clause

There seems to be a problem with my code when I try and retrieve multiple tables. Please tell me what's wrong, or if there is an alternative way to do this? Thanks in advance. OleDbConnection clsConnection; clsConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\one.mdb;"); clsConnection.Open(); //first table WTest1.oneDataSet f_table = new WTest1.oneDataSet(); OleDbDataAdapter dAdapter = new OleDbDataAdapter("SELECT * FROM first", clsConnection); dAdapter.Fill(f_table, "first"); //second table WTest1.oneDataSet s_table = new WTest1.oneDataSet(); OleDbDataAdapter dAdapter1 = new OleDbDataAdapter("SELECT * FROM second", clsConnection); dAdapter1.Fill(s_table, "second");``Runtime Error: Syntax Error in FROM Clause --Star

modified on Wednesday, April 29, 2009 1:04 PM

Okay when I commented my other connections, it worked.

the message doesn't make sense, Syntax error in FROM clause.

I have removed the path because it was so long, but I do have it in my application, lol. As for the double spaces, didn't notice them, thanks, but still even though I removed the double spaces, still same runtime error

OleDbConnection clsConnection;
clsConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\.one.mdb;");
clsConnection.Open();
//first table
WTest1.oneDataSet f_table = new WTest1.oneDataSet();
OleDbDataAdapter dAdapter = new OleDbDataAdapter("select * from first", clsConnection);
dAdapter.Fill(f_table, "first"); // runtime error incorrect FROM syntax
clsConnection.Close();

I've used this code in a previous application and it worked fine, however in this application, it's giving me this error about FROM syntax. Can someone please tell me what's wrong??:confused: Star