I have a 20 digit numeric field that I want to convert to a string but when I use the str command to put it into a character field it converts it to scientific format. Does anyone know of a string function that will avoid this problem?
I have two tables in an access database I need to select records in table1 based on information in table2. Table1 has a common field in table2. I want to get all the records in table1 that match table2.id2 when table1.id = table2.id
See example below.
table1
id first last
talbe2
id id2
Can someone tell me if there is an easy way to have two textboxes on a aspx page and have the ability to drag the text from one box to the other? I am new to both aspx so please keep that in mine. Thanks.
I have a database on my default website that has a virtual directory that has a database in it. I use oledb to connect to the database but I use that actual path and it works fine. Can someone tell me how to correctly reference the virtual directory in the connection string?
I have a database on my default website that has a virtual directory that has a database in it. I use oledb to connect to the database but I use that actual path and it works fine. Can someone tell me how to correctly reference the virtual directory in the connection string?
I imported an aspx page using "add existing item" but once the page is in my project the code behind page does not recognize the controls that are on the page.
I have a datagrid being populated with data from a file and one of the columns is a hyperlink that I want to populate with one of the fields that is a path to a file to download but I can not seem to figure out where I put the code within the datagrid control. I am assuming one of the properties...
I am trying to get the column headings from an excel file using the oledb data provider the problems is once I insert the "HDR=NO" into the string I get an "ISAM error" if I take it out everything is fine but I do not get the column headings.
Can someone tell me how I can open a visual foxpro file using a oledb data provider but then be able to output a new file in the 2x format? I have to accomodate some old software the can only handle the 2x format. Any help would be appreciated. I can open the visual foxpro file with no problem...
I am new to vb.net and vs 2008 so here is my problem. I have a foxpro free table that I read into a dataset then I do some manipulation of the data. What I can not figure out is how to write out to a new foxpro file with some extra fields added to it. I know I can do a "create table" but how...
I am trying to update a foxpro table but the da.update(ds,"sample") fails with an error about not being valid. Can someone tell me what I am doing wrong. I am new to this programming environment.I know the dataset gets fill with the foxpro table data and the dataset changes to the new...
Does anyone have a suggestion on and automated barcode reading system? I need to be able to scan thousands of barcodes off of printed material like a coupon. I am looking for something that I can feed the material in bulk and have the barcodes scanned. Any help would be much appreciated.
I have a several check boxes in a grid and for some reason one of them does not display the check mark until it has focus but the others show the check mark whether they have focus or not. I have compared all three check boxes and they appear to have the same setting. I want all three to display...
I have a grid that has a combo box in one column and I am trying to have each record that is displayed in the grid to display the fields from a table who's name is in another text box in the grid. I am able to populate the combo box but the information that is displayed is from the text box of...
I have a grid that I want to have the first row in green and all other rows in red. the problem is the gird is filled with filtered records so I never know what record number is being displayed in the first row. Does someone have an idea how to make the first row always green no matter what...
Can someone remind me how to add a combo box to a grid? I am using the designer but certain fields that I put on the grid don't offer a combo box as a choice.
I am trying to access the dragdrop method of a column within a grid so I can trigger a process the problem is the grid and its columns are created at runtime once a database is picked. Any help would be much appreciated.
I am receiving the error message
"ADODB.Connection(0x800a0BB9)
arguments are of the wrong type , are out of acceptable range, or are in conflict with one another" but the same ASP code works perfect on my other server. I am attempting to connect to a MS ACCESS database when this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.