GridViewDecimalColumn col =
new
GridViewDecimalColumn();
col.Name =
"Total"
;
col.HeaderText =
"Total"
;
col.FormatString =
"{0:c0}"
;
col.MaxWidth = 90;
col.MinWidth = 90;
col.Width = 90;
col.FieldName =
"Total"
;
col.FormatInfo = CultureInfo.CreateSpecificCulture(
"en-GB"
);
radGridView1.Columns.Add(col);
radGridView1.Columns[
"Total"
].Expression =
"IsNull(Ink, 0) + IsNull(PB_Products, 0) + IsNull(Office_Supplies, 0) + IsNull(Freight, 0)"
;
radGridView1.Columns.Move(11, 9);
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
;}
}