
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 );