More Problems with mdb and aps.net, what I need is

konstantin · Apr 28, 2012

Hi all again, I had recently post a question about how to use the Acces mdb files in Asp.net, like the pathner Dhiraj told me I created an Access Data Base using Microsoft Access 2000, and I used his code on my Html editor (just copy and paste) then I put the file on the specified path and rename the code page to example.aspx for run it over a windows 2000 server (from the c:inetpubwwwroot) using Internet Explorer. But it didn't work :-(( . Could you please Dhiraj or somebody else post me a complete example of how to make querys to a Access database? If I could run it once it would be enough to star to work in the good way. Thanks for your time, and sorry for the possible gramatical english errors on this post. From Spain. Salvador Gallego.Could you possibly elaborate on: "But it didn't work" If we knew WHAT did not work or what the ERROR was, we can help you. Otherwise, we are just guessing.Here is a sample app that use a select query to get data from the source Access database, edit the dataset data and push it back to the Access database and add a record directly into the Access database. You can create the source Access database easily enough. Just create a database named Test, add a table named TestTable then add the following fields to the table: rID (auto-numbered) rDate (Date/Time) rName (Text) rScore(Number) You should populate the database with about ten records just so the datagrid has something to show when you start up. Change the ConnectionString in the code to point to where ever you store the database and you should be set. Here's the code.========================================== <%@ Page Language="VB" %> <%@ Import NameSpace="System.Data" %> <%@ Import NameSpace="System.Data.OleDb" %> <SCRIPT RUNAT="SERVER"> '================================================= =========== ' EXAMPLE CODE FOR WORKING WITH DATA-BASE & DATA-SETS. ' BASIC CODE FOR OPENING A DATABASE. ' CREATING AND LOADING DATAADAPTER FROM DATABASE. ' CREATING A DATA-SET AND DATA-TABLE. ' LOADING DATA-TABLE FROM THE DATA-ADAPTER. ' MODIFYING DATA IN THE DATA-TABLE. ' ADDING A ROW OF DATA TO THE DATA-TABLE. ' ADDING AND SAVING DATA BACK TO THE DATA-BASE. ' ' ================================================== ===== ' ===== ALL CODE EXECUTES FROM THE PAGE-LOAD EVENT. ===== sub Page_Load(obj as Object, e as EventArgs) ' CREATE OBJECTS, OPEN DB, LOAD DATASET, LOAD DATA GRID. ' CREATE DATASET AND ADD NEW DATATABLE TO IT. Dim objDSet As New DataSet Dim tblTest As DataTable = objDSet.Tables.Add("tblTest") ' CREATE CONNECTION STRING AND SELECT COMMAND. Dim objConn As New oleDBConnection _ ("Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:InetPubwwwrootASPNETExamplesTest.mdb") Dim objSelect As New oleDBCommand("SELECT TOP 20 * FROM TestTable ORDER BY rDate DESC", objConn) objConn.Open() ' CREATE DATA-ADAPTER AND GIVE IT THE SELECT COMMAND TO EXECUTE. Dim objDataAdapter As New oleDBDataAdapter objDataAdapter.SelectCommand = objSelect ' USE DATA-ADAPTER TO FILL TABLE IN DATA-SET,CLOSE CONNECTION. objDataAdapter.Fill(objDSet,"tblTest") ' CREATE COMMANDBUILDER HANDLE SOURCE FILE UPDATING. Dim objAutoGen As New oleDbCommandBuilder(objDataAdapter) objConn.Close() ' DATA-GRID (objDGrid) IS DEFINED ON MAIN FORM AT BOTTOM OF PAGE. objDGrid.DataSource = objDSet objDGrid.DataMember = "tblTest" objDGrid.DataBind() '== STEP 2: EDIT DATA IN THE DATA-TABLE. 'NOTE: FIRST NUMBER IS ROW NUMBER, SECOND NUMBER IS COLUMN. objDSet.Tables("tblTest").Rows(1)(2) = "Blue Course" objDGrid.DataBind() '===== STEP 3: ADD A ROW OF NEW DATA TO DATA-TABLE ===== Dim NewRow As DataRow = tblTest.NewRow() NewRow.Item("ID") = 0 NewRow.Item("rDate") = "7/22/2001" NewRow.Item("rName") = "Aqua Row" NewRow.Item("rScore") = 79 tblTest.Rows.Add(NewRow) objDGrid.DataBind() ' REFRESH GRID WITH NEW DATA. '== STEP 4: UPDATE SOURCE DB FROM AN MODIFIED DATA-SET objDataAdapter.Update(objDSet,"tblTest") objDGrid.DataBind() End Sub '== INSERT DATA DIRECTLY INTO DATA-BASE WITHOUT USE OF ' DATA-SET OR DATA-ADAPTER. Sub UpdateSource() Dim strInsert As String Dim objConn As oleDbConnection strInsert = "Insert Into TestTable VALUE (@ID,@Date,@Name,@Score)" Dim objInsertCmd As New oleDBCommand(strInsert,objConn) Dim pID As New oleDBParameter("@ID",oleDBType.Integer,3) Dim pDate As New oleDBParameter("@Date",oleDBType.varChar,15) Dim pName As New oleDBParameter("@Name",oleDBType.varChar,20) Dim pScore As New oleDBParameter("@Score",oleDBType.Integer,5) With objInsertCmd.Parameters .Add(pID) .Add(pDate) .Add(pName) .Add(pScore) End with pID.Value = http://aspmessageboard.com/archive/index.php/78 pDate.Value= "06/25/2001" pName.Value="Or Course" pScore.Value = 99 objInsertCmd.Connection.Open() Try objInsertCmd.ExecuteNonQuery() Catch ex As Exception response.write("Couldn't Update Source DataBase" & " ") End try objInsertCmd.Connection.Close() End sub </SCRIPT>  <HTML><BODY> <ASP

ataGrid id="objDGrid" align="Center" runat="Server" Width = "400" BorderColor="Black" BackColor="#ffffff" CellPadding=3 CellSpacing="0" Font-Name="Verdana" AllowSorting="False" Font-Size="8pt" HeaderStyle-BackColor="#cfcfcf" enableViewState="false" /> </BODY></HTML>

More Problems with mdb and aps.net, what I need is

konstantin

New Member