public detail(string funcname)
{
InitializeComponent();
DataClassesDataContext db = new DataClassesDataContext();
string fn = "", ln = "";
string[] fl = funcname.Split(new Char[] { '_' });
fn = fl[0];
ln = fl[1];
fname.Text = fn;
lname.Text = ln;
var nickname = from mytable in db.GetTable <mytable>() where mytable.first_name == fn && mytable.last_name == ln select mytable.nick_name;
Array nn = nickname.ToArray();
if (nn.GetValue(0) != null)
{
nname.Text = nn.GetValue(0).ToString();
}
else
{
nname.Text = "null";
}
var delt = from mytable in db.GetTable <mytable>() where mytable.first_name == fn && mytable.last_name == ln select mytable.phone_number;
Array dd = delt.ToArray();
if (dd.GetValue(0) != null)
{
del.Text = dd.GetValue(0).ToString();
}
else
{
del.Text = "null";
}
var delt2 = from mytable in db.GetTable <mytable>() where mytable.first_name == fn && mytable.last_name == ln select mytable.phone_number2;
Array dd2 = delt2.ToArray();
if (dd2.GetValue(0) != null)
{
del2.Text = dd2.GetValue(0).ToString();
}
else
{
del2.Text = "null";
}
var emailt = from mytable in db.GetTable <mytable>() where mytable.first_name == fn && mytable.last_name == ln select mytable.email;
Array ee = emailt.ToArray();
if (ee.GetValue(0) != null)
{
email.Text = ee.GetValue(0).ToString();
}
else
{
email.Text = "null";
}
var addresst = from mytable in db.GetTable <mytable>() where mytable.first_name == fn && mytable.last_name == ln select mytable.adress;
Array aa = addresst.ToArray();
if (aa.GetValue(0) != null)
{
address.Text = aa.GetValue(0).ToString();
}
else
{
address.Text = "null";
}
var describet = from mytable in db.GetTable <mytable>() where mytable.first_name == fn && mytable.last_name == ln select mytable.describe;
Array dds = describet.ToArray();
if (dds.GetValue(0) != null)
{
describe.Text = dds.GetValue(0).ToString();
}
else
{
describe.Text = "null";
}
}