Hi there
I have created a dataset which only has one table and made 6 dataadapters out of it.
Now I am adding data to the table in my database through a different form.
In a report kind of form I am using the dataset and data adapters.
I have connected one data adapter to the combo box for dates,the second one for party name and the third is connected to the text box for rates, So the idea is when I choose a date from the first combo box the parties on that particular date is going to come in the second combo box and when i select the party in the secnd combo box the rates of that parties is going to be displayed.
All the things are happening but the problem looks like that the rates data is struck somewhere and it is only showing me the rates which i have entered first.
for eg. on 1/1/2008 i have entered 900 for xyz and on 2/1/2008 i have entered 990 for xyz but the text box is showing 900 even when the date selected is 2/1/2008 and the party is xyz. the data is there in the database.
I am using mysql as a database
I have created a dataset which only has one table and made 6 dataadapters out of it.
Now I am adding data to the table in my database through a different form.
In a report kind of form I am using the dataset and data adapters.
I have connected one data adapter to the combo box for dates,the second one for party name and the third is connected to the text box for rates, So the idea is when I choose a date from the first combo box the parties on that particular date is going to come in the second combo box and when i select the party in the secnd combo box the rates of that parties is going to be displayed.
All the things are happening but the problem looks like that the rates data is struck somewhere and it is only showing me the rates which i have entered first.
for eg. on 1/1/2008 i have entered 900 for xyz and on 2/1/2008 i have entered 990 for xyz but the text box is showing 900 even when the date selected is 2/1/2008 and the party is xyz. the data is there in the database.
I am using mysql as a database