Hi
Please try this
protected void button2_Click(object sender, EventArgs e)
{
SqlDataReader sqlDataReader = GetData(query, conString);
}
And 'GetData' method is as below
public SqlDataReader GetData(string queryString, string connectionString)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
SqlDataReader reader = command.ExecuteReader();
SqlDataReader sqlDataReader = reader;
DataTable dataTable = new DataTable();
dataTable.Columns.Add("Customer Id");
dataTable.Columns.Add("Customer Name");
while (sqlDataReader.Read())
{
DataRow row = dataTable.NewRow();
row["Customer Id"] = sqlDataReader["CustomerId"];
row["Customer Name"] = sqlDataReader["CustomerName"];
dataTable.Rows.Add(row);
}
GridView1.DataSource = dataTable;
GridView1.DataBind();
connection.Close();
return reader;
}
Hope it will helpful. Mark question as solved after trying.
--
Thanks