Displaying the database record in to Gridview using conditio

In table record as follows

CourseCode CoruseName Studentid City
RM Remunration 45555 1
REO Revalidation 88787 1
CTF Tanker 98889 1
ECDIS Practical 88877 1
AMOS Manual 78798 1
DFC Familarazation 87899 2

i am displaying the above data in to Gridview. code as follows

string Con= "Server=(local);initial catalog=Testing;Trusted_Connection=True";
SqlConnection sqlcon= new SqlConnection(Con);
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
cmd.CommandText = "select * from Course";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlcon;
sqlcon.Open();
dr= cmd.ExecuteReader();
if (dr.HasRows)
{
if (reader.Read())
{
string City = dr[6].ToString();
if (City== "1") ;
{
Griview.Datasource = dr;
Gridview.databind();
}
}
}

i am checking if City 1 means. that city 1 all record to be displayed in gridview.

When i execute the above code in Gridview Output as follows

CourseCode CoruseName Studentid City

RM Remunration 45555 1

in the above gridview only first record only displayed. But not all the records in table is not displaying.

But i want the output in Gridview as follows

CourseCode CoruseName Studentid City
RM Remunration 45555 1
REO Revalidation 88787 1
CTF Tanker 98889 1
ECDIS Practical 88877 1
AMOS Manual 78798 1

please help me what is the problem in my code

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel10y ago
Or rather than checking the condition in code , ;modify the query to fetch records where city=1, that would even improve little bit of performance of the code.
select*fromCoursewhereCity=1
Please mark it as answer if it resolves the issue.
-1
Manas Mohapatra10y ago
Missing part is, it is not binding all records. So how it will display all records. Use code like below:
GridView.DataSource = cmd.ExcuteReader();
GridView.DataBind();
0