Search results

  1. M

    Datagrid sorting problem

    Hello, I have setup sorting on my datagrid. However, all columns of the datagrid sort fine except the buttoncolumn of the grid. The button is there to show users more information for the clicked row, however, because it does not sort along with the rest of the datagrid, it shows the incorrect...
  2. M

    Finding last row in the dataset

    Hello, I wish to have a loop that looks through each row in the dataset and compares the values to that in a textbox. To do this, i need to tell the loop to keep going until it reaches the last row of the dataset. How do I specify in my code the position of the last row of a dataset...
  3. M

    Database Connection String

    Hello, I have around 10 webforms that all use the same connection string. In the code-behind of each web-form i declare and define this connection string. Rather than do it 10+ times, how do i define the connection string once, and have all may webforms refer to this? Help much appreciated!
  4. M

    Dropdown list

    Hello, I have a dropdownlist and from it i wish to extract the currently selected item and store it in a variable as an integer so i can use it in an sql query. for example, the ddl may have items; 1, 2, 3. if i select 2 from the dropdownlist i want to be able to store the value 2 in the...
  5. M

    SelectedItem property of dropdownlists...

    Hello, Please can someone help! I have a textbox and a dropdownlist. The text in the textbox also features as an item in my dropdownlist. What i want to achieve is when i click a button, the dropdownlist loads with data but rather than dispay the first item in the dropdownlist at index 0...
  6. M

    &nbsp problem

    Hi, wondering if anyone can help, I have a textbox (productkey) that gets its information from a cell in a datagrid. Some cells are blank and do not have any data and others have data. When I click on the more buttoncolumn on may datagrid on a row that has something under productkey i am...
  7. M

    &nbsp problem

    Hi, wondering if anyone can help, I have a textbox (productkey) that gets its information from a cell in a datagrid. Some cells are blank and do not have any data and others have data. When I click on the more buttoncolumn on may datagrid on a row that has something under productkey i am...
  8. M

    Datagrid Button Events

    Hi, I am trying to achieve the following: I have a dataset which has quite alot of info so i am binding only certain information to the datagrid and have added a more button in the datagrid. When the user clicks the more button the user should now see a new form. This form should now show...
  9. M

    Updating records

    Hello, I have a simple webform that allows users to navigate through the items in a database. The item is displayed via a single textbox and the user clicks on next, previous, first and last buttons to navigate. I also have an update record button that should allow the user to navigate to a...
  10. M

    Validation controls

    Hello, I have a web-form that acts as a data-entry form to insert a new record into an access database. The form uses required field validators to make sure something is entered or selected into the controls (textboxs and dropdownlists). The problem is it is conflicting with my current reset...
  11. M

    Handling exceptions

    Hello, I have a simple data entry webform that is used to add records toa database. Some of the controls are linked to fields in the database that always require a value, others do not. I also have a submit button that when clicked add the record to the database with the entered and...
  12. M

    Adding Records to an access table via parameters

    I am attempring to write an insert statement to add records to an access database table. I do not want to define the values that will be added to the database in the query and wish to use parameters. I am a little confused as to how to do this: So far I have got: Dim addsoft As String = "...
  13. M

    Insert statements and parameters

    I am attempring to write an insert statement to add records to an access database table. I do not want to define the values that will be added to the database in the query and wish to use parameters. I am a little confused as to how to do this: So far I have got: Dim addsoft AsString = "...
  14. M

    Datagrid dependent on dropdownlist selection

    Hi. I have a drop down list which displays vendors. Based on what vendor the user selects, a datagrid should show records of the specified vendor. e.g, user select Microsoft so info for all Microsoft software is returned in the datagrid. I have tried doing this and the form compiles but does...
  15. M

    combobox and datagrid

    Hi, I have a combo-box called vendor, with items such as microsoft, adobe, macromedia etc etc. When i select a vendor from the list i want to see records in the software table for only the selected vendor in a datagrid format. For example, I select Microsoft, then in my datagrid should...
  16. M

    OleDbConnection problems

    Please help, I have declared variables to create the database connection and dataset and dataadapter in the form declaration. I am then trying to define the database connection and open it so that i can use the dataadapter to fill the dataset. Here is my code: Public Class Form1 Inherits...
  17. M

    oleDBCommand and SQL syntax

    Hello, I am very new to VB.Net and ADO and am trying to write an SQL select statement with joins. However, the syntax that i am using is not correct. This is what i require: "SELECT GKLS_Software.Application, Software_Type.SoftwareType, Vendors.Vendor, GKLS_Software.ProductKey FROM...
Top Bottom