Loading

how to bind grid view in C#

how to bind grid view in C#

sadeq tlb

10y1kVisual Basic .NET

i have gridview and i want bind it from data base but it not bind some Cells. it's class of table:

[Key]
[Required]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
[Column("FldKeyId")]
public int MyKeyId { get; set; }
[Required]
public Machine Machine { get; set; }
[Required]
public Employee Employee { get; set; }
[Required]
public Shift Shift { get; set; }
[Required]
[Column ("FldStartTime")]
public DateTime MyStartTime { get; set; }
[Required]
[Column ("FldEndTime")]
public DateTime MyEndTime { get; set; }
[Column("FldModificationDate")]
[Required]
public DateTime ModificationDate { get; set; } [Key]
[Required]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
[Column("FldKeyId")]
public int MyKeyId { get; set; }
[Required]
public Machine Machine { get; set; }
[Required]
public Employee Employee { get; set; }
[Required]
public Shift Shift { get; set; }
[Required]
[Column ("FldStartTime")]
public DateTime MyStartTime { get; set; }
[Required]
[Column ("FldEndTime")]
public DateTime MyEndTime { get; set; }
[Column("FldModificationDate")]
[Required]
public DateTime ModificationDate { get; set; }

that's my code for bind

void RefreshBreakGrid()
{
dgvcolDate.DataPropertyName = "ModificationDate";
dgvcolstarttime.DataPropertyName = "MyStartTime";
dgvcolendtime.DataPropertyName = "MyEndTime";
dgvcolemployee.DataSource = Employee.GetAllEmployee();
dgvcolemployee.DisplayMember = "MyName";
dgvcolemployee.ValueMember = "MyKeyId";
dgvcolemployee.DataPropertyName = "Employee";
dgvcolmachine.DataSource = Machine.GetAllMachine();
dgvcolmachine.DisplayMember = "MyName";
dgvcolmachine.ValueMember = "MyKeyId";
dgvcolmachine.DataPropertyName = "MyName";
dgvcolshift.DataSource = Shift.GetAllShift();
dgvcolshift.DisplayMember = "MyName";
dgvcolshift.ValueMember = "MyKeyId";
dgvcolshift.DataPropertyName = "Shift";
_Breaks=Break.GetAllBreak();
dgvBreak.AutoGenerateColumns = false;
dgvBreak.DataSource = _Breaks;
}

that's code for getAllBreaks

public static List GetAllBreak()
{
return new ContexManager().Breaks.Where(c => c.MyKeyId != 0).Include(c => c.Machine).Include(c => c.Employee).Include(c => c.Shift).ToList();
}

now when it runned in cells of shift it shown classLibrary.classes.shift for machine , employee such as shift what i have to do for it ?

3 Replies

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

Karthik Elumalai10y ago
Hi sadeq tlb ,
I hope you need to add gridview.databind() method to your code.
Addtional information:https://msdn.microsoft.com/en-us/library/fkx0cy6d(v=vs.110).aspx
kindly let me know your thougths or feedbacks
thanks
karthik
sadeq tlb10y ago
field :Shift , Machine ,Employeeare not getting the value
Vinay Singh10y ago
Hi
For which field you are not getting the value. if you are getting value on that case you are not assigning the value. have a look of the link
http://www.aspdotnet-pools.com/2014/07/how-to-bind-data-to-webgrid-in-aspnet.html