i need code for get selected column value from datagridview into array list //foreach (DataGridViewRow row in this.dataGridView1.Rows) //{ // if ((((bool)(row.Cells[this.invoiceNO.Index].Value)) == true)) // { // a.Add(row.Cells[this.invoiceNO.Index].Value); // } //}

i get my issue.... i need to get the value from DataGridView that was selected into array. can you write to me example code.

many thanks for your advice and your time.

no i'm not clinically insane.... but we are in a community to help each author.and i'm stacked.

did you have a time to take a look via teamviewr

this is debugger error(Specified cast is not valid.)

Specified cast is not valid.

private void exprtbtn_Click(object sender, EventArgs e)
{
try
{
if ((this.dataGridView1.Rows.Count == 0))
{
MessageBox.Show("Please select Vouchers");
}
else
{
// HEaders Vouchers
SqlConnection con = null;
SqlConnection con2 = null;
connClass cs = new connClass();
con = new SqlConnection(cs.distiConn1);
con2 = new SqlConnection(cs.sourceConn2);

                ArrayList a = new ArrayList();
                DataTable DT = new DataTable();
                SqlCommand cmd = new SqlCommand();
                SqlTransaction trans = default(SqlTransaction);

                con.Open();
                trans = con.BeginTransaction();
                cmd.Connection = con;
                cmd.Transaction = trans;

                SqlCommand cmdLive = new SqlCommand();
                cmdLive.Connection = con2;
                SqlDataAdapter DR = default(SqlDataAdapter);

                //foreach (DataGridViewRow row in dataGridView1.Rows)
                //{
                //    if ((bool) row.Cells\[this.invoiceNO.Index\].Value == true)
                    
                //    {
                //        a.Add(row.Cells\[this.invoiceNO.Index\].Value);
                //    }
                //}
                //foreach (DataGridViewRow row in this.dataGridView1.Rows)
                //{
                //    if ((bool)row.Cells\[this.invoiceNO.Index\].Value == true)
                //    {
                //        a.Add(row.Cells\[this.invoiceNO.Index\].Value);

                //    }
                //} error in the anderline code
                foreach (DataGridViewRow row in this.dataGridView1.Rows)
                {
                    if ((((bool)(row.Cells\[this.invoiceNO.Index\].Value)) == true))
                    {
                        a.Add(row.Cells\[this.invoiceNO.Index\].Value);
                    }

                }
                int C = a.Count;
                string str = "(";
                int i = 0;
                while (i < C - 1)
                {
                    str += "'" + a\[i\] + "',";

yes i'm its int

foreach (int VouType in DR)

public void FillCompVouType()
{
try
{
this.Cursor = Cursors.WaitCursor;
con = new SqlConnection(cs.sourceConn1);
con.Open();
scmd = new SqlCommand("Select Distinct VouType From Table_name Where Colum=1 order by VouType", con);
SqlDataReader DR = default(SqlDataReader);

            vochcombox.Items.Clear();
            DR = scmd.ExecuteReader();
            foreach (int VouType in DR)
            {
                vochcombox.Items.Add(VouType);
            }
            while (DR.Read())
            {
                this.vochcombox.Items.Add(DR.GetOrdinal("VouType"));
            }
            DR.Close();
            con.Close();
            this.Cursor = Cursors.Default;

        }
        catch (Exception ex)
        {
            this.Cursor = Cursors.Default;
            MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
        }
    }

it's work......... manythanks

many thanks...but i get another error (Operator '==' cannot be applied to operands of type 'object' and 'bool')

foreach (DataGridViewRow row in this.dataGridView1.Rows)
{
if (row.Cells(this.invoiceNO.Index).Value == true)
{
a.Add(row.Cells(this.invoiceNO.Index).Value);
}
}