Thank you guys... I did what Luc said and it worked.

kallileo wrote: Is it possible to read a specific cell or a range of cells from a spreadsheet document? Yes. How depends on which version of Excel you need to work with.[^] led mike

Found it.. The problem was that after the Merge none of the rows in data table had the state RowState Changed or Added. The update methon had nothing to apply. This peace of code made the whole class work as it should: foreach (DataRow row in ds1.Tables["db2_table1"].Rows) row.SetAdded(); Thanks

Check the AutoSizeMode property of your DataGridView. You may have set some column(s) to expand the column width to fit the data. Depending on what data you have there (or actually you don't have :-)), you will get that kind of error if the lookup is turned on. SkyWalker

Hi Guy I seen your code in above. i seen may be ur combobox haven't a selected value may be pass null value, so error will raise. and second may be comboBox haven't records. so verify both condition after get comboBox1.SelectedItem. when directly to use comboBox value we must do validations.that's give error free to us. thanks Cheers RRave MCTS,MCPD

Not yet...but I will. I am still learning. :laugh: Thank you

It means that you have mistake in your sql query #region signature my articles #endregion

DBNull.Value.ToString() returns an empty string, so it boils down to be the same as the examples we give, I believe. ----- If atheism is a religion, then not collecting stamps is a hobby. -- Unknown

So I will have to do something like this? Provider=OraOLEDB.Oracle;**Host=xxx.xxx.xxx..xxx;Port=1521;**Data Source=MyOracleDB;User Id=myUsernameassword=myPassword; Do I still need the "Data Source" option?

@vikasparth It worked! Thank you both!

Thank you.. but I haven't finished yet..

kallileo wrote: I'm a student Then you should be learning the proper way to code. kallileo wrote: Is javascript realy necessary? AJAX = Asynchronous JAVASCRIPT and xml At some point if you are using AJAX you will need to learn it. No it isn't strictly necessary in your case, although I think it is easy to use then what you trying. -- modified at 11:52 Tuesday 12th June, 2007 only two letters away from being an asset

OK. Thanks...:sigh: I do some tests at the moment: script runat="server"> Sub ShowTime(ByVal sender As Object, ByVal e As EventArgs) Label1.Text = DateTime.Now.ToLongTimeString() End Sub Update Panel Refresh

Its ok now thank you very much!

I use VB.net but this code is exactly what I need. Thank you guys.

Thanks. My knee-jerk thought was to detach and attach, but upon reading your explanation further down in this thread I undertsand now why it would not be the optimum choice of action. "We are all repositories for genetically-encoded information that we're all spreading back and forth amongst each other, all the time. We're just lousy with information." - Neal Stephenson

I have just installed it too...and it works absolutely great. Great tool!

When I use this I get a error about converting data from char to integer probably because the data type in database is a Integer. query = "UPDATE [Temp] SET [value] = '" + txt + "' WHERE [name] = 'temprature'" -------------------------------------------------------------------- Then you had to just reomve quotes. Like : query = "UPDATE [Temp] SET [value] = " + txt + " WHERE [name] = 'temprature'" -------------------------------------------------------------------- Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India