Search results for query: *

Wondering how I do this. I have a SQL query that pulls three fields from the database. SELECT quarter, startdate, enddate from quarters this then populates a drop down box with the quarter. I want to put two labels next to the drop down and have the text of the two labels populate from the...

Wondering if anyone can tell me (a newbie) how to connect to a SQL database and pull fields and assign them to variables. A sample script would be sufficient. Here some sample data: Database Fields: LastName, FirstName, MiddleName Variables: varLastName, varFirstName, varMiddleName I...

Here is what I am trying to run SELECT quarter, startdate, enddate, requiredquarterhours AS quarter, startdate, enddate, requiredquarterhours FROM quarters WHERE quarter = DropDownList2.DataValueField I get an error stating that DropDownList2.DataValueField cannot be bound. I have also...

Sorry for the newbie question, but I am just getting started. I have a drop down list that I am trying to populate with data from two fields. If in the dataTextField, I populate lastname, the drop down works fine and populates the lastname field in the drop down. What I want is to do a...

Just learning Visual Basic . NET via Visual Studio 2003. Wondering if anyone has a suggestion for a complete reference book / manual and I can put on my shelf. Looking for a book with "Everything I ever wanted to know." not a book I would read cover to cover. Just want to look in it to find...

Wondering if anyone knows an easy way to generate thumbnail pics (jpeg or gif) from an HTML file. Prefer to be able to do this in bulk on a local machine. In other words, I have a directoy on my local drive with about 50 html files. If I click on one it will launch IE and show the web page in...

I am trying to create a macro to do the following on an Excel Spreadsheet On Page 2 would be a permanent list of two Columns Client ID Client Name On page 1 I would like to be able to type or paste a client ID in one column and then have it autopopulate the column after it with the...

ignorant question, but is there a way to automate the export of a table either via command line or via a query (SQL)? I currently have several queries in a macro. At the end of the macro, I would like to export a table in comma delimited format with the field names as the first record. thanks...

I have come up with the following Script (It does not work) INSERT INTO Table_1 ( item1, item2, item3, item4, condition_a, item5, item6 ) SELECT Table_2.item1, Table_2.item2, Table_2.item3, Table_2.item4, Table_2.condition_b, Table_2.item5, Table_2.item6 FROM Table_2; Where table_1.item1 =...

Need to truncate a field. Here is what I have: update PARTS set weight = substring(weight,1, charindex(' ',weight)) Original Field is : 5.36 lbs Need to make it: 5.36 Need this done throughout the table PARTS. Thanks Don