Comments by R. Hoffmann (Top 33 by date)

Thanks for your explanation, I've updated my answer with some hints that may be useful. My C++ is too rusty to do much more :)

I'm happy to have been of service :)

And when I say "the pic table doesn't exist", I mean it doesn't exist in the DataSet. It may exist in your actual database, but as I said, the DataSet doesn't know that, it's simply a "dumb" container for data.

This will be because your DataSet is empty - the part that says "ds.Tables["pic"]" returns a null because the "pic" table doesn't exist, and when you then call ".Rows" on it, it throws an exception.

You must understand that a DataSet is simply a container for data, it isn't capable of getting the data by itself. You need to add code to read data from the database connection you instantiated and put it into the DataSet, between where you create the Dataset and where you try to get the rowcount, for this to work. Your existing code is good, it is just a little incomplete.

Edit: formatted code and added category tags.

Hi,

The pie chart already exists, and I only need to change its formatting (the underlying data stays the same). Currently the pie charts have multiple slices, but all slices have the same colour (normally, when you create a new pie chart in Excel, then the colours are set to "Automatic", and Excel makes each slice a different colour). Basically I'm just looking for a way to get Excel to once again automatically make the slices in the pie charts each have a different colour.

Does that make more sense?

Wow, a descriptive title, decent amount of info in the question, details of what has been tried already, clear questions in the end.. Oh, *and* the question is tagged nicely. Unfortunately I'm not able to help you with your queries, but I just want to say well done on formulating the question! It's so refreshing to come across something like this :)

Cool, glad that's sorted :)

It depends: if you're getting back a string from ExecuteScalar, then you're not going to get it much neater than what you have now. You could get rid of the temp variable, and put cmd_id.ExecuteScalar().ToString() into the Parse call directly, but that's it. You might want to add code to handle DBNulls though, for when there is no last ID to retrieve.

However, have a look at what the type of the return value actually is (under the debugger). Maybe you can still use your original code, but with the correct type (i.e. not int). Maybe it's of type uint or something. E.g. _id = (uint) cmd_id.ExecuteScalar();

Can you provide details on what kind of database you're using? Is it Access?

Don't post additional information as a solution, please. Rather edit the question and add it there.

Thanks!

That comment deserves a 5!

Another thing, this won't fix the problem you're getting but is important nevertheless: your UPDATE statement inserts an additional space at the end of the password you're getting from the textbox, so what is stored in the database is different to what the user entered. This is probably a typo.

string update = "UPDATE Login SET Password = '" + TextBox2.Text + "-->Remove space here<--' WHERE UserId = '" + dtr[0].ToString() + "'";

I just tried the update statement in Management Studio, and it executes fine, although the syntax highlighting does recognize "Login" as a reserved word. However, I used SQL Server 2008 R2, and you are connecting to Access, so that is perhaps why it doesn't work on your side.

Have you tried CS2011's suggestion of enclosing the table name in square brackets? I think Prem Shanker Verma and CS2011 are correct with their diagnosis. Don't know who voted them down.

Looks like the code got truncated. And please edit your original question and add the complete code there instead of pasting it in a comment.

See my reply above :-)

I just created a new empty database in SQL Server 2008, and ran the schema creation scripts that OP provided. Then I ran the stored proc, and it does return the State field.

Wouldn't the fact that the original query contains an asterisk mean that all fields from the joined tables are returned, even if not specifically listed by name?

Isn't it? Doesn't the asterisk in the SELECT include all fields from the State table as well?

<pre>
select Customer.City AS City1,State.City AS City2,Customer.Sr_No as Sr_No1, * from Customer full Join State
</pre>

Thanks!

Ah, very good find!

Thanks :)

Sorry, I'm not familiar with MySQL at all, but this page may be of help: http://php.net/manual/en/function.mysql-query.php.

Seems like they
1. execute the function using mysql_query, which returns a resultset of some sort,
2. call mysql_fetch_assoc on the resultset to obtain the next row from it, which is returned,
3. and lastly, refer to a specific value in the row by using an indexer in the form of the field name to be returned.

Can you post the errors you're getting?

It's certainly possible to have a WHERE clause in the SELECT being used as the adapter's SelectCommand (see http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.aspx, the Examples section).

Perhaps the dates are not in the correct format, and using placeholders and providing your dates as DateTime objects (thereby allowing the system to take care of the format) would solve the issue.

To get the number of pages in a document, try the code in this article: http://www.codeproject.com/KB/cs/mswordcount.aspx. It calls on Word to provide document statistics, specifying that it wants the number of pages.

Thanks!