PLZ HELP NEEDED ON DATAGRIDVIEW

I don't know about the deployment issue. Create a new thread with a relevant subject and then someone else can help.

it works thanks man... I av another question regarding deployment. I deployed it using click once and there is a default clickonce page that comes and not my form directly is there a way to directly get my form wen I enter the deployed address.

If the DataGridView is bound to the prodspec table then there should not be a problem updating the table so if there is a problem I don't know what that problem is.

If the DataGridView is bound to the prodspec table then you can use the BindingSource.Filter Property of the DataGridView's BindingSource to filter the data shown in the DataGridView so that only the selected product is shown.

fine i ll make it clear for you, there is a table prodspec not empdetail....
i have a combo box that list out all the prodcode and it is connected to the database.
I use this combo box to generate a gridview, So when i choose a prodcode I get a gridview of that particular prodcode with all the properties of the prodcode(just one row of data).

This is done with a help of select statement and it works perfectly and then if the user modifies the properties or the row generated in the gridview and then on pressing the update button, I want it to update, but it ain't happenin..

I hope I am clear now

Thank you

The original question in this thread says that you have a DataGridView for the EmpDetails table. I don't see any mention of any other data except for the EmpDetails table and I don't see any mention of what else is in the form.

So what I am saying is that it is not clear what the data is that you need to show and update and how the form works. You say you have a ComboBox with prodcode but I don't know how it is related to the EmpDetails table. I think we need more information about the data and what you are using to view and update it.

this is my code

      try
            {


               
                string connStr = @"Data Source=MPMSQLDEV;Initial Catalog=prodcn;Integrated Security=True";
                SqlConnection conn = new SqlConnection(connStr);
                conn.Open();
                SqlDataAdapter dAd = null;
                DataSet dSet = new DataSet();
             string strSql = "Select * FROM prodspec where prodcode='" + prodcode.Text + "'";
                dAd = new SqlDataAdapter(strSql, conn);
                dAd.Fill(dSet, "prodspec");
                prodspecDataGridView.DataSource = dSet.Tables[0];
                prodspecDataGridView.DataSource = dSet.Tables["prodspec"].DefaultView;
                prodspecDataGridView.Visible = true;
                button4.Visible = true;

           }

            catch (Exception ee)
            {
                MessageBox.Show("no entry");
}

        }

        private void closegrid_Click(object sender, EventArgs e)
        {
            prodspecDataGridView.Visible = false;
            button4.Visible = false;
        }

       
        private void modify_Click_1(object sender, EventArgs e)
        {
            DataSet dSet = new DataSet();
            SqlDataAdapter dAd = new SqlDataAdapter();
           
            dAd.Update(dSet, "prodspec");
            dSet.Tables["prodspec"].AcceptChanges();
          //  DataGridViewRow item = new DataGridViewRow();
           // prodspecDataGridView.AllowUserToAddRows = true;
            //item.CreateCells(prodspecDataGridView);          (I tried with these comment lines also but it is not working)



My prob is with your method I am able to update the database but wen I chose a single prodcode from the combo box in the form, the gridview populates with a single row of that of the prodcode. but when I try updating by either the save button in toolbar or the modify button that i have coded it does not updates the database and shows an exception in the latter case Update unable to find TableMapping['prodspec'] or DataTable 'prodspec'.

plz help me on how to select a single row from a combo box in the form or from the datagridview so that i get the corresponding values of the product and I can update the gridview and the database...

hope I am clear, vry urgent

Adi

! more request.. I put a combo box for selection.. I need the other rows to pop up automatically on selecting the value... I dono hw to code this without SQL statement... and tehn save the changes... is it possible??

glorious.. my select statement selects only one prod detail according to the combo box in the form... hw to do that in the datagridview .. the update is absolutely awesome...


thank you so much

I suggest that you not use the other code. You do not need it; the code that gets generated when you do as described in my article will do everything that the other code does, plus more. I suggest that you just create a new project as described in my article except using your table and then proceed from there.

What is the select button supposed to do?

 

namespace UpdateDataWindowsFormDataGridView

{

    public partial class Form1 : Form

    {

        private SqlDataAdapter da;

        private DataTable dt;

 

        public Form1()

        {

            InitializeComponent();

 

            // Configure display characteristics of the data grid view

            dataGridView.Anchor = AnchorStyles.Left | AnchorStyles.Right |

                AnchorStyles.Top | AnchorStyles.Bottom;

            this.Width = 500;

 

            this.Load += new EventHandler(Form1_Load);

        }

 

        void Form1_Load(object sender, EventArgs e)

        {

            // Set the data source of the data grid view

            dataGridView.DataSource = LoadData();

        }

 

        private DataTable LoadData()

        {

            string sqlConnectString = @"my connetion";

 

            string sqlSelect = "SELECT Id, IntField, StringField FROM DataGridView";

 

            // Create a data adapter and command builder

            da = new SqlDataAdapter(sqlSelect, sqlConnectString);

            SqlCommandBuilder cb = new SqlCommandBuilder(da);

            // Load a DataTable with schema and data from table DataGridView

            dt = new DataTable();

            da.FillSchema(dt, SchemaType.Source);

            da.Fill(dt);

 

            return dt;

        }

 

        private void saveButton_Click(object sender, EventArgs e)

        {

           

            da.Update(dt);

            MessageBox.Show("Changes saved.", "DataGridView",

                MessageBoxButtons.OK, MessageBoxIcon.Information);

        }

    }

}

 

 

This is not my code but I just did exactly like this but on a extra note I have added a button which selects the value in the gridview…nw I want a button for just updating the gridview… wen I use this code the database remains unchanged(nothing happens)…. For the second button I have added the SQL dataadaptor and datatable publically hw t is in the prog but with a different object instance(name)..

 

This code is workin if I create a dummy form with just one gridview and a button, but not wen 2 buttons (one for select and 1 for update ).. is there any other way to do this..