private void LoadDetails(string id)
{
DataLayer.SQLDataProvider data = new DataLayer.SQLDataProvider();
DataTable dtinfo = data.GetGuestbookDataByID(id);
if (dtinfo.Rows.Count > 0)
{
System.Data.DataRow tempVar = dtinfo.Rows[0];
inFullName.Text = tempVar["FullName"].ToString();
inIPAddress.Text = tempVar["IPAddress"].ToString();
inEmail.Text = tempVar["Email"].ToString();
inMessage.Text = tempVar["Message"].ToString();
inDate.Text = tempVar["SubmissionDate"].ToString();
inGender.Text = tempVar["Gender"].ToString();
chkApproved.Checked = tempVar["Approved"];
lstCountry.Items.FindByValue(tempVar["Country"].ToString()).Selected = true;
lstState.Items.FindByValue(tempVar["State"].ToString()).Selected = true;
inHomepage.Text = tempVar["HomePageURL"].ToString();
inGuestbook.Text = tempVar["GuestBookURL"].ToString();
}
}
