You're Browsing As A Guest! Register Now... |
||
|
Become a ASP.NET Expert!
Join 416,729 ASP.NET Programmers for FREE! Get instant access to thousands
of ASP.NET experts, tutorials, code snippets, and more! There are 2,946 people online right now.Registration is fast and FREE... Join Now!
|
||
Page 1 of 1
MINI PROJECT
#3
Re: MINI PROJECT
Posted 18 July 2007 - 07:42 AM
Mini project? Sure why not, this is an easy mini project that I put together (or something like it) for school. Make a tracking system that tracks CD's, employees, and customers for a small town Music Store. Don't go over the top, just make a simple database, a few views and chuck some datagrids on the page with editable functionality.
Database - SQL Server (do you have to e-mail this project, or host it on the schools webserver, and do they have SQL0??) or Microsoft Access (Just zip up your files with this DB, easy right?)
-----Just use the the system.data.oledb namespace and you will have everything you need to connect it up. The connection is really the same as SQL connections with the system.data.sqlclient namespace, just change the SQL with OLEDB.
Make queries in Access that append tables, and have them accept variables, like:
Insert into Employees (firstName,lastName,address) values (@firstName,@lastName,@address).
In asp .net, when you make the commandtype on the oledb command object, make it storedprocedure and make teh command text the name of your query. Then add the parameters to the command object (ie. cmd.addWithValue("@firstName", txtFirstName.text)
Database - SQL Server (do you have to e-mail this project, or host it on the schools webserver, and do they have SQL0??) or Microsoft Access (Just zip up your files with this DB, easy right?)
-----Just use the the system.data.oledb namespace and you will have everything you need to connect it up. The connection is really the same as SQL connections with the system.data.sqlclient namespace, just change the SQL with OLEDB.
Make queries in Access that append tables, and have them accept variables, like:
Insert into Employees (firstName,lastName,address) values (@firstName,@lastName,@address).
In asp .net, when you make the commandtype on the oledb command object, make it storedprocedure and make teh command text the name of your query. Then add the parameters to the command object (ie. cmd.addWithValue("@firstName", txtFirstName.text)
#4 Guest_sneha*
Re: MINI PROJECT
Posted 19 June 2010 - 11:06 AM
Shivanry, on 18 July 2007 - 07:42 AM, said:
Mini project? Sure why not, this is an easy mini project that I put together (or something like it) for school. Make a tracking system that tracks CD's, employees, and customers for a small town Music Store. Don't go over the top, just make a simple database, a few views and chuck some datagrids on the page with editable functionality.
Database - SQL Server (do you have to e-mail this project, or host it on the schools webserver, and do they have SQL0??) or Microsoft Access (Just zip up your files with this DB, easy right?)
-----Just use the the system.data.oledb namespace and you will have everything you need to connect it up. The connection is really the same as SQL connections with the system.data.sqlclient namespace, just change the SQL with OLEDB.
Make queries in Access that append tables, and have them accept variables, like:
Insert into Employees (firstName,lastName,address) values (@firstName,@lastName,@address).
In asp .net, when you make the commandtype on the oledb command object, make it storedprocedure and make teh command text the name of your query. Then add the parameters to the command object (ie. cmd.addWithValue("@firstName", txtFirstName.text)
Database - SQL Server (do you have to e-mail this project, or host it on the schools webserver, and do they have SQL0??) or Microsoft Access (Just zip up your files with this DB, easy right?)
-----Just use the the system.data.oledb namespace and you will have everything you need to connect it up. The connection is really the same as SQL connections with the system.data.sqlclient namespace, just change the SQL with OLEDB.
Make queries in Access that append tables, and have them accept variables, like:
Insert into Employees (firstName,lastName,address) values (@firstName,@lastName,@address).
In asp .net, when you make the commandtype on the oledb command object, make it storedprocedure and make teh command text the name of your query. Then add the parameters to the command object (ie. cmd.addWithValue("@firstName", txtFirstName.text)
can u just give me a detailed description about how this projec will work and wat it does.
#6
Re: MINI PROJECT
Posted 05 July 2010 - 08:41 AM
Check out this thread about Project Ideas for a list of project ideas....
Also check out Martyr2’s Mega Project List for an even more detailed list of project ideas.
-Frinny
Also check out Martyr2’s Mega Project List for an even more detailed list of project ideas.
-Frinny
#8
Re: MINI PROJECT
Posted 05 August 2010 - 04:48 AM
Page 1 of 1


Ask A New Question
This topic is locked



MultiQuote









|