string tFilePath = "c:\example.mdb";
// string MDBConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; data source=" + tFilePath + ";Jet OLEDB:Engine Type=5";
// REPLACE WITH THIS
string MDBConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + tFilePath + ";";
ADOX.CatalogClass tCat = new ADOX.CatalogClass();
ADODB.Connection conAdodb=null;
try
{
tCat.Create(MDBConnStr);
conAdodb = (ADODB.Connection)tCat.ActiveConnection;
//..code here, create table, linked table...
}catch(Exception ex)
{
//...code here
}
finally {
//best close
if (conAdodb != null && conAdodb.State != 0)
conAdodb.Close();
System.Runtime.InteropServices.Marshal.ReleaseComObject(tCat);
GC.Collect();
GC.WaitForPendingFinalizers();
}
screenPermette di gestire più terminali anche con una sola 'finestra' attiva.
mysqldump -u root -paaaa dbtest > dbtest-$(date +%d-%m-%Y-%H.%M.%S).sql
sudo mysqldump -u root -paaaa dbtest > dbtest-$(date +%d-%m-%Y-%H.%M.%S).sql
dbtest-07-09-2015-11.15.15.sql
NSString *stringHello = @"Hello"; label.text = [NSString stringWithFormat:@"%@%@%@", stringHello,@" ",@"World!"];
UIAlertView *alert = [[UIAlertView alloc]initWithTitle:@"TITOLO DI ESEMPIO"
message:@"MESSAGGIO DI ESEMPIO"
delegate:self
cancelButtonTitle:nil // cancelButtonTitle:@"CANC"
otherButtonTitles:@"OK", nil];
alert.tag=101;
[alert show];
//per ricevere l'evento del pulsante cliccato
- (void)alertView:(UIAlertView *)alertView didDismissWithButtonIndex:(NSInteger)buttonIndex {
if (buttonIndex == 0) {
//...other code
}
//...
}
@property (nonatomic, strong) NSMutableArray *jsonArray;
#define getDataUrl @"http://www.example.com/data.php"
//...
@implementation OnlineViewController
@synthesize jsonArray;
- (void)viewWillAppear:(BOOL)animated
{
[self retrieveData];
}
//other code.....
#pragma mark -
#pragma mark Class Methods
-(void) retrieveData{
NSURL *url = [NSURL URLWithString:getDataUrl];
NSData *data = [NSData dataWithContentsOfURL:url];
jsonArray = [NSJSONSerialization JSONObjectWithData:data options:kNilOptions error:nil];
for (int i =0 ; i < jsonArray.count; i++){
NSString *cPosition = [NSString stringWithFormat:@"%@%d", @"",(i+1)];
NSString *cScore = [[jsonArray objectAtIndex:i] objectForKey:@"score_player"];
NSString *cName = [[jsonArray objectAtIndex:i] objectForKey:@"name_player"];
//...other code to set value on tableview
}
[self.tableView reloadData];
}
- (void)textViewDidEndEditing:(UITextView *)textView
{
CGAffineTransform translateUp = CGAffineTransformMakeTranslation(0.0, 0.0);
[UIView beginAnimations:nil context:nil];
[UIView setAnimationDuration:0.2];
self.view.transform = translateUp;
[UIView commitAnimations];
}
//fieldName: UITextField defined in File.h
- (void)touchesBegan:(NSSet *)touches withEvent:(UIEvent *)event {
UITouch *touch = [[event allTouches] anyObject];
if ([fieldName isFirstResponder] && [touch view] != fieldName) {
[fieldName resignFirstResponder];
}
else if ([fieldCountry isFirstResponder] && [touch view] != fieldCountry) {
[fieldCountry resignFirstResponder];
}
[super touchesBegan:touches withEvent:event];
}
- (void)textViewDidBeginEditing:(UITextView *)textView
{
CGAffineTransform translateUp = CGAffineTransformMakeTranslation(0.0, -150.0);
[UIView beginAnimations:nil context:nil];
[UIView setAnimationDuration:0.2];
self.view.transform = translateUp;
[UIView commitAnimations];
}
- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions {
[NSThread sleepForTimeInterval:3]; //add 3 seconds
return YES;
}
private void CreaLog(string strMsg)
{
System.IO.StreamWriter file = new System.IO.StreamWriter("c:\\temp\\log.txt",true); //true: append
file.WriteLine(strMsg);
file.Close();
}
[client] port=3306 default-character-set=latin1 [mysqld] default-character-set=latin1 default-storage-engine=INNODB max_connections=100 query_cache_size=0 table_cache=256 tmp_table_size=5M thread_cache_size=8 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=8M key_buffer_size=8M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=212K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=8M innodb_log_file_size=10M innodb_thread_concurrency=18
//define max chars for UITextField
- (BOOL)textField:(UITextField *)textField shouldChangeCharactersInRange:(NSRange)range replacementString:(NSString *)string {
//[textField setText:[textField.text uppercaseString]]; //all text in uppercase
if(textField.tag==210){
NSUInteger newLength = [textField.text length] + [string length] - range.length;
return (newLength > 3) ? NO : YES; //max 3 chars
}
else if(textField.tag==200){
NSUInteger newLength = [textField.text length] + [string length] - range.length;
return (newLength > 10) ? NO : YES; //max 10 chars
}
else{
return YES;
}
}
@interface OptionsController : UIViewController <UIAlertViewDelegate, UITextViewDelegate, UITextFieldDelegate, NSURLConnectionDelegate>
{
//...
}
function sendEmail()
email_mittente = "someone@example.com"
email_destinatario = "someone@example.com"
email_oggetto = "test object"
email_corpo = "test test body"
email_tipo = ""
set objCDO = Server.CreateObject("CDO.Message")
Set objConfig = Server.createObject ("CDO.Configuration")
Set Flds = objConfig.Fields
Flds("http://schemas.microsoft.com/cdo/configuration/urlgetlatestversion") = True
Flds("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
Flds("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.example.com"
Flds("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
Flds("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
Flds("http://schemas.microsoft.com/cdo/configuration/sendusername") = "smtp@example.com"
Flds("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "passexample"
Flds.Update
With objCDO
Set .Configuration = objConfig
.From = email_mittente
.To = email_destinatario
.Bcc = email_bcc
.Subject = email_oggetto
if email_tipo = "html" then
.HTMLBody = email_corpo
else
.TextBody = email_corpo
end if
.Send
end with
Set objConfig = Nothing
set objCDO = Nothing
end function