Groups | Blog | Home
all groups > vb.net data > february 2006 >

vb.net data : Drag and Drop



Tim Ferguson
2/5/2006 10:25:03 AM
I may be doing something really stupid here, but I can't see what.

Using VB.Net 2005 Express Edition, with a form and a DataSet pointed to a
database on SQL Server Express; all the fields are visible in the Data
Sources window.

The form has a load of text boxes on it.

My book says I can click on the Data Sources window and drag a field onto a
text box on the form designer. But... whenever there is a form open in
design mode, the data sources window blanks out, with all the controls
inaccessible.

What gives?


Tim F


Morrigan
2/7/2006 12:43:11 PM
Hello,

I have tried to reproduce your problem, but it seems to work here.
I am working with VB.Net 2005 Team Edition, so i cant reproduce your
problem for 100 %.

Maybe it is possible that the Express Edition has limitations? and if
so, is your book assuming that you are working with a different
version?

With kind regards,

Morrigan
Tim Ferguson
2/8/2006 9:47:56 AM
"Morrigan" <nielsh@hollandridderkerk.nl> wrote in
news:1139344991.499317.282040@z14g2000cwz.googlegroups.com:

Thanks very much for responding.

[quoted text, click to view]

It certainly is... but I am more confused than ever. More experimentation
shows that:

a) I can use the wizard to create a new SQL 2005 Express database, and
the fields are draggable onto text boxes, just as advertised. I guess
this means that my set up is, after all, okay.

b) opening my original project, I now find that the data connection has
disappeared; and using the wizard to reconnect to the MDF file, it fails
saying that it cannot find the file (yes, it is there!) or the database
already exists (yes, it's the Northwind database and is already loaded).
Now I cannot even get the Dataset object into the Data Sources window. Is
there a way of attching to a SQL Server database, rather than to an MDF
file? Might I have done something to my SQL Server set up to affect this?

Thanks is advance


Tim F
AddThis Social Bookmark Button