Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
B

busteronline

@busteronline
About
Posts
3
Topics
3
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • IErrorInfo.GetDescription failed with E_FAIL(0x80004005)
    B busteronline

    I get the following error while trying to access an msacccess database ,i cant seem to figure it out,the error is IErrorInfo.GetDescription failed with E_FAIL(0x80004005). Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed with E_FAIL(0x80004005). Source Error: Line 20: SQLString = "SELECT DISTINCT Position FROM applicant ORDER BY position" Line 21: DBCommand = New OleDbCommand(SQLString, DBConnection) Line 22: DBReader = DBCommand.ExecuteReader() Line 23: Line 24: While DBReader.Read() the source code that generate d error is as follows <%@ Page Language="vb" Debug="true" %> <%@ Import Namespace="System.Data.OleDb" %> <%@ Import Namespace="System.Drawing" %> Sub Page_Load Dim DBConnection As OleDbConnection Dim DBCommand As OleDbCommand Dim DBReader As OleDbDataReader Dim SQLString As String Dim Counter As Integer = 0 DBConnection = New OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Server.MapPath("miraflash.mdb")) DBConnection.Open() SQLString = "SELECT DISTINCT Position FROM applicant ORDER BY position" DBCommand = New OleDbCommand(SQLString, DBConnection) DBReader = DBCommand.ExecuteReader() While DBReader.Read() Dim MyButton as New Button MyButton.Text = DBReader("position") MyButton.CommandName = DBReader("position") MyButton.Width = Unit.Parse("100px") MyButton.Font.Size = FontUnit.Parse("8pt") AddHandler MyButton.Command, AddressOf Get_Books ButtonArea.Controls.Add(MyButton) Dim MyBlank As New Literal MyBlank.Text = "  " ButtonArea.Controls.Add(MyBlank) Counter += 1 If Counter Mod 3 = 0 Then Dim MyBreak As New Literal MyBreak.Text = "<br/>" ButtonArea.Controls.Add(MyBreak) End If End While DBReader.Close() DBConnection.Close() End Sub Sub Get_Books (Src as Object, Args As CommandEventArgs) Dim SQLString As String SQLString = "SELECT ID, Surname, Firstname, middlename FROM applicant " & _ "WHERE position = '" & Args.CommandName & "' " & _ "ORDER BY ID" BookSource.SelectCommand = SQLString End Sub

    ASP.NET debugging database graphics sysadmin data-structures

  • problem insertin into an access database using vb2005
    B busteronline

    <%@ page language="vb" runat="server" %> <%@ Import Namespace="System.Data"%> <%@ Import Namespace="System.Data.OleDb"%> <script runat=server> Sub Page_Load() If (Not IsPostBack) then LoadData() End If End Sub Sub LoadData() dim OurConnection as OleDbConnection dim OurCommand as OleDbCommand dim OurDataAdapter as OleDbDataAdapter dim OurDataSet as New DataSet() OurConnection = New OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Server.MapPath("./employee.mdb")) OurConnection.Open() OurCommand = New OleDbCommand("Select FirstName,LastName from Employees",OurConnection) OurDataAdapter = New OleDbDataAdapter(OurCommand) OurDataAdapter.Fill(OurDataSet, "Employees") OurDataGrid.DataSource=OurDataSet.Tables("Employees") UpdateEmployeeID.DataSource=OurDataSet.Tables("Employees") DeleteEmployeeID.DataSource=OurDataSet.Tables("Employees") DataBind() End Sub Sub UpdateSetup(sender As Object, e As System.EventArgs) UpdateSelect.Visible="False" UpdateTextBoxes.Visible="True" dim SelectedID as String = UpdateEmployeeID.SelectedItem.Value UpdateButton.CommandArgument = SelectedID dim OurConnection as OleDbConnection OurConnection = New OleDbConnection("Server=server;uid=newriders;pwd=password;database=Northwind") OurConnection.Open() dim OurCommand as OleDbCommand dim OurDataReader2 as OleDbDataReader OurCommand = New OleDbCommand("Select FirstName, LastName From Employees Where EmployeeID = " + SelectedID ,OurConnection) OurDataReader2 = OurCommand.ExecuteReader() OurDataReader2.Read() UpdateFirstName.Visible="True" UpdateLastName.Visible="True" UpdateFirstName.Text = OurDataReader2("FirstName") UpdateLastName.Text = OurDataReader2("LastName") OurConnection.Close() OurDataReader2.Close() LoadData() End Sub Sub UpdateReset(sender As Object, e As System.EventArgs) UpdateSelect.Visible="True" UpdateTextBoxes.Visible="False" LoadData() End Sub Sub InsertCommand(sender As Object, e As System.EventArgs) dim OurConnection as OleDbConnection OurConnection = New OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Server.MapPath("./employee.mdb")) dim OurCommand as OleDbCommand OurCommand = New OleDbCommand("Insert Into Employees

    ASP.NET database sysadmin tools help

  • i have this big bug on asp.net guest book ,pls help me out
    B busteronline

    hello there, pls am a newbie to asp.net, Sometimes ago i bought a book "The joy of dreamweaver" by paul newmann,a great book that taught me asp and php. he however supplied the asp.net code version of every project,recently i tried using the codes for asp.net guest book and it tthrew the followin errors,pls what can i do,or have i not done,kindly hep me as his bog at www.newmanzone.com/forum is currently under attack,thanks very much abiola it gave the following errors Server Error in '/' Application. -------------------------------------------------------------------------------- Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: File or assembly name DreamweaverCtrls, or one of its dependencies, was not found. Source Error: Line 1: <%@ Page Language="VB" ContentType="text/html" %> Line 2: <%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %> Line 3: Line 4: CommandText='<%# "SELECT * FROM Guestbook WHERE Active <>0 ORDER BY PostDate DESC" %>' Source File: c:\inetpub\wwwroot\guestbook\TMPx9u06nqd0.aspx Line: 2 Assembly Load Trace: The following information can be helpful to determine why the assembly 'DreamweaverCtrls' could not be loaded. === Pre-bind state information === LOG: DisplayName = DreamweaverCtrls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=836f606ede05d46a (Fully-specified) LOG: Appbase = file:///c:/inetpub/wwwroot LOG: Initial PrivatePath = bin Calling assembly : (Unknown). === LOG: Publisher policy file is not found. LOG: No redirect found in host configuration file (C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\aspnet.config). LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\config\machine.config. LOG: Post-policy reference: DreamweaverCtrls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=836f606ede05d46a LOG: Attempting download of new URL file:///C

    ASP.NET help asp-net learning csharp php
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups