Unable to cast object of type 'System.DBNull' to type 'System.String'. while saving in the database

Question

I am trying to manually create a strongly typed data row

DataSet.PersonRow personRow;
personRow=dataset.Person.NewPersonARow();

personRow.MiddleName=(string)GridView.GetFocusedRowCell("Middlename");
Unable to cast object of type 'System.DBNull' to type 'System.String'. while saving in the database

Desi Gal · Answer

well guys thanks for all the replies. But I figured out the problem. Somehow GridView.GetFocusedRowCellValue(MiddleName) was returning me null inspite of having a valid value. I trid the same code in the rowUpdated event and it works

Desi Gal · Answer

My column(MiddleName) is not empty. I am passing a value still GridView.GetFocusedRowCellValue(MiddleName)!=null gives me a null value in the Debug Mode

Master Billa · Answer

Hi I think that coulmn is Null value so you need check like this way' if( GridView.GetFocusedRowCell(Middlename) !-=null) { personRow.MiddleName=(string)GridView.GetFocusedRowCell(Middlename); } thank you

Kirtan Patel · Answer

Convert it Like string s = System.DBNull.value.ToString();