Howdy!

I am currently using ASP.NET 4 this semester and I love it! I am doing different projects with the guide of the book now. I am having a bit of trouble using SQL with Visual Studio Web Development. I can use the files that came along with the book but now I am trying to create my own table. I have a premade table in Excel that consists of ProductID, ProductName, SupplierID, SupplierName, unit price, QuantityPerUnit (ex "12 - 200 ml jars"), etc.

When I try to copy and paste into a table I created in the Data Connections under the Server Explorer, it wouldn't let me copy the data. Eventually I had to to set all the values to "Allow Nulls" which allowed me to copy all the data except the Unit Price.

I have UnitPrice as "Allow Nulls" and the datatype set as "Decimal (19, 4)". Is this incorrect?
Also is having the other ColumnNames set to "Allow Nulls" the best thing to do?


Any help is greatly appreciated! The first time I've ever used SQL is with this book.

Hi there,

Thanks! Good to hear.

Copying from Excel is always tricky, as Excel doesn't support true data types as SQL Server does.

I would either manually add the data if it's not too much, or use the SQL Server Import Wizard (requires a commercial version of SQL Server) or Integration Services to import the data. Alternatively you could save the data as CSV and import it pogrammatically.

All of these solutions are beyond the scope of the book and thus this forum category, so you may be better off posting a question in another forum cateogry, succh as one dealing with SQL Server or with (ASP).NET in general.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!