SqlDataReader dr = null;
SqlConnection conn = null;
try
{
this.radGridView1.MasterGridViewTemplate.AutoGenerateColumns = true;
this.radGridView1.GridElement.BeginUpdate();
DataSet ds = new System.Data.DataSet();
string connectionString = ConfigurationManager.AppSettings["Conn"];
conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("SELECT * FROM Payment");
cmd.Connection = conn;
conn.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
radGridView1.DataSource = ds.Tables[0].DefaultView;
}
catch (Exception ex)
{
}
finally
{
conn.Close();
dr.Dispose();
}
Although the dataset is returning rows as a resultset, but when the grid loads, it displayes nothing. Is there anything I am missing.
I want to Auto generate the columns.
Thanks,
Saikat
var descriptor1 =
new
GroupDescriptor(
new
[]{
new
SortDescriptor(
"Country"
, ListSortDirection.Ascending) });
var descriptor2 =
new
GroupDescriptor(
new
[]{
new
SortDescriptor(
"User"
, ListSortDirection.Ascending) });
radListView1.EnableGrouping =
true
;
radListView1.ShowGroups =
true
;
radListView1.GroupDescriptors.Add(descriptor1 );
radListView1.GroupDescriptors.Add(descriptor2 );
public
class
Person
{
public
List<Orders> Orders {
get
;
set
;}
}
public
class
Orders
{
public
Guid Id {
get
;
set
;}
public
string
{
get
;
set
;}
}