Hi Phil, My scenario is I have a data grid with the field Date set to Date/Time format. I have created a drop down list outside and hardcode drop down list into the drop down e.g 1 day, 2 day,3day. I am not sure how I could grab the value of the selected drop down list item and update it in the Date field with its DD/MM/YYYY format. The procedure you provided me could not hint me more to solving the problem.Sorry as I m still a beginner and am using ASPX but using VB.NET code. Please advise or provide any suggestions to this.Thanks. Jason

I am using Access database and I have a date field which is in format of DD/MM/YYYY. In my drop down list I have enabled items like 1 day, 2 day ,3days and etc. I would like to know how to convert the drop down list selection day and update the date of dB field? E.g User select from drop down list :- 2 days Current date is 03/05/2006 So the expected return date field in dB its 03/05/2006 + 2 days. FYI, I am using VB code with ASPX using ASP 2.0 WEB MATRIX. Please advise.Thanks Jason

Hi there, Currently I am creating an application for a library system where I have a field which is Available in my database.I am creating a web system using ASP.NET using VB code.It is a Text type and I decided to have it either Yes or No for the value.I am using Access database for your info. I also have a text box where user can just key in the serial code of the book to borrow from data grid generated. While I am using ASP.NET Web Matrix and I am quite new to the ASP.NET, I resorted to use the Update Wizard for performing the update data by the user from the text box. I have tried to grab user's value in the text box (which is the serial code) and update the Available field on the dB.However, after modify some code from the wizard, I couldnt get it workable.And there are many errors. Below are the code after generating the wizard for Update data :- Function Test(ByVal serialNumber As String, ByVal available='No' As String) As Integer Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Inetpub\wwwr"& _ "oot\db\equipment.mdb" Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString) Dim queryString As String = "UPDATE [portable] SET [Available] =@Available='No' WHERE ([portable].[SerialNumber"& _ "] = @SerialNumber)" Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand dbCommand.CommandText = queryString dbCommand.Connection = dbConnection Dim dbParam_serialNumber As System.Data.IDataParameter = New System.Data.OleDb.OleDbParameter dbParam_serialNumber.ParameterName = "@SerialNumber" dbParam_serialNumber.Value = serialNumber dbParam_serialNumber.DbType = System.Data.DbType.[String] dbCommand.Parameters.Add(dbParam_serialNumber) Dim dbParam_available='No' As System.Data.IDataParameter = New System.Data.OleDb.OleDbParameter dbParam_available='No'.ParameterName = "@Available='No'" dbParam_available='No'.Value = available='No' dbParam_available='No'.DbType = System.Data.DbType.[String] dbCommand.Parameters.Add(dbParam_available='No') Dim rowsAffected As Integer = 0 dbConnection.Open Try rowsAffected = dbCommand.ExecuteNonQuery Finally dbConnection.Close End Try Return rowsA

