sql 2008 question
Hiya folks, im very new to the sql server 2008 express edition so i havent a clue. i might be going about this the wrong way so if you have any other ideas, would love to hear them.
ive created a tested database, called lindberg_test.
Ive done the drag and drop stuff, so all the auto bindings are on screen on my VB2008 express page. Thats where im up to.
i can click next, put new data in and all that but i need to go a bit further.
ive got my data in 12 columns.column 1 is my primary key, stroke my data point i need to refrence to call the data back from the entire row and sow it in the relevent text boxs on another page.
i was wondering can i use column 1 to recall the data from so lets say for example.
think about it in a musical way.
band name is in column 1
all the stuff about the album is in the other 11 columns.
so on page 1.VB i enter the band name, on page 2.vb the data from the 11 columns show in the relevent text boxes.
Also i think i read somewhere you put put pictures in sql sever, how do i do that for recall to a picturebox.
If i posted this to the wrong place very sorry. think of me virtually slapped, for making the mistake. let me know where to post it/move it to.
thanks in advance.
regard
rimlesskid
Answers
- Liam,
The following link maybe helpful to you. Let us know.
Storing and Retrieving Images from SQL Server using Microsoft .NET
Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com- Marked As Answer byXiao-Min Tan – MSFTMSFT, ModeratorFriday, December 04, 2009 7:13 AM
All Replies
- You should structure the table the following way:
CREATE TABLE Band ( BandID int identity (1,1) primary key, Band varchar(64) unique, -- other columns ModifiedDate date default (getdate()));
For storing images in the database, checkout AdventureWorks2008.Production.ProductPhoto table.
In Reporting Services report, it is very easy to work with images when stored in DB.
Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com - Thanks for the reply, i got some questions, i think i can see what happening, this is going to create a new table from scratch and set it up to the stuff specified.
1. where do stick the information.
my fault i missed abit out for question 2.
2. How do i bring back my data\recall it?
user will enter the band name into page 1 with a textbox. then click enter or press button which opens page 2 to show results for this band.
I know theres data gridview, but i need to set the page up with the relevent data in specific areas. so the data comes back to textboxes in particular points, say a band names down the left hand, mug shots on the right, list of groupies across the bottom.
Liam - Liam,
The following link maybe helpful to you. Let us know.
Storing and Retrieving Images from SQL Server using Microsoft .NET
Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com- Marked As Answer byXiao-Min Tan – MSFTMSFT, ModeratorFriday, December 04, 2009 7:13 AM
Thanks it did help found the answer as soon as i jumped on to the page, just have to work out how im going to organise the page.
Thanks for the help.
