visual studio setup proje - Page 332

A Byte Array with all 0x00 is Equaled to 0x08?

- by Ngu Soon Hui

I think I encountered something extraordinary strange in VS 2008. All the array values are 0x00, but why it is displayed 0x00000008 at the start of the variable?

Getting a Specified Cast is not valid while importing data from Excel using Linq to SQL

This is my second post. After learning from my first post how fantastic is to use Linq to SQL, I wanted to try to import data from a Excel sheet into my SQL database. First My Excel Sheet: it contains 4 columns namely ItemNo ItemSize ItemPrice UnitsSold I have a created a database table with the following fields table name ProductsSold Id int not null identity --with auto increment set to true ItemNo VarChar(10) not null ItemSize VarChar(4) not null ItemPrice Decimal(18,2) not null UnitsSold int not null Now I created a dal.dbml file based on my database and I am trying to import the data from excel sheet to db table using the code below. Everything is happening on click of a button. private const string forecast_query = "SELECT ItemNo, ItemSize, ItemPrice, UnitsSold FROM [Sheet1$]"; protected void btnUpload_Click(object sender, EventArgs e) { var importer = new LinqSqlModelImporter(); if (fileUpload.HasFile) { var uploadFile = new UploadFile(fileUpload.FileName); try { fileUpload.SaveAs(uploadFile.SavePath); if(File.Exists(uploadFile.SavePath)) { importer.SourceConnectionString = uploadFile.GetOleDbConnectionString(); importer.Import(forecast_query); gvDisplay.DataBind(); pnDisplay.Visible = true; } } catch (Exception ex) { Response.Write(ex.Source.ToString()); lblInfo.Text = ex.Message; } finally { uploadFile.DeleteFileNoException(); } } } // Now here is the code for LinqSqlModelImporter public class LinqSqlModelImporter : SqlImporter { public override void Import(string query) { // importing data using oledb command and inserting into db using LINQ to SQL using (var context = new WSDALDataContext()) { using (var myConnection = new OleDbConnection(base.SourceConnectionString)) using (var myCommand = new OleDbCommand(query, myConnection)) { myConnection.Open(); var myReader = myCommand.ExecuteReader(); while (myReader.Read()) { context.ProductsSolds.InsertOnSubmit(new ProductsSold() { ItemNo = myReader.GetString(0), ItemSize = myReader.GetString(1), ItemPrice = myReader.GetDecimal(2), UnitsSold = myReader.GetInt32(3) }); } } context.SubmitChanges(); } } } can someone please tell me where am I making the error or if I am missing something, but this is driving me nuts. When I debugged I am getting this error when casting from a number the value must be a number less than infinity I really appreciate it

Search Results

Search found 30701 results on 1229 pages for 'visual studio setup proje'.

Page 332/1229 | < Previous Page | 328 329 330 331 332 333 334 335 336 337 338 339 | Next Page >

- by Ngu Soon Hui

- by niceoneishere

- by Mr. Goo

- by Abhilash Muthuraj

- by Sravan

- by Patricker

- by Adam Haile

- by Yochai Timmer

- by mikeinmadison

- by MNC

- by user63898

- by Shahzaib

- by spoon16

- by apollo-creed

- by SA

- by Mick

- by Jim

- by Phsika

- by baron

- by jasonk

- by Urbycoz

- by Bubby4j

- by lajoo

- by Bruce Adams

- by gerryLowry

< Previous Page | 328 329 330 331 332 333 334 335 336 337 338 339 | Next Page >