Tech-Today
This tutorial will try to create an iphone application that will dynamically create tables in sqlite database. This tutorial will use anime information for example.
Note that this tutorial is not for beginner, I'll just summarized the steps and provide the github repository for the project.
Prerequisite:
1.) You should look at the code in my todo list tutorial before this one.
2.) Create an anime sqlite database using your preferred tool, I've used SQLite Manager plugin for firefox.
Steps:
1.) Create a new empty ios project.
2.) Select the project, and in the general tab under Linked Frameworks, add libsqlite3.0.dylib.
3.) Add the sqlite database we've created, right click on the project folder click Add Files..., then select the anime.sqlite file and check "Copy items into destination...". Now we have the database inside our project.
Your project should look like:
4.) Create the main story board inside the SqliteAnimeDb folder.
5.) In the project setting set the main interface to the story board we've created.
6.) Comment these 3 lines in the AppDelegate class:
7.) I'll let the code explain but I'm attaching the 2 views I've created for demo.
In this view we display the list of anime titles with author subtitle. Clear and reload do the functions respectively on the database. + will navigate to the next view.
- Mobile Development
iPhone / XCode DevelopmentCreate an iphone application using xcode that dynamically creates sqlite tablesMy Todo List iphone application development using xcodeiPhone Development Making the Slider control workHow TosCreate an image slide show in iphone...
- How To Setup Elmah For Mvc3 .net 4.0
Tired of setting up your configuration to load elmah? You think you already configured everything even compiling the source code to build on .net 4.0 but still failed? Experience a routing error, or this persistent line: elmah Could not load file or assembly...
- Iphone Xcode - Create A Simple Uiscrollview
Finally getting acquainted with iPhone's xcode. Now I'll build a simple window base application to demo the UIScrollView features. 1.) Create a new window base application, named it MyScroll. It should create 2 files: a.) MyScrollAppDelegate.h...
- Iphone Xcode - How To Create A Simple Uitabbar
A simple demonstration by code on how to implement a UITabBar on iPhone. 1.) Create a new Windows based project, and named it whatever you want. 2.) You should look up for 2 files, .h and .m (I named mine MyTab). MyTabAppDelegate.h #import <UIKit/UIKit.h>...
- Android Bundle Sqlite Database On Application. Create Sqlite Database On First Application Invoke.
How to setup a default sqlite database structure with data in an android application. Add this class and initialize it in your main class that extends Activity. import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase;...
Tech-Today
Create an iphone application using xcode that dynamically creates sqlite tables
This tutorial will try to create an iphone application that will dynamically create tables in sqlite database. This tutorial will use anime information for example.
Note that this tutorial is not for beginner, I'll just summarized the steps and provide the github repository for the project.
Prerequisite:
1.) You should look at the code in my todo list tutorial before this one.
2.) Create an anime sqlite database using your preferred tool, I've used SQLite Manager plugin for firefox.
Steps:
1.) Create a new empty ios project.
2.) Select the project, and in the general tab under Linked Frameworks, add libsqlite3.0.dylib.
3.) Add the sqlite database we've created, right click on the project folder click Add Files..., then select the anime.sqlite file and check "Copy items into destination...". Now we have the database inside our project.
Your project should look like:
4.) Create the main story board inside the SqliteAnimeDb folder.
5.) In the project setting set the main interface to the story board we've created.
6.) Comment these 3 lines in the AppDelegate class:
self.window = [[UIWindow alloc] initWithFrame:[[UIScreen mainScreen] bounds]];
// Override point for customization after application launch.
self.window.backgroundColor = [UIColor whiteColor];
[self.window makeKeyAndVisible];
7.) I'll let the code explain but I'm attaching the 2 views I've created for demo.
In this view we display the list of anime titles with author subtitle. Clear and reload do the functions respectively on the database. + will navigate to the next view.
This view is where we add an anime object.
Note:
KBSSqliteConnection, is the class where we put the sqlite database operations like create table, open db, insert record, etc.
Github repository:
https://github.com/czetsuya/SQLite-Demo
- Mobile Development
iPhone / XCode DevelopmentCreate an iphone application using xcode that dynamically creates sqlite tablesMy Todo List iphone application development using xcodeiPhone Development Making the Slider control workHow TosCreate an image slide show in iphone...
- How To Setup Elmah For Mvc3 .net 4.0
Tired of setting up your configuration to load elmah? You think you already configured everything even compiling the source code to build on .net 4.0 but still failed? Experience a routing error, or this persistent line: elmah Could not load file or assembly...
- Iphone Xcode - Create A Simple Uiscrollview
Finally getting acquainted with iPhone's xcode. Now I'll build a simple window base application to demo the UIScrollView features. 1.) Create a new window base application, named it MyScroll. It should create 2 files: a.) MyScrollAppDelegate.h...
- Iphone Xcode - How To Create A Simple Uitabbar
A simple demonstration by code on how to implement a UITabBar on iPhone. 1.) Create a new Windows based project, and named it whatever you want. 2.) You should look up for 2 files, .h and .m (I named mine MyTab). MyTabAppDelegate.h #import <UIKit/UIKit.h>...
- Android Bundle Sqlite Database On Application. Create Sqlite Database On First Application Invoke.
How to setup a default sqlite database structure with data in an android application. Add this class and initialize it in your main class that extends Activity. import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase;...