public DataTable getCname(string cname)
 {
     objcmp = new COMPANYTableAdapter();
     return(objcmp.GetCname(cname));
 }