DaniWeb Forum Index > Software Development > C#

C# RSS

i cant save data on an access database

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Feb 2007

Posts: 3

Reputation: fruce is an unknown quantity at this point

Solved Threads: 0

fruce

Offline

Newbie Poster

i cant save data on an access database

Feb 16th, 2007

Good day, I am learning C# and someone has given me a certain software to write for him. I have been trying to add a new record to the Access Database that has already been connected to the Visual C# Application (Using Visual C# 2005) , using the DataSource and the DataAdapter objects, though i am able to add a new record to the program, it doesn,t save when i click on the save icon on visual C#.
Can anyone give me some hints and directions as how to solve the above mentioned problem, thanks.
Fruce

•

Join Date: Jan 2007

Posts: 47

Reputation: kapil.goyal is an unknown quantity at this point

Solved Threads: 0

kapil.goyal kapil.goyal is offline

Offline

Light Poster

Re: i cant save data on an access database

Feb 16th, 2007

i hav to look into ur code wat exactly it is doing .so post the prob along with the code

•

Join Date: Feb 2007

Posts: 3

Reputation: fruce is an unknown quantity at this point

Solved Threads: 0

fruce

Offline

Newbie Poster

Re: i cant save data on an access database

Feb 16th, 2007

•

Originally Posted by kapil.goyal

i hav to look into ur code wat exactly it is doing .so post the prob along with the code

there is no code. I have a database in microsoft access. i am working on visual C# 2005. i created a new windows application and then add the database from access on the form. when i tried to input some values onto the database and click the save icon, i realised it didnt save after i run the application again. i dont know what to do

•

Join Date: Mar 2007

Posts: 4

Reputation: dustman is an unknown quantity at this point

Solved Threads: 0

dustman

Offline

Newbie Poster

Re: i cant save data on an access database

Sep 28th, 2007

hello....i have the same problem...the button for the Save buttons looks like this:

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
private void button1_Click(object sender, EventArgs e)
        {
            if (name.Text == "" || surname.Text == "" || age.Text == null || entryDate == null)
                MessageBox.Show("Please enter all the data before pressing Add");
            else
            {
                mamaDataSet.PacientRow pr;
                int maxId;
 
                maxId = -1;
                foreach (mamaDataSet.PacientRow r in mamaDataSet.Pacient.Rows)
                {
                    if (r.PacientId > maxId) maxId = r.PacientId;
                }
                maxId = maxId + 1;
 
                pr = (mamaDataSet.PacientRow)mamaDataSet.Pacient.NewRow();
                pr.PacientId = maxId;
                pr.Name = name.Text;
                pr.Surname = surname.Text;
                bool b=false;
                try
                {
                    pr.Age = int.Parse(age.Text);
                }
                catch (Exception es)
                {
                    MessageBox.Show("Invalid age, please insert a number");
                    b = true;
                }
                if (b != true)
                {
                    DateTime startD = entryDate.SelectionStart;
                    pr.EntryDate = startD;
                    mamaDataSet.Pacient.Rows.Add(pr);
                    //daProducts.Update(dsStore1, "Products");
                    MessageBox.Show(maxId.ToString());
                    pacientTableAdapter.Update(mamaDataSet);
                }
            }
        }
private void button1_Click(object sender, EventArgs e)
        {
            if (name.Text == "" || surname.Text == "" || age.Text == null || entryDate == null)
                MessageBox.Show("Please enter all the data before pressing Add");
            else
            {
                mamaDataSet.PacientRow pr;
                int maxId;

                maxId = -1;
                foreach (mamaDataSet.PacientRow r in mamaDataSet.Pacient.Rows)
                {
                    if (r.PacientId > maxId) maxId = r.PacientId;
                }
                maxId = maxId + 1;
                
                pr = (mamaDataSet.PacientRow)mamaDataSet.Pacient.NewRow();
                pr.PacientId = maxId;
                pr.Name = name.Text;
                pr.Surname = surname.Text;
                bool b=false;
                try
                {
                    pr.Age = int.Parse(age.Text);
                }
                catch (Exception es)
                {
                    MessageBox.Show("Invalid age, please insert a number");
                    b = true;
                }
                if (b != true)
                {
                    DateTime startD = entryDate.SelectionStart;
                    pr.EntryDate = startD;
                    mamaDataSet.Pacient.Rows.Add(pr);
                    //daProducts.Update(dsStore1, "Products");
                    MessageBox.Show(maxId.ToString());
                    pacientTableAdapter.Update(mamaDataSet);
                }
            }
        }