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...
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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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?
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...
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.