本文整理匯總了C#中Android.ExecSQL方法的典型用法代碼示例。如果您正苦於以下問題:C# Android.ExecSQL方法的具體用法?C# Android.ExecSQL怎麽用?C# Android.ExecSQL使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Android
的用法示例。
在下文中一共展示了Android.ExecSQL方法的6個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: OnCreate
public override void OnCreate(Android.Database.Sqlite.SQLiteDatabase db)
{
db.ExecSQL (@"CREATE TABLE IF NOT EXISTS Question (QuestionID INTEGER PRIMARY KEY AUTOINCREMENT," +
"IMAGEID NOT NULL, QUESTIONSTRING VARCHAR(150) NOT NULL,CORRECTANSWER VARCHAR(150) NOT NULL,"+
"WRONGANSWER1 VARCHAR(100) NOT NULL,WRONGANSWER2 VARCHAR(100) NOT NULL,WRONGANSWER3 VARCHAR(100) NOT NULL,"+
"DATEENTERED varchar(30) NOT NULL)");
}
示例2: OnUpgrade
public override void OnUpgrade(Android.Database.Sqlite.SQLiteDatabase db, int oldVersion, int newVersion)
{
db.ExecSQL ("DROP TABLE IF EXISTS QuizScore");
OnCreate (db);
}
示例3: OnCreate
public override void OnCreate(Android.Database.Sqlite.SQLiteDatabase db)
{
db.ExecSQL (@"CREATE TABLE IF NOT EXISTS QuizScore (ScoreID INTEGER PRIMARY KEY AUTOINCREMENT," +
"ScoreDate varchar(30) NOT NULL, PlayerName varchar(10) NOT NULL, ScoreNumber NOT NULL)");
}
示例4: OnCreate
public override void OnCreate(Android.Database.Sqlite.SQLiteDatabase db)
{
db.ExecSQL(@"CREATE TABLE IF NOT EXISTS GolfScore (GolfID INTEGER PRIMARY KEY AUTOINCREMENT," +
"ScoreDate varchar(30) NOT NULL, ScoreNumber NOT NULL, Rating double NOT NULL, Slope int not null)");
}
示例5: OnCreate
public override void OnCreate(Android.Database.Sqlite.SQLiteDatabase db)
{
db.ExecSQL (@"CREATE TABLE IF NOT EXISTS Station (StationID INTEGER PRIMARY KEY AUTOINCREMENT, " +
"ID VARCHAR(50) NOT NULL, LocationX VARCHAR(15) NOT NULL, LocationY VARCHAR(15) NOT NULL," +
"Name VARCHAR(50) NOT NULL, Standardname VARCHAR(50) NOT NULL)");
}
示例6: OnCreate
public override void OnCreate(Android.Database.Sqlite.SQLiteDatabase db)
{
db.ExecSQL (@"CREATE TABLE IF NOT EXISTS CONNECTION (CONNECTIONID INTEGER PRIMARY KEY AUTOINCREMENT, " +
"ID VARCHAR(20) NOT NULL, SOURCE VARCHAR(8000) NOT NULL)");
}