Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 stored procedure

Author  Topic 

JavaTheScript
Starting Member

3 Posts

Posted - 2013-02-28 : 16:34:05
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-28 : 16:43:36
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 - 2013-03-01 : 14:01:45
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
Master Smack Fu Yak Hacker

3873 Posts

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

JavaTheScript
Starting Member

3 Posts

Posted - 2013-03-04 : 12:51:00
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-03-04 : 13:32:52
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
   

- Advertisement -