Hi,
In a form called form2 I have a datagridview. From another form named form7 I enter some vaues and it is stored into the db and immediately after that the form2's dgv is updated and it shows the values, but within one minute the values that are displayed in a particular row of form2's dgv disappears. I don't know why it is happening so? Can anyone help me in figuring out this datagridview's behaviour.
Thanks
Loading
sachi vasishtaPosted Jun 23, 2009, 7:30 AM
public void deleterows() // deletes all rows of the dgv
{
int delindex;
int cnt=dataGridView1.RowCount;
for (delindex = cnt-1; delindex >= 0; delindex--)
{
dataGridView1.Rows.RemoveAt(delindex);
}
}
and I have written the following code in form7
Here I am checking whether I have gone to form7 via form2 or form3
if (assformname == "form2obj")
{
FormCollection fc = Application.OpenForms;
foreach(Form f in fc)
{
if (f.Name == "Form2")
{
((Form2)(f)).deleterows();
}
}
loadform2();
//Form7.ActiveForm.Close();
}
else if (assformname == "form3obj")
{
FormCollection fc1 = Application.OpenForms;
foreach (Form f1 in fc1)
{
if (f1.Name == "Form3")
{
((Form3)(f1)).deleterows();
}
}
loadform3();
}
and here is the loadform2() function which updates the dgv of form2
public void loadform2()
{
/*label3.ForeColor = Color.Blue;
label3.Text = sdate;*/ // why????
//fobj2.dataGridView1.Rows.Remove();
List<string> list1 = new List<string>();
string ret1 = string.Format("select scheduleappointment.patientid from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
//string ret = string.Format("select scheduleappointment.patientid as Patient_Id,firstname as FirstName,lastname as LastName,phonemobile as Mobile_Phone,phonehome as Home_Phone,scheduledate as Date,starttime as StartTime,endtime as EndTime,provider as Doctor,reason as Reason,priority as Priority,sex as Sex,address as Address,city as City,statecode as State,scheduleid as SId from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", mysqldate);
OdbcDataReader dr1 = obj.getdata(ret1);
while (dr1.Read())
{
list1.Add(dr1.GetValue(0).ToString()); // contains patient-ids
}
obj.closecon();
List<string> list2 = new List<string>();
string ret2 = string.Format("select firstname from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr2 = obj.getdata(ret2);
while (dr2.Read())
{
list2.Add(dr2.GetValue(0).ToString()); // contains firstname
}
obj.closecon();
List<string> list3 = new List<string>();
string ret3 = string.Format("select lastname from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr3 = obj.getdata(ret3);
while (dr3.Read())
{
list3.Add(dr3.GetValue(0).ToString()); // contains lastname
}
obj.closecon();
List<string> list4 = new List<string>();
string ret4 = string.Format("select phonemobile from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr4 = obj.getdata(ret4);
while (dr4.Read())
{
list4.Add(dr4.GetValue(0).ToString()); // contains mobile phone numbers
}
obj.closecon();
List<string> list5 = new List<string>();
string ret5 = string.Format("select phonehome from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr5 = obj.getdata(ret5);
while (dr5.Read())
{
list5.Add(dr5.GetValue(0).ToString()); // Contains home phone numbers
}
obj.closecon();
List<string> list6 = new List<string>();
string ret6 = string.Format("select starttime from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr6 = obj.getdata(ret6);
while (dr6.Read())
{
list6.Add(dr6.GetValue(0).ToString()); // contains starttime
}
obj.closecon();
List<string> list7 = new List<string>();
string ret7 = string.Format("select endtime from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr7 = obj.getdata(ret7);
while (dr7.Read())
{
list7.Add(dr7.GetValue(0).ToString()); // contains endtime
}
obj.closecon();
List<string> list8 = new List<string>();
string ret8 = string.Format("select reason from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr8 = obj.getdata(ret8);
while (dr8.Read())
{
list8.Add(dr8.GetValue(0).ToString()); // contains reason
}
obj.closecon();
List<string> list9 = new List<string>();
string ret9 = string.Format("select age from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr9 = obj.getdata(ret9);
while (dr9.Read())
{
list9.Add(dr9.GetValue(0).ToString()); // contains ages
}
obj.closecon();
List<string> list10 = new List<string>();
string ret10 = string.Format("select sex from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr10 = obj.getdata(ret10);
while (dr10.Read())
{
list10.Add(dr10.GetValue(0).ToString()); // contains sex information
}
obj.closecon();
List<string> list11 = new List<string>();
string ret11 = string.Format("select city from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr11 = obj.getdata(ret11);
while (dr11.Read())
{
list11.Add(dr11.GetValue(0).ToString()); // contains city
}
obj.closecon();
List<string> list12 = new List<string>();
string ret12 = string.Format("select statecode from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr12 = obj.getdata(ret12);
while (dr12.Read())
{
list12.Add(dr12.GetValue(0).ToString()); // contains state-codes
}
obj.closecon();
List<string> list13 = new List<string>();
string ret13 = string.Format("select address from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr13 = obj.getdata(ret13);
while (dr13.Read())
{
list13.Add(dr13.GetValue(0).ToString()); // contains address
}
obj.closecon();
List<string> list14 = new List<string>();
string ret14 = string.Format("select scheduleid from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr14 = obj.getdata(ret14);
while (dr14.Read())
{
list14.Add(dr14.GetValue(0).ToString()); // contains scheduleid
}
obj.closecon();
List<string> list15 = new List<string>();
string ret15 = string.Format("select scheduledate from patientinfo,scheduleappointment where scheduledate='{0}' and scheduleappointment.patientid=patientinfo.patientid order by starttime", fulldate);
OdbcDataReader dr15 = obj.getdata(ret15);
while (dr15.Read())
{
list15.Add(dr15.GetValue(0).ToString()); // contains schedule date
}
obj.closecon();
//for (int i = 0; i < list6.Count; i++)
//{
int i=0;
if (list6.ElementAtOrDefault(i) == "08:30:00")
{
String[] row = { "8.30-9.00 AM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[0].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "8.30-9.00 AM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "09:00:00")
{
String[] row = { "9.00-9.30 AM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[1].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "9.00-9.30 AM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "09:30:00")
{
String[] row = { "9.30-10.00 AM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[2].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "9.30-10.00 AM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "10:00:00")
{
String[] row = { "10.00-10.30 AM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[3].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "10.00-10.30 AM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "10:30:00")
{
String[] row = { "10.30-11.00 AM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[4].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "10.30-11.00 AM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "11:00:00")
{
String[] row = { "11.00-11.30 AM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[5].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "11.00-11.30 AM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "11:30:00")
{
String[] row = { "11.30-12.00 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[6].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "11.30-12.00 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "12:00:00")
{
String[] row = { "12.00-12.30 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[7].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "12.00-12.30 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "12:30:00")
{
String[] row = { "12.30-1.00 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[8].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "12.30-1.00 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "13:00:00")
{
String[] row = { "1.00-1.30 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[9].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "1.00-1.30 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "13:30:00")
{
String[] row = { "1.30-2.00 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[10].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "1.30-2.00 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "14:00:00")
{
String[] row = { "2.00-2.30 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[11].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "2.00-2.30 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "14:30:00")
{
String[] row = { "2.30-3.00 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[12].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "2.30-3.00 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "15:00:00")
{
String[] row = { "3.00-3.30 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[13].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "3.00-3.30 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "15:30:00")
{
String[] row = { "3.30-4.00 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[14].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "3.30-4.00 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "16:00:00")
{
String[] row = { "4.00-4.30 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[15].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "4.00-4.30 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "16:30:00")
{
String[] row = { "4.30-5.00 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[16].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "4.30-5.00 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "17:00:00")
{
String[] row = { "5.00-5.30 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[17].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "5.00-5.30 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "17:30:00")
{
String[] row = { "5.30-6.00 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[18].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "5.30-6.00 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
if (list6.ElementAtOrDefault(i) == "18:00:00")
{
String[] row = { "6.00-6.30 PM", "", list2.ElementAtOrDefault(i), list3.ElementAtOrDefault(i), list8.ElementAtOrDefault(i), "", list4.ElementAtOrDefault(i), list9.ElementAtOrDefault(i), list10.ElementAtOrDefault(i), list11.ElementAtOrDefault(i) + ", " + list12.ElementAtOrDefault(i), list13.ElementAtOrDefault(i), list1.ElementAtOrDefault(i), list5.ElementAtOrDefault(i), list14.ElementAtOrDefault(i), list15.ElementAtOrDefault(i) };
fobj2.dataGridView1.Rows.Add(row);
string reason = list8.ElementAtOrDefault(i);
string get = string.Format("select backcolor from reasontypes,defaultcolor where reasontypes.reasonid=defaultcolor.reasonid and reasontype='{0}'", reason);
OdbcDataReader dr = obj.getdata(get);
if (dr.Read())
{
int argb;
argb = int.Parse(dr.GetValue(0).ToString());
Color cname = Color.FromArgb(argb);
fobj2.dataGridView1.Rows[19].DefaultCellStyle.BackColor = cname;
}
obj.closecon();
i++;
}
else
{
String[] row = { "6.00-6.30 PM", "", "", "", "", "", "", "", "", "", "", "", "", "", "" };
fobj2.dataGridView1.Rows.Add(row);
}
//}
Form7.ActiveForm.Close();
}
Blocked AccountPosted Jun 23, 2009, 7:14 AM
Can u send sample code which you have written?