Data grids? I want to be able to display a report!

Myriad_Rocker · 07-29-2010, 02:36 PM

Hey all, how's it going? I'm totally new to this thing. I've done a Hello World app using the iPhone SDK and that's about the extent of my knowledge so far. I have a programming background but it's all been Windows based using ASP.Net. I took a C++ class in college but that's as far as my C knowledge goes!

Anyway, the company I work for has charged me with creating an iPhone/iPad app that will allow our customers to run simple reports. We work in the retail world so the reports will show something like sales data by store number. The user keys in the store number(s), hits "GO", and a report pops up in a datagrid.

Problem is, I want to just simply start with trying to populate a datagrid with some data and I don't know how to get started. I've researched, Googled, and even followed a tutorial on the Table View object (was NO help and their XCode interface had different things than mine did).

So...how do I go about getting started with doing something like this? I just want to be able to connect to a database and run some sql to fetch some data back into a datagrid. Seems easy enough and I could do it pretty quickly in an ASP.Net environment, but this whole iPhone/iPad thing is new to me.

Appreciate any help.

MikesTooLz · 07-29-2010, 05:37 PM

To get this up quickly I suggest you use what you already know. ASP.net before moving to something more complicated like populating tableviews and making data grids.

Let the user enter the info, hit GO and then all the data you want gets requested via an asp.net page you have setup and displayed to the user in a UIWebView

You can then make the app a little more usefull than a website would be by added something like a button called Near By Stores. The click it and the app checks GPS coordinates and displays the nearest X number of stores. They then can get info quickly for what ever stores are nearby as well as manualy entering a store #.

This is all done while keeping most of your code in the ASP.net language that you already know well. Iphone app just passes info to your page and requests the info be displayed back as a webpage.

Myriad_Rocker · 07-30-2010, 10:10 AM

Quote:

Originally Posted by MikesTooLz

To get this up quickly I suggest you use what you already know. ASP.net before moving to something more complicated like populating tableviews and making data grids.

Let the user enter the info, hit GO and then all the data you want gets requested via an asp.net page you have setup and displayed to the user in a UIWebView

You can then make the app a little more usefull than a website would be by added something like a button called Near By Stores. The click it and the app checks GPS coordinates and displays the nearest X number of stores. They then can get info quickly for what ever stores are nearby as well as manualy entering a store #.

This is all done while keeping most of your code in the ASP.net language that you already know well. Iphone app just passes info to your page and requests the info be displayed back as a webpage.

I like this idea. However, would I have to use Safari?

MikesTooLz · 07-30-2010, 12:27 PM

No, when you put a UIWebview inside your app its almost like dragging and dropping a small safari browser window into the app.

it all would be displayed right inside the app. the users may not even notice that its a webpage thats being displayed.

Myriad_Rocker · 07-30-2010, 01:24 PM

Quote:

Originally Posted by MikesTooLz

No, when you put a UIWebview inside your app its almost like dragging and dropping a small safari browser window into the app.

it all would be displayed right inside the app. the users may not even notice that its a webpage thats being displayed.

Nice. I'll see what the boss says about that.

MikesTooLz · 07-30-2010, 02:46 PM

Quote:

Originally Posted by Myriad_Rocker

Quote:

Originally Posted by MikesTooLz

No, when you put a UIWebview inside your app its almost like dragging and dropping a small safari browser window into the app.

it all would be displayed right inside the app. the users may not even notice that its a webpage thats being displayed.

Nice. I'll see what the boss says about that.

the upside of doing this also is that you can make changes and updates to what is displayed to the user without requiring new versions of the app to be downloaded and installed. Changing apps and getting the updates out to the users can been a long process. and if you go through the apple app store its two weeks for them to review the app before approving the update and making it available for users to download.

Myriad_Rocker · 07-30-2010, 03:34 PM

Quote:

Originally Posted by MikesTooLz

No, when you put a UIWebview inside your app its almost like dragging and dropping a small safari browser window into the app.

it all would be displayed right inside the app. the users may not even notice that its a webpage thats being displayed.

Sounds like the boss is good with that. Thanks for the suggestion. I guess I'll get to work on this. He said that we can just display static data for now and if we can get that working, we can start pulling in real data.

Now...to get started...is there a tutorial on the UIWebView?

MikesTooLz · 07-30-2010, 05:57 PM

Quote:

Originally Posted by Myriad_Rocker

Quote:

Originally Posted by MikesTooLz

No, when you put a UIWebview inside your app its almost like dragging and dropping a small safari browser window into the app.

it all would be displayed right inside the app. the users may not even notice that its a webpage thats being displayed.

Sounds like the boss is good with that. Thanks for the suggestion. I guess I'll get to work on this. He said that we can just display static data for now and if we can get that working, we can start pulling in real data.

Now...to get started...is there a tutorial on the UIWebView?

Its rather simple, In my app I have setup a UIWebview named PictureWebView that displays photo's users have uploaded to the web. Here is how I tell the UIWebview to load the website.

Code:

