//----------------------------------------------------------------------------- public static ContactDS.ContactStateDSDataTable SelectContactState(Int32 contactId) { ContactStateDSTableAdapter ta = new ContactStateDSTableAdapter(); ta.Connection.ConnectionString = UcConnection.ConnectionString; return(ta.GetData(contactId)); }