//public IEnumerable<DataGuest> Search(string txtsearch) //{ // using (SqlConnection conn = new SqlConnection(GetConnstr())) // { // string strsql = @"select * from DataGuest where NamaGuest='" + txtsearch + "'"; // return conn.Query<DataGuest>(strsql); // } //} public void Dispose() { db.Dispose(); }