Search results for query: *

  1. D

    Use 2 datagridviews togeather

    Thanks for moving this I didn't see this forum. I might not have explained what im trying to do clearly enough. I am just moving over from access & VBA so its a big learning curve. I don't know if I am thinking down the right part with what im trying to do but I am really hoping someone...
  2. D

    Cant connect to an SQL database with vb express

    How I tried connecting was by right clicking on my project and adding a new project. Then database Thats when I get the error. What do I need to do?
  3. D

    Cant connect to an SQL database with vb express

    Hi there, I am having some problems trying to add a database to a vb express project. I am running sql 2000 but for some reason it only wants to connect to a 2005 express database. I have tried adding a new database but I get an error message telling me "Connections to SQL server...
  4. D

    Use 2 datagridviews togeather

    Hi there I am in desperate need of some help. I have made a form that I want to use to make orders. There are 2 datagrids (grdItems & grdSearchItems ) a textbox (txtAmount) and a command button. What I am trying to do is select a row from grdSearchItems I only want to select the 1st 3...
  5. D

    Add a total value to a txtbox

    Hi there I need some advise with a small task I am trying to achieve. I have a form called frmCustomers. On the form there are 2 datagrids (grdOrders & grdPayments) I also have a textbox called txtCurrentBalance. What I would like to do is to be able to display a customers current balance...
  6. D

    Using a textbox as a WHERE condition

    Hi cjard, I dont have a dataset set up on the application. I am running vb express and have an SQL 2000 server. I have not been able to connect to an SQL database as I have problems with adding a new datasource as the wizard always creates a wrong connection string as it thinks I only have...
  7. D

    Using a textbox as a WHERE condition

    Sorry I should have picked that up. Feel a little stupid now. The form loads up ok now but there are no results within the datagridview. Thanks for helping me out on this one.
  8. D

    Using a textbox as a WHERE condition

    Hi RTaulbee, Thats the strange thing I don't have condition in any of the tables....
  9. D

    Using a textbox as a WHERE condition

    Hi fpineda101 I tried your line of code but it didn't work for me. I have the aboce code in the forms loading code. I moved the following 2 lines as they are used to bind data to some textboxes within the form. I code now looks like this. Private Sub frmCustomers_Load(ByVal sender As...
  10. D

    Using a textbox as a WHERE condition

    Hi there I am sure this is really easy but I have a form that contains a number of textboxes and also a datagrid. I have a textbox on the form called txtCustomerID which displays the primary key for tblCustomers and also I have another table called tblQuotes which has CustomerID as a FK...
  11. D

    Problems displaying data on 3 datagrids

    Hi there, I have managed to find a piece of code that allows me to display 3 datagrids. It works ok when using the northwind example but when I try using my own database I can only display 2 out of the 3 datagrids. For testing purposes I have used the same table for all 3 grids. Has...
  12. D

    Pass values from one form to another

    Thank you.... Still getting my head round vb.
  13. D

    Pass values from one form to another

    Hi there, I am using vb express 2005. I have built a form that contains customer details and have also built a form for orders (frmCustomers & frmOrders) I have added a button on the customer form to ADD an new order. The frmOrder is then opened. My question is how do I take the...
  14. D

    Help needed using a datagrid to show customer orders

    Good afternoon. I am hoping someone can help me out with a problem that I cant fix on my own. I have created a form that contains customer details. I have also added a datagrid that I want to be able to view all the customer orders. I am using an sql database with the following tables...
  15. D

    Using datasource wizard with vb express & SQL 2000

    Hi there I am trying to use the wizard to setup a datasource between an sql database using vb express. I am not able to do so and its due to the connection string that the wizard is creating. Is the string its creating but I am not using sqlexpress. How can I can the wizard to work...
  16. D

    Trying to INSERT values into a SQL database

    Thank you This is my script if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tblOrders_tblCustomers]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tblOrders] DROP CONSTRAINT FK_tblOrders_tblCustomers GO if exists (select * from dbo.sysobjects...
  17. D

    Make Panels corners rounded

    Hi there I am very new to vb.net and have just installed the express version. I have created a form and I want to round the corners on a panel for a better visual look. How do I do this? or should I be using another control?
  18. D

    Trying to INSERT values into a SQL database

    Hi Luke, I am totally lost on this. I don't have a dataset setup do I need to? The form opens up ok and I can select the records that are currently in the database but its when I press a button to add a record back into the database thats when I get the above message. Why is it that I...
  19. D

    Trying to INSERT values into a SQL database

    Hi there Sorry to sound stupid but I am very new. How do I provide you with my tables script?
  20. D

    Trying to INSERT values into a SQL database

    Hi there I am not 100% sure what I need to attach so people can view so I have added the 2 files that belong to the form. Any help would be great!!
Back
Top