Thanks Navaneeth.

Welcome :) Regards, Satips.:rose:

Try this way.. private void GetData() { try { if(FileName.Text.EndsWith("xls")) { string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ FileName.Text + ";Extended Properties=Excel 8.0;"; DataSet bulkData=new DataSet() ; OleDbDataAdapter adap = new OleDbDataAdapter("SELECT [Postal/Kommune], HouseType, KommuneNumber, PostalCode, StreetCode, HouseNumber, Floor, SideDoorNumber FROM [" + SheetName.Text + "$]", connection); adap.Fill(bulkData); if(bulkData!=null) if(bulkData.Tables[0].Rows.Count>0) { BulkPropertyBLL bulkpropertyBll = new BulkPropertyBLL(); for(int i=0;i Regards, Sylvester G sylvester_g_m@yahoo.com

It is showing error like this NullReferenceException: Object reference not set to an instance of an object. at Details.DetailsView1_ItemDeleting(Object sender, DetailsViewDeleteEventArgs e)

Thanks, I am doing in Asp.net/c#.

Hi, Here u r pushing text of the cell. If u want to take value from the textbox then you should find textbox in the cell and then take its text property and insert it in to the table. Thanks and Regards, Chetan Ranpariya

Nope. You can't do that .. You need to format details view like table format .. Try to add table tag inside details view using templatefield or ItemTemplate. Harini

Thanks. I want this inside edit template. Can it possible.

hi, try the following: dim i as integer = iif(textbox1.Text="",0,textbox1.Text) please note that it will not check if it is of type integer or not, for that you can use validators. regards :)

Thanks.

Thanks a million. It is working hurray

Thanks

Thanks, Nice Site

Another option would be to store a default date which is meaningless but avoids a null value in the DB (something I try to avoid if at all possible). e.g 01/01/1900

A kamath wrote: But my problem is if the value is not there I have to add it during runtime. You can check the dropdown item count after binding the data. If it is 0 then add items manually printf("Navaneeth!!") www.w3hearts.com

Thanks

Thanks

Hi, Better you check for the proper formatstring on the google. Thanks and Regards, Chetan Ranpariya

OK....now a quick google would've told you this, but use overflow-x and overflow-y "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox

You can also get today's date by Now.ToString("dd-MMM-yy") Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group