Hi... I still get the same error even i have changed the above file name. :( Please help.. Lee

Hello there, I was trying to upload my finished ASP.NET pages up to the server in http://www50.brinkster.com/dmt/DecisionMakingTool/MainForm.aspx. However the error shown below show up:- Server Error in '/' Application. -------------------------------------------------------------------------------- Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off". Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL. I have also tried to find from Google and found not much solution to this so far..Please help... Thanks in advance, Lee

Hello there, Recently I have been developing Java Applet program. And I am trying to use HTML to design the main page. What I am in doubt is I have a ENTER button. When user press on the ENTER button, the developed Java Applet will be loaded. However, I dont know what code or line of stuff i need to do to make the above scenario happened. For your information I am using Front Page to create the HTML page and JCreator to do the Applet Program. Please help! Thanks, Lee

Not really but the idea is around there. I even created the consummation of google web service..now what I am considering is the defined attribute value( in my case;car brand,the year car produced..) that needed to mine from these web sites found in Google web service into the database.So, user will traight away access the database to retrieve the attributes value. Thanks, Lee

Hey.. I ve gone to the web site.However,it seems does not help to illustrate the problem I faced here. I will give a clear picture here:- I have developed a decision making tool.I need attributes like car price,car brand,car engine..etc.User might not know what the attributes when they wanted to buy a car.So my system would like to have web mine some pages to find these attributes and return to the created dB automatically.User just need to access to the database for those values directly. How would this possibly done in this case? Regards, Lee

Hello there, I would like to know is there any existing free tool available for mining the data of various web page so that to store in dB.It will eventually update the dB so the user can review the values of the dB directly especially real time data. Please help clarify my doubts..thanks! Rgrds, Lee

Hello ... I am currently trying to implement login page using MFC. I intend to pop up message box on loading the application for the user to key in login and password.At the same time, I am facing problem in getting user login and password to compare with the authorized login and password stored in a table in access.Can anyone help me to clarify this doubt or you have any samples online pertaining this.I have treid to find from MSDN but I cant find the example/sample that I meant above. Thanks in advance, lee

Hey... I have an MFC application where I have added the first recordset for the application.Now I face problem in adding second recordset for the MFC which means to create new class for retrieving the variables from other database table.I have tried to follow the MSDN links and tutorial on this but as I follow the steps,I faced problem in creating new class.For example I tried to create new class CSubjectSet but it return the error which states file SubjectSet.cpp and CSubjectSet.h does not exist. Please help if you encountered this problem before or known the cause of this problem. Thanks, Lee

Hey.. Apart from the problem above,I also faced the problem of transferring all the google results into a table.I tried to create a table with one row which consist of 3 columns(Title,URL and Summary)for the results but I faced difficulty in accessing and retrieving these values to be put in the table columns separately. Any suggestion or any samples that uses this features? Please help! Thanks, Lee

Hey there... I have used the code project reference as an example for my google search..however the below error comes out when i press Search button. Exception while handling service request: com.google.soap.search.GoogleSearchService.doGoogleSearch(java.lang.String,int,int,boolean,java.lang.String,boolean,java.lang.String,java.lang.String,java.lang.String) -- no signature match 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.Web.Services.Protocols.SoapException: Exception while handling service request: com.google.soap.search.GoogleSearchService.doGoogleSearch(java.lang.String,int,int,boolean,java.lang.String,boolean,java.lang.String,java.lang.String,java.lang.String) -- no signature match Source Error: Line 84: public GoogleSearchResult doGoogleSearch(string key, string q, int start, int maxResults, bool filter, string restrict, bool safeSearch, string lr, string ie, string oe) { Line 85: Line 86: object[] results = this.Invoke("doGoogleSearch", new object[] { Line 87: key, Line 88: q, The error is it to be said originated from the Reference.cs which is already built in when we install Google API. I am stuck here several times and try to figure out the reason..but of no avail.Please clarify my doubts and i need help! Thanks in advance, Lee

Hi there..thanks for the fast reply.. Anyway I have previously browse through the example from the 4guysfromrolla before asking. From the example, I have tried to follow the steps but somehow I face problem in converting the VB script to C#(which I am using).I have also tried to find some other examples but mostly are in VB.I tried very hard to understand the code..moreover I am still new to VB.So it is hard for me to comprehend what is happening btw the lines in VB.Any suggestion that perhaps have C# code running in the Google Search?Or is that the code is the same as VB but the differences is only on the declaration part? Please clarify my doubt..sorry for the trouble.. Thanks, Lee

Hey.. I have a problem in finding way to implement Google Search in a Web Application.For example I am doing a web based system and would like to consume the Google Search for user to find relevant information.At the same time I would like to have the information to be displayed on List View(which I can only find available in Windows Form).Can anyone provide any solution or hint to me in solving this problem? I have tried to find most of the examples are in Windows Form consuming the Search. Thanks in advance, Lee

Hi there.. I faced a problem of coding tokenizer in one of the textbox for user input in ASPx web application.I have tried to search from internet and found most of them are in C# with whole complete classes.Please help to clarify my doubts on this as soon as possible. Thanks!

Yea..I have tried and it only works in C# form but what I face the problem of delimiter lies in Web Application Form in C# Project Folder..(fyi, I am trying to put my C# application into Web Based) I have tried to code the particular text box for the delimiter but it doesnt have SelectionStart function in Web Application.Thus, I used the previous code as below:- private void TextBox3_TextChanged(object sender, System.EventArgs e){ string delimiter =";"; if (TextBox3.Text.EndsWith(" ")) { TextBox3.Text += ";"; TextBox3.Text=TextBox3.Text.Repla ce(" ", delimiter); } } With this code, I face another problem which is when i enter the input then";" doesnt come up automatically..it only comes up occasionally especially after I let the Validation Error appear in other textbox. Please help me to clarify this doubt..I am stuck nowhere. Thanks, Lee

Thanks Jesse..it really helps me! Anyway I have another question, if I have done a C#.NET application and would like to be put on WEB using ASP.net.So should it be adding Web Application instead of Web Services right?Correct me if im wrong..if its WEB APPLICATION, how can I transform the existing C# application into a web based application .Please give me some guidance and possible samples for the above scenario if available.I would really appreciate for the aid..thanks in advance, Regards, Lee

"Visual Studio.NET has detected that the specified Web Server is not running ASP.net Version 1.1. You will be unable to run ASP.NET Web Applications or services" When I added new project of ASP.NET WEB APPLICATION OR WEB SERVICES under Visual C# Projects,I have this message.What is happening? For your information, I have installed Windows XP Home Edition Sp1. I have used Windows 2000 Professional to retrieve IIS dll and inf files to install IIS component in XP Home Edition. Based on the error i get above,is it that the currently IIS version(IIS 5.0) does not support ASP.NET version 1.1? How can i solve this problem after all I have come to so close to implementation of ASP.NET using IIS in XP Home Edition. Please clarify my doubts the soonest possible..really need your help urgent. Thanks in advance, Lee

The above line provided does make sense..but how am i going to check if user key in space (" ") in the particular text box, the ";" will be replace onto it and the pointer for next word is after the symbol ";"? Thanks in advance, Lee