using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'tBCalDataSet.stations' table. You can move, or remove it, as needed.
            this.stationsTableAdapter.Fill(this.tBCalDataSet.stations);

        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.stationsTableAdapter.Update(this.tBCalDataSet.stations);
        }
    }
}

//try this





try



{



stationsTableAdapter.Update(tBCalDataSet);

MessageBox.show("Updation Successful");





}





//If your code comesunder catch block, check again your connection status, and validate the data which you are passing via controls to your database.



catch (SqlException ex)



{



MessageBox.Show("Updation failed", ex.Message);



}

//this is an example, try to do like this.  





cn.Open();
            SqlDataAdapter da;
            SqlCommandBuilder cmdbuilder;
         
         SqlCommand command = new SqlCommand("select * from icup where ID=@id", cn);
         command.Parameters.Add("@id", SqlDbType.Int);
         command.Parameters["@id"].Value = textBox1.Text;
         da = new SqlDataAdapter(command);
         cmdbuilder= new SqlCommandBuilder(da);
         da.Fill(n99PROJECTSDataSet, "N99");

            n99PROJECTSDataSet.Tables["N99"].Rows[0]["ID"] = textBox1.Text;
            n99PROJECTSDataSet.Tables["N99"].Rows[0]["Name"] = textBox2.Text;
            n99PROJECTSDataSet.Tables["N99"].Rows[0]["Age"] = numericUpDown1.Value;
            n99PROJECTSDataSet.Tables["N99"].Rows[0]["Gender"] = comboBox1.SelectedItem;
            n99PROJECTSDataSet.Tables["N99"].Rows[0]["Address"] = textBox3.Text;
            n99PROJECTSDataSet.Tables["N99"].Rows[0]["Country"] = textBox5.Text;
            n99PROJECTSDataSet.Tables["N99"].Rows[0]["EmailID"] = textBox4.Text;
            try
            {
                icupTableAdapter.Update(n99PROJECTSDataSet);
            }
            catch (SqlException pnn)
            {
                MessageBox.Show("Could not open connection, Please try Again or Check Database connectivity", pnn.Message);
            }
           

           // textBox1.Text = System.Convert.ToString(dr[0]);
            da.Update(n99PROJECTSDataSet,"N99");
            MessageBox.Show("Updation complete");
        }