[monica hinge]

DataRow rd;
        DataTable MyTable = new DataTable();
        private void button1_Click(object sender, EventArgs e)
        {
           
            rd["Column1"] = textBox1.Text;
            rd["Column2"] = textBox2.Text;
            rd["Column3"] = textBox3.Text;
           // MyTable.Rows.Add(rd);

        }

i tried a lot to add data from text box into datagridview on button click..
i m new to c# and really want help from you...is these is the right one bcoz..its show error..
Thanks You in Advance..

This post has been edited by insertAlias: 24 February 2011 - 08:00 AM

[Vishu Sukhdev]

Hi,
suppose you have DataGridView for example dgv

 private void GridDesign()
        {
            dgv.Columns.Add("srno", "SrNo");
            dgv.Columns.Add("bookingno", "Booking No");
            dgv.Columns.Add("bookingdate", "Booking Date");

            dgv.Columns[0].Width = 50;
            dgv.Columns[1].Width = 100;
            dgv.Columns[2].Width = 100;
           
                    }

call method on Page_Load()

and then write code on button_click()

private void button1_Click(object sender, EventArgs e)
{
 dgv.Rows.Add(textBox1.text,textBox2.text,textBox3.text);

}

[ragingben]

Your code doe's not work for a variety of reasons. You are creating a DataTable instead of referenceing your DataGridView, you never assign rd so it will be null. You are trying to add a DataRow when you should be trying to add a DataGridViewRow, and you have commented out the line where you would actually add the row. This code should work...

// create new row
DataGridViewRow row = new DataGridViewRow();

// create cells
row.CreateCells(this.dataGridView1, textBox1.Text, textBox2.Text, textBox3.Text);

// add to data grid view
this.dataGridView1.Rows.Add(row);

EDIT: Sorry Vishu Sukhdev you beat me to it

[ragingben]

I have modified your code a bit so that it works, heres the full code

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

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        /// <summary>
        /// Get or set the data table
        /// </summary>
        private DataTable myTable = new DataTable();

        public Form1()
        {
            InitializeComponent();

            // initialise
            this.initialiseTable(this.myTable);

            // set source
            this.dataGridView1.DataSource = this.myTable;
        }

        /// <summary>
        /// Initialise a table
        /// </summary>
        /// <param name="table">The table to initialise</param>
        private void initialiseTable(DataTable table)
        {
            // add all columns
            table.Columns.Add(new DataColumn("Column1"));
            table.Columns.Add(new DataColumn("Column2"));
            table.Columns.Add(new DataColumn("Column3"));
        }

        private void button1_Click(object sender, EventArgs e)
        {
            // create a row
            DataRow rd = this.myTable.NewRow();

            // set values
            rd[0] = textBox1.Text;
            rd[1] = textBox2.Text;
            rd[2] = textBox3.Text;
            
            // add row to table 
            this.myTable.Rows.Add(rd);
        }
    }
}

Basically the table should be a property of the form

/// <summary>
/// Get or set the data table
/// </summary>
private DataTable myTable = new DataTable();

You could initialise it at any point, I do in the form constructor, just after the form has been initialised. I also set the source of the DataGridView on the main form to the table...

// initialise
this.initialiseTable(this.myTable);

// set source
this.dataGridView1.DataSource = this.myTable;

And then when you add a row, just create it, set all cells, and add it to the table. The DatagridView on the form will be updated automatically...

// create a row
DataRow rd = this.myTable.NewRow();

// set values
rd[0] = textBox1.Text;
rd[1] = textBox2.Text;
rd[2] = textBox3.Text;

// add row to table 
this.myTable.Rows.Add(rd);

This post has been edited by ragingben: 23 February 2011 - 07:15 AM

