Comments by Member 9611735 (Top 37 by date)

I am trying to filter my datagrid using datepickers but it's not matching with any dates stored in dbase. Am I quering my dbase correctly? Should I be using datepicker1.text or something else?

I will take that on board. thank you!

Thank you for replying. Unfortunately it doesn't work. Dates in my database are saved in format 2013-04-11. Would i need to change the format of date field? My datepickers are named datepicker1 and datepicker2.

No, sorry I meant datepicker 1 and datepicker2

Dataset is returned empty eventhough there are values matching date recorded in dbase. Could it be something about conflicting string formats?

the column already exists in table, I just want to extend query and insert value into column

Question has been updated with code

thank you for your help CHill60. I have decided to make a temporary transactions table to help me with my problem.

Thank you very much for getting back to me. Unfortunately I am using WPF datagrid and your code doesn't work.

Thank you!

I will take that on board. Thank you!

I am unsure how to do that. Can you give me some pointers?

i'm trying to bind the button in code. I am writing a if statement where if the user fill in all fields in the form and clicks the button-the page changes. If the user doesn't fill in all the fields a error appears and the page doesn't chage

You are wonderful! thank you, your solution works a treat

XAML code:
combobox grid.column="2" grid.row="2" height="23" horizontalalignment="Left" margin="0,17,0,0" name="comboBox3" verticalalignment="Top" width="120" selectionchanged="comboBox3_SelectionChanged"
comboboxitem name="five">5
comboboxitem name="ten">10
comboboxitem name="fifteen">15
comboboxitem name="twenty">20
comboboxitem name="twentyfive">25
comboboxitem name="thirty">30


Label Grid.Column="5" Grid.Row="1" Height="28" HorizontalAlignment="Left" Margin="0,24,0,0" Name="label1" VerticalAlignment="Top" Width="117" Grid.ColumnSpan="2"

Unfortunately your solution didn't work as it didn't recognise the SelectedItem.Value.ToString() part.

the string value stored in label1 is 9,00. Do you think I am carrying out the calculation in the right way i.e should I be changing the values to decimals?

Still reports the error Input string was not in a correct format. In label1 is the price of the product, in the combobox is the available quantities.

When i just print the above I get system.windows.control.comboboxitem error

question updated

There is definitely something wrong with the query. I played about with the code and by specifying the name of teacher all the textboxes were populated with the correct data from database. Any suggestions?? Thank you so much for your help thus far.

I tried specifying the query by adding a where clause to query and specifying a name. Now when I debug the textbox is populated with System.Data.DataRow

yes name is the column name. Do i need to bind my textbox with the table in xaml or anything? Am i using the correct code to add the result into textbox?

I added in NameBox.Text = DS.Tables[0].Rows[0].ToString(); after your newly posted solution and this error occurred
There is no row at position 0.

Yes there is two records in the database. It's mySQL database. I am getting combobox values from the same table in the database and it's working fine

Yes teacher is the name of the table. My connection string is
string connectionSQL= "server=sql.byethost27.org;user id=xxxxxxx;password=xxxxxxxxxx;database=xxxxxxxxxx";

There is still nothing in dataset

Your solution throws up the following error Error 1 'MySql.Data.MySqlClient.MySqlCommand' is a 'type' but is used like a 'variable'. I've tried changing it to different things but dataset is still empty

I just checked and it's not. Do you think there is something wrong with my query?

Thank you. I changed my code but the textboxes are still not being populated

Question edited!