Member Avatar for sanhitabhide

Hiii all,

I am sanhita Bhide form australia and doing Graduation In Information Technology. I am doing Vb.Net as one of my subject I am having a project in relation with windows application in Vb.Net in which we are required to build a windows based application for a "Car Auction dealership". I am loocking for some guidlines and some step by step directions to follow and not The Answer so please dont overlooked me as lazy student.

Background: Your company has been contracted to build a Car Auction system that manages Auctions of Cars for a dealership in Sydney. The system has four main parts.

1) a Security system that allows appropriate users limited access to the system.

2) a System that allows employees of the car dealership to create a car auction

3) a System that allows employees of the car dealership to manage auctions

4) a reporting system that allows several reports to be run.
We have been asked to make a database in Access 2003 and utilize the .NET libraries, including ADO.NET, ASP.NET and Windows forms. I would be glad if some one would help me with it.

along with it for the further studies in Vb in which i am not going very well . I would like to have some guidlines about how to start learning it by my self and how to improve my Logic and coding style?

Thanking you , In anticipation
Sanhita

  • 2 Contributors
  • 1 Reply
  • 133 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by preetham.saroja

Dani AI

Generated

For : a compact, task-driven roadmap that keeps things practical without handing over the finished solution.

Start by splitting the project into small, testable milestones: data model, data access layer (DAL), business logic layer (BLL), Windows Forms UI, authentication/authorization, reporting, and testing/deployment. Work one milestone at a time and keep each part small enough to finish in a day or two.

Suggested schema (work from this and refine):

  • Users: UserID, Username, PasswordHash, Salt, RoleID
  • Roles: RoleID, RoleName
  • Cars: CarID, Make, Model, Year, VIN, Condition, ReservePrice
  • Auctions: AuctionID, CarID, StartDate, EndDate, MinBid, Status
  • Bids: BidID, AuctionID, UserID, Amount, Timestamp
  • Employees/Dealership info as needed

ADO.NET and Access specifics: use the OleDb classes for Access 2003, always open connections only when needed and close them with Using/End Using blocks, use parameterized commands (OleDb uses positional parameters), prefer DataAdapters/Typed DataSets for rapid forms work, and centralize all SQL in the DAL so UI code stays thin. Test locking and concurrency early—Access can behave poorly under realistic multi-user loads; if the environment expects many simultaneous users, plan a migration path to SQL Server Express later.

Security and reports: echoing , implement authentication and role-based UI. Never store plain-text passwords—store salted hashes and validate server-side. Keep connection strings in a config file, validate all inputs, and log exceptions. For reporting, choose between Crystal Reports (feature-rich) and the Visual Studio ReportViewer (.rdlc) depending on tool availability and complexity.

Learning and coding style: build small prototypes, refactor often, use meaningful names, keep functions short, and put business rules in BLL classes, not in form code. Avoid blind copy/paste: read and understand any snippet before reuse. Use source control and iterate: design, build, test, repeat.

Member Avatar for preetham.saroja

hai sanhita,,
first to make only authorised user to access the application-create login page
with userid& password field...only who has got valid userid is allowed to access next pages of application,,,
2 and 3)once user logs in ..allow him to manage or modify or perform all the actions required for the auction...
4)once all the modifictions are performed on the page .then clicking on the report button on the form.should b able to generate the report..create the report using crystal report.....
And the project which u have chosen is perfect for the beginner..just keep on working on new stuffs.never cut,copy& paste the code-untill and unless u gain experience,,,
keep goin& try to swtch onto vb.net.bcz vb is no more(dont get tensed for getting into vb..always go step by step once ur good in vb then get into vb.net)
regards...
preetham

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.