[tlhIn`toq]

monica hinge, on 23 February 2011 - 05:24 AM, said:

i tried a lot to add data from text box into datagridview on button click..
i m new to c# and really want help from you...is these is the right one bcoz..its show error..
Thanks You in Advance..

Really? With all the big bold comments about posting your code in code tags you still couldn't be bothered to do it?

Also, dis not b d'hood dawg... You are not here texting your high school posse to come to your kegger after their shift at Taco Bell. You are here asking for help from senior coding professionals who graciously donate their valuable time to helping the next generation of coders with their chosen craft. Please try to show them, yourself and the industry some respect by writing at least at an eighth grade level. (IE: English not ebonics or SMS, real words, punctuation and so on)

If you can't take your own problem/question seriously enough to write like an adult, then why would you expect anyone else to take it seriously?

[monica hinge]

Thanks for your help!!!! Currently i m working a lot on datagrid view ..and want my datagridview work on enter and not on Tab control..like gridview should work Like Excel..On enter curser should move to next cell..
In gridview i hv combobox ..as i select item from combo box other cell should be fill autometically with some data..but it is possible only by tab event and not enetr event..
i want my gridview work on enter...
the code is something like this..

 private void dataGridView1_CellLeave(object sender, DataGridViewCellEventArgs e)
        {
            
            try
            {
                for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                {
                   

                    if (dataGridView1.Rows[i].Cells[3].Value != null && dataGridView1.Rows[i].Cells[5].Value != null)
                    {
                        double a;
                        a = Convert.ToDouble(dataGridView1.Rows[i].Cells[3].Value) * Convert.ToDouble(dataGridView1.Rows[i].Cells[5].Value);
                        dataGridView1.Rows[i].Cells[6].Value = a.ToString();
                    }

                    if (dataGridView1.Rows[i].Cells[0].Value != null)
                    {
                        string abc = dataGridView1.Rows[i].Cells[0].Value.ToString();
                        string ab = "select ID,ItemName,Brand,Unit from Item where ID ='" + abc + "'";
                        da8 = new OleDbDataAdapter(ab, con);
                        dtb1 = new DataTable();
                        da8.Fill(dtb1);

                        for (int j = 0; j < dtb1.Rows.Count; j++)
                        {
                            //MessageBox.Show("" + dt.Rows.Count);
                            if (dtb1.Rows[j]["ID"].ToString() == abc)
                            {
                                dataGridView1.Rows[i].Cells[1].Value = dtb1.Rows[j]["ItemName"].ToString();
                                dataGridView1.Rows[i].Cells[2].Value = dtb1.Rows[j]["Brand"].ToString();
                                dataGridView1.Rows[i].Cells[4].Value = dtb1.Rows[j]["Unit"].ToString();
                                // dataGridView1.Rows[i].Cells[0].Value = dtb.Rows[j]["ItemName"].ToString();
                            }
                        }
                       
                    }
  //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
                    if (dataGridView1.Rows[i].Cells[1].Value != null)
                    {
                        string abc = dataGridView1.Rows[i].Cells[1].Value.ToString();
                        string ab = "select ID,ItemName,Brand,Unit from Item where ItemName ='" + abc + "'";
                        da8 = new OleDbDataAdapter(ab, con);
                        dtb1 = new DataTable();
                        da8.Fill(dtb1);

                        for (int j = 0; j < dtb1.Rows.Count; j++)
                        {
                            //MessageBox.Show("" + dt.Rows.Count);
                            if (dtb1.Rows[j]["ItemName"].ToString() == abc)
                            {

                                dataGridView1.Rows[i].Cells[0].Value = dtb1.Rows[j]["ID"].ToString();
                                dataGridView1.Rows[i].Cells[2].Value = dtb1.Rows[j]["Brand"].ToString();
                                dataGridView1.Rows[i].Cells[4].Value = dtb1.Rows[j]["Unit"].ToString();


                            }

                        }
                    }
                  

                }
                dataGridView1.SelectedCells[3].DataGridView.EditingControl.Focus();
            }
            catch (Exception)
            {

            }
                
        }

there is the screen snap shot of my form.
thanks in advance

This post has been edited by insertAlias: 02 March 2011 - 09:34 AM

[tlhIn`toq]

Monica: Had you considered that when you so flagrantly disregard the guidelines of this site by absolutely refusing to do something as simple as wrapping your code in code tags that you are really just thumbing your nose at the very people you are asking for help from?

If you can't invest an extra 3 seconds to use the code tags then why should people here invest considerably more time in your problem?