Search results for query: *

I have managed to code my website to display its HTML source or store it to a variable code on the fly. This version of the web page requires to be sent to an email recipient. Because the page has a couple of images it'd make the email bulky if I sent all the attachments neither will referencing...

I found it ! Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM chdetails WHERE (chname LIKE '%" & txtFRname.Text & "%') AND (chsurname LIKE '%" & txtFRsname.Text & "%') AND (chDOB = '" & txtFRdob.Text & "')", myConnection) instead of Dim da As OleDbDataAdapter = New...

Im having some trouble using the SQL Like command with multiple conditions where as the first line of code works with one condition the second one doesnt even thought it doesnt return any errors Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM chdetails WHERE chname LIKE '%" &...

sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Server.MapPath("/Register/db2.mdb") this has now been resolved

sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Server.MapPath("db2.mdb") My connection string looks as above. i have uploaded the site to the web server in a folder called Register. Register is in the root folder. However there is a folder called Search in which some aspx...

Sorry for late reply. This is the new code that works perfectly, well almost. The only problem I have left is when I do a search I cant search for anything else i.e. i'd have to close down and start again. Is there a way to close the connection and refresh when I search again? Imports...

I ended up with this code here, it does not produce any errors on run time but when i click the search button it does not do anything i.e. populate the gridview box with names starting with T Imports System.Data Imports System.Data.OleDb Partial Class _Default Inherits System.Web.UI.Page...

I copied the code exactly as above, and created a new website in VB2005 I have the text box, search button and gridview in asp.net.This is how the code looks now Imports System.Data Imports System.Data.OleDb Partial Class _Default Inherits System.Web.UI.Page Protected Sub...

i was hoping the ode above could be converted into that

I am trying to make an asp.net webpage that does exactly the same thing as my application. This application searches a database for all names beginnig with the letter T and populated a gridview. on trying to use the same code in asp it wont work. could i please have some help in converting it...

Im am getting the error above Value of type 'String' cannot be converted to 'System.Data.SqlClient.SqlConnection' when I try to execute the code to populate a GridView on the website with the query shown below. Any ideas why ? Imports System.Data Imports System.Data.SqlClient Partial Class...

Looking at my post you will see I am a newbie to Visual Studio 2005, I was just playing around with data access and a little project came to mind I have on my website GridView1, txtName and btnSearch on the web page I have a Microsoft Access Database called runnersdb it has a table called...

I am looking for sample code for the SQL LIKE commanf in VB.Net or ASP.net. I have an access database with user information and I want a piece of code that searches the db for a name the populates a datagrid/listbox/gridview. The command to search is easy enough I just havent found the code to...

Hie guys im new to VB.NET (ADODB.Net), i used to program in VB6 and things have changed with Adapters and Readers etc. I need help with updating, searching and inserting records in an access database. i.e. from the connection string to closing the connection. Situation; 2 labels on a form 3...

Dim objConn As New OleDbConnection _ ("Provider=Microsoft.Jet.OLEDB.4.0;" & _ "User ID=Admin;" & _ "Data Source=C:\ePlanet_files\Copy of Radio\db2.mdb") objConn.Open() Dim cmd As OleDbCommand cmd = New OleDbCommand...

hie guys, im having trouble with updating an access database. Here is my code below. userAns and QuesNo are fields in the database and userAns and ques are variables that I have declared and will get values from textboxes etc. For some reason the details are not being updated into the database...

hie guys, im having trouble with updating an access database. Here is my code below. userAns and QuesNo are fields in the database and userAns and ques are variables that I have declared and will get values from textboxes etc. For some reason the details are not being updated into the database...

this works wonders, i was going off all in the wrong direction. thanks for the explanation of the code and making sure I can adapt it for more. Thanks for showing me were I was going wrong.Thanks again.

<HTML> <head> <script LANGUAGE="JavaScript"> <!-- var timeperiod = 60 * 1 * 1; //minutes times seconds time milliseconds var now = new Date(); var event = new Date(now.getTime() + timeperiod); var seconds = (event - now) / 1000; var minutes = seconds / 60; var hours = minutes / 60; var days =...

sorry guys when i modified the date to var now = new Date("Mar 6 2007 08:00:00"); var event = new Date("Mar 6 2007 09:00:00"); and opened it in the browser it was not counting down and the explorer freezes. Is there anyway I could make it always countdown lets say an hour or 2