| | |
I need help..urgently
Please support our VB.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Feb 2005
Posts: 18
Reputation:
Solved Threads: 0
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..
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..
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
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
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()
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()
![]() |
Similar Threads
- I need .NET basic interview questions urgently (C#)
- urgently need help.....pliz... (PHP)
- C++ Assignment NEED HELP URGENTLY (C++)
- is it possible to save a visual basic form in jpeg format??? pls help... urgently... (Visual Basic 4 / 5 / 6)
- Help Needed Urgently With Coding (Java)
Other Threads in the VB.NET Forum
- Previous Thread: More Questions
- Next Thread: how to run .net 2003 trial version on Terminal server 2000
| Thread Tools | Search this Thread |
.net 30minutes 2005 2008 access account arithmetic array basic binary bing button buttons center check code combobox component connectionstring crystalreport data database databasesearch datagrid datagridview date design dissertation dissertations dissertationthesis dropdownlist excel fade file-dialog folder ftp generatetags google gridview hardcopy image images input insert intel internet listview mobile monitor ms net networking objects output passingparameters peertopeervideostreaming picturebox picturebox1 plugin port print problem problemwithinstallation project remove save searchbox searchvb.net select serial server shutdown soap survey table tcp temperature text textbox timer toolbox trim update updown user vb vb.net vb.netcode vb.netformclosing()eventpictureboxmessagebox vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web winforms wpf





