Search results for query: *

Hi How can i validate a textbox based on a radio button. Let says I have two radio buttons in a form : Invoice Paper and E-Bill If the user select E-Bill I want to make sure the email textbox is not empty, otherwise it does not matter. I need to do that on the submit button. I am working with...

Hi I use a SP to create a text file using FSO. I need to add extra spaces at the end of each line. When I look in the file, the extra spaces are not there. For example: SET @Data = 'ABC' SET @Data = @Data + SPACE(5) EXECUTE @RetCode = sp_OAMethod @FileHandle,'WRITELINE', NULL, @Data it will...

Hi, I am trying to save images in an sql table and then use it on a CrystalReport. Here is the code I am using. The system gives me an error : Incorrect syntax near 'sp_sp_InsertImage' I double checked my parameters and field. I am pretty sure it is the way I call the SP... could anyone help...

Hi, I have a SP that takes the content of a table and export it in a text file using FSO. I noticed that the variable is trimmed by the WRITELINE method. For example if I have a value ABC followed by 5 spaces, the spaces are dropped in the file. The only way to keep the spaces is to add a bogus...

Hi I use to be able to do summary fileds (sum, count...) in the page footer in Crystal Report 10. I try to do the same a VB.net program, and the only place the integrated Crystal Report let me put summaries are in the group footers or the report footer... How can I set a sum field in the page...

Hi, I need to show a description of an operation in a label while an SQL DTS and stored proc are launched. The SQL part works fine, but my label do not show the text. In VB6 this problem can be worked around by using REFRESH of DOEVENTS. How can I reach the same in .NET. Below is part of the...

Hi, I created a DTS in SQL that gets an Excel file and imports it in a table. The file source path and name may change, since multiple users will upload it through an Intranet site. I searched a way to dynamically set the source and filename using a Gloabal variable in the DTS and sevral...

Hi, I need some help to create a multi-language 'sitemap-menu' for my Intranet site. How can I change the menu lable based on the language selection (session variable). Here is my Sitemap for the site (in French). I know i cannot have two node pointing to the same page... so i am not sure how...

Hi, I wonder if it is possible to change the parameter order from the Report to reflect any changes made in the stored proc. I have a report based on a stored proc using 3 parameters for example sp_MySp A, B, C I created the report. But now I added an extra parameters to the stored proc...

Is it possible to embed the credentials for the LogOn in the report itself? I am using an SQL Login and Password to connect the SQL server, but this report will reside on our Intranet, so I would like to embed the credential so the user can open the report without having to input the password...

Hi, I am trying to extract the selected information from a listbox and I can't get what I want. For a test, I tried this: For iCount = 0 To lstEmail.Items.Count - 1 If lstTest.GetSelected(iCount) = True Then MsgBox(lstTest.SelectedItem.ToString) End If Next I select one record...

I would like to fire some queries that will do either an INSERT or an UPDATE in an Access 2003 DB (not password protected). I am using some code that I found on the net (CreateOleDbCommand). I runs without any errors, but noting is changed in the DB. Here is that part of the code I wrote: ...

Hi, I have a couple of labels, textboxes as a dropdown control in a repeater container. I was able to get the label values, but i have hard time to figure out how to determine which button was used (i got 3 edit, delete and add). Here is what I have Protected Sub...

Hi, I am learning ASP.NET. To do so, I am developping a small Forum site with Microsoft Access table (as I said it is for learning and it is small). My database is desing and most of my forms. I am exploring the best way to display a post and its reply. I'd like to have an opinion(my code is...

Hi, I pull some information from an Access database, the text is in French, so there is accents in the string. If I display the fields content in a datalist directly bound to an AccessDataSource all the strings are fine. I am constructing a screen that I will use to update my news. When I...

Hi, I am fairly new to the XML world. I will received XML files through a Web Service and there will be embedded images in the files. I was able to import the XML into Microsoft Access (no schema was provided, so the proper table and fields will be created) and then Import the tables in SQL...

I created a master page with two ContentPlaceHolder, one for my menu and one for the page to show based on the menu selection. I was able to load the menu, but when I select an option, I load the 'choice' page in the second container but my left one disapear... Do I have to refill all the...

I am trying to create a either ASPX or HTML page with 2 vertical frame, so I can load 2 different pages, but regular <Frameset></Frameset> tags is not supported anymore by XHTML... Is there anoter way for me to achieve what I need? Thanks Mal'chik [bigglasses]

Hi, I am an experienced VB6 developer and I am learning ASP.NET/VB.NET. I am building a Web search interface for our Intranet and I would like to know how to load another ASP page from the code. I have a Login page linked to an SQL database to authentify the user when the button 'cmdLogin' is...

Hi, I need to find a way to edit by VB6 the file summary properties (when you right-click on a file in Windows Explorer) not the file date or attribute, but rather the keywords, author, comments...(the properties change based of the file type) I know there is DSOFile, but this is limited to...