This is the table im using:
create table Material(
p_user_id varchar(50),
sb_code varchar(8),
file_type varchar(20) not null,
material_name varchar(50) not null,
material varbinary(MAX) not null,
date_time datetime default null,
constraint pk_Prof_subj_INT
primary key (p_user_id, sb_code),
foreign key(p_user_id) references Professors(p_user_id),
foreign key(sb_code) references Subjects(sb_code));
The column material is where the image/doc will be stored. But i dont know where to start. I added a formview to the page and used a file upload object to get the file but i dont know what else to do. My professor says not to use ADO.NET and only data access layer.
No looking for someone to code...just an idea of how to start