//tell the UIWebView to load the page.
	NSString *webLink = @"http://mikestoolz.com/";
	NSURL *webURL = [NSURL URLWithString:webLink];
	NSURLRequest *requestStory = [NSURLRequest requestWithURL:webURL];
	[pictureWebView loadRequest:requestStory];

Myriad_Rocker · 08-02-2010, 10:45 AM

Quote:

Originally Posted by MikesTooLz

Quote:

Originally Posted by Myriad_Rocker

Quote:

Originally Posted by MikesTooLz

No, when you put a UIWebview inside your app its almost like dragging and dropping a small safari browser window into the app.

it all would be displayed right inside the app. the users may not even notice that its a webpage thats being displayed.

Sounds like the boss is good with that. Thanks for the suggestion. I guess I'll get to work on this. He said that we can just display static data for now and if we can get that working, we can start pulling in real data.

Now...to get started...is there a tutorial on the UIWebView?

Its rather simple, In my app I have setup a UIWebview named PictureWebView that displays photo's users have uploaded to the web. Here is how I tell the UIWebview to load the website.

Code:

//tell the UIWebView to load the page.
    NSString *webLink = @"http://mikestoolz.com/";
    NSURL *webURL = [NSURL URLWithString:webLink];
    NSURLRequest *requestStory = [NSURLRequest requestWithURL:webURL];
    [pictureWebView loadRequest:requestStory];

Do you have to synthesize the accessor methods? I think that's the space lingo.

I saw that when I was doing the Hello World tutorial.

MikesTooLz · 08-02-2010, 12:16 PM

synthesize pictureWebView

and in the .H file make sure you add

IBOutlet UIWebView *pictureWebView;
@property (nonatomic, retain) UIWebView *pictureWebView;

You can change pictureWebView to what ever name you want to call it, thats just what I used in my app.

07-29-2010, 02:36 PM	#1
Myriad_Rocker iPad Fan! Member #10906 Join Date: Jul 2010 Location: United States Posts: 6	Data grids? I want to be able to display a report! Hey all, how's it going? I'm totally new to this thing. I've done a Hello World app using the iPhone SDK and that's about the extent of my knowledge so far. I have a programming background but it's all been Windows based using ASP.Net. I took a C++ class in college but that's as far as my C knowledge goes! Anyway, the company I work for has charged me with creating an iPhone/iPad app that will allow our customers to run simple reports. We work in the retail world so the reports will show something like sales data by store number. The user keys in the store number(s), hits "GO", and a report pops up in a datagrid. Problem is, I want to just simply start with trying to populate a datagrid with some data and I don't know how to get started. I've researched, Googled, and even followed a tutorial on the Table View object (was NO help and their XCode interface had different things than mine did). So...how do I go about getting started with doing something like this? I just want to be able to connect to a database and run some sql to fetch some data back into a datagrid. Seems easy enough and I could do it pretty quickly in an ASP.Net environment, but this whole iPhone/iPad thing is new to me. Appreciate any help.

07-29-2010, 05:37 PM	#2
MikesTooLz iPad Master! Member #3851 Join Date: May 2010 Location: Miami, FL Posts: 1,665	To get this up quickly I suggest you use what you already know. ASP.net before moving to something more complicated like populating tableviews and making data grids. Let the user enter the info, hit GO and then all the data you want gets requested via an asp.net page you have setup and displayed to the user in a UIWebView You can then make the app a little more usefull than a website would be by added something like a button called Near By Stores. The click it and the app checks GPS coordinates and displays the nearest X number of stores. They then can get info quickly for what ever stores are nearby as well as manualy entering a store #. This is all done while keeping most of your code in the ASP.net language that you already know well. Iphone app just passes info to your page and requests the info be displayed back as a webpage. __________________ Live IRC Chat. Dowload my Apps:

07-30-2010, 12:27 PM	#4
MikesTooLz iPad Master! Member #3851 Join Date: May 2010 Location: Miami, FL Posts: 1,665	No, when you put a UIWebview inside your app its almost like dragging and dropping a small safari browser window into the app. it all would be displayed right inside the app. the users may not even notice that its a webpage thats being displayed. __________________ Live IRC Chat. Dowload my Apps:

08-02-2010, 12:16 PM	#10
MikesTooLz iPad Master! Member #3851 Join Date: May 2010 Location: Miami, FL Posts: 1,665	synthesize pictureWebView and in the .H file make sure you add IBOutlet UIWebView pictureWebView; @property (nonatomic, retain) UIWebView pictureWebView; You can change pictureWebView to what ever name you want to call it, thats just what I used in my app. __________________ Live IRC Chat. Dowload my Apps:

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Only three screens for app display?	jacamoore	iPad Help	2	07-02-2010 03:32 PM
Cellular Network Data - measures data use since...?	MLimtiaco	iPad General Discussions	2	06-30-2010 09:21 PM
iPad display bug	jameslawson	iPad Help	7	06-02-2010 05:31 AM
I did it!! Display anything from your iPad	Zip	iPad Hacking	3	05-14-2010 03:40 PM
VGA display question	mediapad	iPad Help	0	04-10-2010 09:06 PM

Data grids? I want to be able to display a report!

iPad data grid