User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 401,663 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,699 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 2694 | Replies: 8
Reply
Join Date: Feb 2005
Posts: 18
Reputation: N[e]tt[e] is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
N[e]tt[e] N[e]tt[e] is offline Offline
Newbie Poster

Help I need help..urgently

  #1  
Feb 7th, 2005
Anyone can help me?
I'm doing my final year project.
I need source code for my project.
I need to know how can i link my Ms access to my project..using OLEdb and Odbc..I need to do log in page(login.aspx) but i dunoe how to type the coding.anyone here can tell me? and also..i need to know how to link to my registration.aspx..it is like to update my Ms access..the problem is i dunoe how to link..
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2005
Posts: 175
Reputation: Letscode is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 5
Letscode's Avatar
Letscode Letscode is offline Offline
Junior Poster

Re: I need help..urgently

  #2  
Feb 10th, 2005
Msaccess connectivity
Reply With Quote  
Join Date: Feb 2005
Posts: 175
Reputation: Letscode is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 5
Letscode's Avatar
Letscode Letscode is offline Offline
Junior Poster

Re: I need help..urgently

  #3  
Feb 10th, 2005
okey Here v go...

1.You make a connection to the database, run a Command (e.g. a SQL Query) and put the returning data into a DataReader if you just want to look at it, or a DataAdapter. You then invoke a method against the DataAdapter to fill a DataSet, which you can then manipulate just like a database table so that you can read, edit, add, and delete, then you return the data via the DataAdapter which automatically takes care of making sure that all your changes are returned to the Database, it can even warn you about data concurrency problems. The great thing about this is that whilst you are doing all this it is not necessary to maintain a constant connection with the Database, you only need to connect for the times when data actually moves in and out of your DataAdapter.

For some specific code for a connection to an Access DB have a look at http://msdn.microsoft.com/library/de...ssdatabase.asp

2.If you wanna login page ....Just follow this link...Its very nicely explained

http://www.daniweb.com/techtalkforum...ead.php?t=6028
Reply With Quote  
Join Date: Feb 2005
Posts: 175
Reputation: Letscode is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 5
Letscode's Avatar
Letscode Letscode is offline Offline
Junior Poster

Re: I need help..urgently

  #4  
Feb 10th, 2005
3.Inorder to update a database...
Follow this method...
1.Import the database object by using

Imports System.Data.OleDb

2.
Dim strConn As String
Dim strSQL As String
Dim Conn As OleDb.OleDbConnection
Dim cmd As OleDb.OleDbCommand

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\db1.mdb"
strSQL = "insert into db1(name,desc) values( '" & TextBox1.Text &
"', '" & TextBox2.Text & "')"

Conn = New OleDb.OleDbConnection(strConn)

Conn.Open()

cmd = New OleDb.OleDbCommand(strSQL, Conn)
cmd.ExecuteNonQuery()
Conn.Close()
Reply With Quote  
Join Date: Feb 2005
Posts: 18
Reputation: N[e]tt[e] is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
N[e]tt[e] N[e]tt[e] is offline Offline
Newbie Poster

Re: I need help..urgently

  #5  
Feb 10th, 2005
the problem is i dun use SQL..i'm using ODBC.
Reply With Quote  
Join Date: Feb 2005
Posts: 175
Reputation: Letscode is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 5
Letscode's Avatar
Letscode Letscode is offline Offline
Junior Poster

Re: I need help..urgently

  #6  
Feb 11th, 2005
What do you mean by "I need to know how can i link my Ms access to my project..using OLEdb and Odbc.."
Reply With Quote  
Join Date: Feb 2005
Posts: 18
Reputation: N[e]tt[e] is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
N[e]tt[e] N[e]tt[e] is offline Offline
Newbie Poster

Re: I need help..urgently

  #7  
Feb 13th, 2005
Originally Posted by Letscode
What do you mean by "I need to know how can i link my Ms access to my project..using OLEdb and Odbc.."


i need to use Odbc or Oledb dataadapter/connection/command etc..to link my Ms access to my project..
as i'm doing store inventory and management system
Reply With Quote  
Join Date: Feb 2005
Posts: 175
Reputation: Letscode is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 5
Letscode's Avatar
Letscode Letscode is offline Offline
Junior Poster

Re: I need help..urgently

  #8  
Feb 13th, 2005
I have explained you the Oledb connectivity ,Oledb command in previous post..

Just take a look at the Update function...

Hope this helps...
Reply With Quote  
Join Date: Feb 2005
Posts: 18
Reputation: N[e]tt[e] is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
N[e]tt[e] N[e]tt[e] is offline Offline
Newbie Poster

Solution Re: I need help..urgently

  #9  
Mar 25th, 2005
Originally Posted by Letscode
I have explained you the Oledb connectivity ,Oledb command in previous post..

Just take a look at the Update function...

Hope this helps...
Thank!Anyway..I switched my program to vb.net..window forms..instead of asp.net..Thank for your help
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb VB.NET Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the VB.NET Forum

All times are GMT -4. The time now is 7:06 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC