C# sql How to get specific column's data to datagrid

Question

I want to get specific colums to show on my C# WPF DataGrid.

I used this code to get selected columns:

using (SqlConnection con = new SqlConnection(ConString))
{
    SqlCommand cmd = new SqlCommand("SELECT roll FROM cmt_7th", con);
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable("cmt_7th");
    sda.Fill(dt);
    MydataGrid_roll.ItemsSource = dt.DefaultView;
}

But I want to show only those row which column data is empty .

Like this

Left image is output screen short and right image is sql table image on "Like this" link image

I want to get rows 5 to 10 and ignore 1 to 4 row where all columns are not null.

csharpbd · Accepted Answer · 2017-03-31 13:52:15Z

3

According to your description, you want to get all row where name, department, phone are null. So, you have to apply condition in your sql. Please check this:

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;

}

Check this output of the SQL:

edited Mar 31, 2017 at 13:52

answered Mar 31, 2017 at 13:46

csharpbd

4,1164 gold badges27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

SabbirTT Over a year ago

Thank you so much... Will not I be your friends on facebook?? I am waiting , Facebook

SabbirTT Over a year ago

Hey I need to determine that roll 5 rows is open. But how??

csharpbd Over a year ago

I'm little bit busy, I'll back soon.

csharpbd Over a year ago

@SabbirTT, what do you mean by "I need to determine that roll 5 rows is open."?

csharpbd Over a year ago

If you want to get only roll no 5, then use Top 1 in sql. SQL: SELECT Top 1 roll FROM cmt_7th WHERE name IS Null And department IS Null And phone IS Null.

|

Collectives™ on Stack Overflow

C# sql How to get specific column's data to datagrid

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related