It wont work

[hime]

hello all

I am using .Net C# & MySql i made a data entry form to fill the tables and it's working ok. my data entry form consists of textboxes through each one I will save the data to the tables. the problem began when I tried to display the info. in my tables using the textbox, I want to be able not just to enter data but also walk through my table using a next and prev. buttons . here is my code

 
private void next_Click(object sender, System.EventArgs e)
        {
            i+=1;
 
            if (i <= ds.Tables[0].Rows.Count)
            {
 
    empid.Text = ds.Tables[0].Rows[i][0].ToString();        empnam.Text = ds.Tables[0].Rows[i][1].ToString();
    empdesc.Text = ds.Tables[0].Rows[i][2].ToString();
i+=1;
}
 
 

the table contains 10 records but the button only work for one click

thank you all for your concern

[kenobewan]

Basically you need to refill the dataset from the data adapter each time that you use it...

Hope that this helps.

[kenobewan]

Actually first port of call is the variable i, the function will not increment the way it does in a loop as the value is not returned... Try declaring it as a global variable and returning it.

Hope that this helps.

[seshu]

hi this is seshu actually i never tried your doubt in c# but i can say u what i da in vb first i fille the dataset using this code
in form class
dim bm as bindingmanagerbase

in form_load
dim da as odbc.odbcdataadapter
dim ds as dataset
da.fill(ds,"tablename")
textbox1.databind=ds(table(0).field(0))
bm=me.bindingcontext(ds,"tablename")
bm.position=0
in button_click (this button is next button)
bm.position+=1
end sub

[seshu]

if the above code does not work and if you say that i dont mine using wizzard i can give you that even

[hime]

First of all thank u for ur reply,
but I tried to use the suggestions you gave me but it didn't work I will keep trying and actually I don't mined using any thing that will work, but I am not sure if wizard works with mysql and also I feel like many things doesn't work smoothly with mysql or more likely its me

thanks