C#

private void DataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
    {
    DataGridView dgv = sender as DataGridView;
    if (dgv != null)
        {
        Rectangle rect = dgv.GetRowDisplayRectangle(e.RowIndex, false);

        int leftRow = dgv.Columns["Col_B"].Index;
        int rightRow = dgv.Columns["Col_D"].Index;
        int leftX = dgv.GetCellDisplayRectangle(leftRow, e.RowIndex, true).X;
        int rightX = dgv.GetCellDisplayRectangle(rightRow, e.RowIndex, true).X
                      + dgv.GetCellDisplayRectangle(rightRow, e.RowIndex, true).Width;

        e.Graphics.DrawLine(Pens.Red, new Point(leftX, rect.Top), new Point(leftX, rect.Bottom));
        e.Graphics.DrawLine(Pens.Red, new Point(rightX, rect.Top), new Point(rightX, rect.Bottom));
        }
    }

Thanks for your reply. But i have not so much knowledge in c#. If you give some coding help then it's very helpful for me

Thanks for your reply. But i have not so much knowledge in c#. If you give some coding help then it's very helpful for me

string stringconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + tbxSelect.Text + ";Extended Properties=\"Excel 8.0;HDR=Yes;\";";
            OleDbConnection conn = new OleDbConnection(stringconn);
            if (tbxSelect.Text != "")
            {
                OleDbDataAdapter da = new OleDbDataAdapter("Select * from [" + tbxChoice.Text + "$]", conn);
                DataTable dt = new DataTable();
                //DataSet dt = new DataSet();
                dt.Clear();
                da.Fill(dt);
                //dataGridView1.DataSource = dt;

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string firstRow = dt.Rows[i]["A"].ToString();
                    if (firstRow != "")
                    {
                        cmbRow1.Items.Add(firstRow);

                        if (!firstRow.Equals(Row1))
                        {
                            //essageBox.Show(firstRow);
                            RowIndex_1++;
                            //Menu{ firstRow, RowIndex_1 };
                        }
                        Row1 = firstRow;
                    }
                    MessageBox.Show(i.ToString(),RowIndex_1.ToString());
                }


                for (int j = 0; j < dt.Rows.Count; j++)
                {
                    string secondRow = dt.Rows[j]["B"].ToString();

                    if (secondRow != "")
                    {
                        cmbRow2.Items.Add(secondRow);
                        if (!secondRow.Equals(Row2))
                        {
                            //essageBox.Show(firstRow);
                            RowIndex_2++;

                            //Menu{ firstRow, RowIndex_1 };
                        }
                        Row2 = secondRow;
                    }
                    MessageBox.Show(j.ToString(), RowIndex_2.ToString());
                }

                for (int k = 0; k < dt.Rows.Count; k++)
                {
                    string secondRow = dt.Rows[k]["C"].ToString();

                    if (secondRow != "")
                        cmbRow3.Items.Add(secondRow);
                }

                for (int l = 0; l < dt.Rows.Count; l++)
                {
                    string secondRow = dt.Rows[l]["D"].ToString();

                    if (secondRow != "")
                        cmbRow4.Items.Add(secondRow);
                }

                for (int m = 0; m < dt.Rows.Count; m++)
                {
                    string secondRow = dt.Rows[m]["E"].ToString();

                    if (secondRow != "") ;
                        //cmbRow5.Items.Add(secondRow);
                }

                MessageBox.Show((dt.Rows.Count).ToString());
                conn.Close();
            }
            else
                MessageBox.Show("Er");

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

SELECT * FROM MyTable WHERE StreetAddress = 'x';

DROP TABLE MyTable;

--'

for (int i = 0; i < dt.Rows.Count; i++)
{
    DataRow row = dt.Rows[i];

    Console.Write($"row: {i}\t");

    for (int j = 0; j < dt.Columns.Count; j++)
    {
        Console.Write($"{row[j]}\t");
    }

    Console.WriteLine();
}

Data comes with this format. what is a good way to rearrange it

for (int i = 0; i < dt.Rows.Count; i++)
{
    DataRow row = dt.Rows[i];
    
    Console.Write($"row: {i}\t");
    
    for (int j = 0; j < dt.Columns.Count; j++)
    {
        var cvalue = row[j];
        string cstr = cvalue is DBNull ? "DBNull" : row[j].ToString();
        Console.Write($"{cstr}\t");
    }
    
    Console.WriteLine();
}

public class MyMenuItem
{
    public MyMenuItem       Parent   { get; set; }
    public string           Header   { get; set; }
    public List<MyMenuItem> Children { get; set; }

    public MyMenuItem(string header, MyMenuItem parent=null)
    {
        this.Parent   = parent;
        this.Header   = header;
        this.Children = new List<MyMenuItem>();
    }
}

List<MyMenuItem> MenuItems = new List<MyMenuITem>();

#realJSOP wrote:

I'm not sure why you're