Search results for query: *

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

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?

...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 files(*.mdf)require SQL Express 2005 to work properly" Is it not possible to use this wizard with SQL2000?? Please help as this is causing a major...

...only want to select the 1st 3 columns from that datagrid and want the value from the textbox. Then finally use the value from the 3rd column and * it by txtAmount to give a final result in grdItems. So the grid would have 5 columns of data. Can anyone help me out on this one or point me...

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 RTaulbee, Thats the strange thing I don't have condition in any of the tables....

...FROM tblQuotes WHERE tblQuotes.CustomerID = '10' ", conn) Dim daOrders As New SqlClient.SqlDataAdapter("SELECT * from tblOrders WHERE condition = '" & txtCustomerID.Text & "'", conn) Dim daPayments As New SqlClient.SqlDataAdapter("SELECT tblPayments.PaymentID FROM tblPayments", conn) 'Dim...

...As New SqlClient.SqlDataAdapter("SELECT tblPayments.PaymentID FROM tblPayments", conn) Dim daOrders As New SqlClient.SqlDataAdapter("SELECT * from tblOrders", conn) daOrders.Fill(ds, "tblOrders") daQuotes.Fill(ds, "tblQuotes") daPayments.Fill(ds...

...& _ "; Database = ActionGlass; " & _ "Integrated Security = sspi;") Dim ds AsNew DataSet Dim daOrders AsNew SqlClient.SqlDataAdapter("Select * from tblQuotes", conn) Dim daQuotes AsNew SqlClient.SqlDataAdapter("Select * from tblQuotes", conn) Dim daPayments AsNew...

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

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

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

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!!