c# sql How to get row selected value?

Question

I used datagrid to show sql table datagrid.

And I showed one column on datagrid from sql.

Now I want to determine that which rows is now open & what is that values.

Like this.

And I used this code to show datatable on my datagrid.

string ConString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(ConString))
{

    SqlCommand cmd = new SqlCommand("SELECT roll FROM cmt_7th WHERE name IS Null And department IS Null And phone IS Null", con);
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable("cmt_7th");
    sda.Fill(dt);
    MydataGrid_roll.ItemsSource = dt.DefaultView;

}

And its show only row column. But I want to declare like my previous image.

DGV means?? I want to show rows data like something : messagebox.show(dt.SelectedRow.Value) — SabbirTT, Apr 01 '17 at 12:45
Might want to refer to this. http://stackoverflow.com/questions/7657137/datagridview-full-row-selection-but-get-single-cell-value — Reousa Asteron, Apr 01 '17 at 13:17
Possible duplicate of [Datagridview full row selection but get single cell value](http://stackoverflow.com/questions/7657137/datagridview-full-row-selection-but-get-single-cell-value) — Reousa Asteron, Apr 01 '17 at 13:18
See what's wrong? [See my error](https://i.stack.imgur.com/gzBsP.png) — SabbirTT, Apr 01 '17 at 15:33

score 0 · Answer 1 · answered Apr 01 '17 at 13:26

You can get the selected row value with this code: string em = dataGridView1.CurrentRow.Cells[2].FormattedValue.ToString(); You store the value in a string called em like the above, you can change the name for sure, and then cell[] is like an array, it stores each intersection of a row and a column in there, so for instance if you have 3 columns and two rows, the first intersection of the row and column is of index 0 and so on and so forth.

score 0 · Answer 2 · answered Apr 02 '17 at 18:47

You could select all values that you are interested in up front of but only display the "roll" column in the DataGrid:

string ConString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(ConString))
{

    SqlCommand cmd = new SqlCommand("SELECT roll, tc, tf, pc, pf FROM cmt_7th WHERE name IS Null And department IS Null And phone IS Null", con);
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable("cmt_7th");
    sda.Fill(dt);
    MydataGrid_roll.AutoGenerateColumns = false;
    MydataGrid_roll.Columns.Add(new DataGridTextColumn() { Header = "roll", Binding = new Binding("roll") });
    MydataGrid_roll.ItemsSource = dt.DefaultView;
}

You can then retrive any column values of the selected row in the DataGrid like this:

DataRowView drv = MydataGrid_roll.SelectedItem as DataRowView;
if(drv != null)
{
    int selectedRoll = Convert.ToInt32(drv["roll"]);
    if(drv["tc"] != DBNull.Value)
    {
        string selectedTc = drv["tc"].ToString();
    }
    //...
}

c# sql How to get row selected value?

2 Answers2