SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 stored procedure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JavaTheScript
Starting Member

3 Posts

Posted - 02/28/2013 :  16:34:05  Show Profile  Reply with Quote
Okay... so I'm completely new to SQL and this forum. So if people can't follow this question, I didn't ask it right or any guidance is completely welcomed.

I'm using VS 2008 to make an inventory page. I need to:

-create web project
-make SQL calls, calling the stored procedure
-put the data I get back in a data table
-bind it to the divs I created to output the information

Usually I'm just the web develop/designer.. I don't know SQL so this is like leaping off a cliff. I made the "GUI" page using divs but I don't know how to go about doing this...

Is this very difficult to do? Any advice on where to start? or some stuff I could read to figure the problem out? Thanks.

James K
Flowing Fount of Yak Knowledge

3719 Posts

Posted - 02/28/2013 :  16:43:36  Show Profile  Reply with Quote
It is not very difficult to do - what I would advice is to find some good tutorials and follow through, and then adapt it to your needs. Here is one for example - browsing through, it seems pretty decent: http://www.beansoftware.com/ASP.NET-Tutorials/ASP.NET-SQL-Server.aspx
Go to Top of Page

JavaTheScript
Starting Member

3 Posts

Posted - 03/01/2013 :  14:01:45  Show Profile  Reply with Quote
quote:
Originally posted by James K

It is not very difficult to do - what I would advice is to find some good tutorials and follow through, and then adapt it to your needs. Here is one for example - browsing through, it seems pretty decent: http://www.beansoftware.com/ASP.NET-Tutorials/ASP.NET-SQL-Server.aspx



Thanks James I'll give these a look through! Again thank you for some direction ^_^
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3719 Posts

Posted - 03/01/2013 :  19:28:42  Show Profile  Reply with Quote
You are very welcome - post back if you run into a wall.
Go to Top of Page

JavaTheScript
Starting Member

3 Posts

Posted - 03/04/2013 :  12:51:00  Show Profile  Reply with Quote
Okay I have ran into a wall, haha. How do I call the items in the stored procedure into my divs?

<div class="leftFloat w25">
<h4>THIS THE ITEM NAME</h4>
<THE IS WHERE I WANT THE IMAGE><br></br>
</div>

The item name and image is stored in the database but i have to call the stored procedure first.

I don't know if this question made sense... let me know please.
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3719 Posts

Posted - 03/04/2013 :  13:32:52  Show Profile  Reply with Quote
You should use server controls and populate the image and item name in the code-behind. The example on this page show show to do this in a GridView, but the principle is the same even if you are not displaying it in a GridView. http://csharpdotnetfreak.blogspot.com/2009/07/display-images-gridview-from-database.html
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000