public void addUserName()
{
dgvUserProfile.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvUserProfile.RowTemplate.Height = 30;
//This is for the individual Client
string tabelName = "clientIndividual";
ds = access.getTableData(tabelName);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string name = ds.Tables[0].Rows[i][1].ToString();
string surname = ds.Tables[0].Rows[i][2].ToString();
string fullName = name + " " + surname;
dgvUserProfile.Rows.Add(
new object[]
{
fullName
}
);
}
//This is for the business Client
string tabelName_busi = "businessClient";
ds = access.getTableData(tabelName_busi);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string name = ds.Tables[0].Rows[i][1].ToString();
string surname = ds.Tables[0].Rows[i][2].ToString();
string fullName = name + " " + surname;
dgvUserProfile.Rows.Add(
new object[]
{
fullName
}
);
}
}
public void loadDataTo_DvgCalls()
{
DataSet ds = access.getTableData("calls");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dgvCalls.Rows.Add(
new object[]
{
ds.Tables[0].Rows[i][0].ToString(),
ds.Tables[0].Rows[i][1].ToString(),
ds.Tables[0].Rows[i][2].ToString(),
ds.Tables[0].Rows[i][3].ToString(),
ds.Tables[0].Rows[i][4].ToString(),
ds.Tables[0].Rows[i][5].ToString(),
ds.Tables[0].Rows[i][6].ToString(),
ds.Tables[0].Rows[i][7].ToString()
}
);
}
}