Conversion from type 'DBNull' to type 'String' is not valid

Question

Dear All I'm getting this error when reach this lines of my code Conversion from type 'DBNull' to type 'String' is not valid this is my code : If DS.Tables(0).Rows.Count 0 Then blnD = DS.Tables(0).Rows(0)(ItemExist) FORM1_ID = DS.Tables(0).Rows(0)(FORMID) Prev_FORM_ID = DS.Tables(0).Rows(0)(PREVFORMID) lblDONE.Text = Successfully Normal 0 false false false EN-US X-NONE AR-SA /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-para-margin:0cm;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} Saved what to do ??

Vulpes · Answer

Try changing this line: Prev_FORM_ID = DS.Tables(0).Rows(0)(PREVFORMID) to this: If Not DS.Tables(0).Rows(0).IsNull(PREVFORMID) Then Prev_FORM_ID = DS.Tables(0).Rows(0)(PREVFORMID) End If

ToBe · Answer

thank you so much guys I tried it's working now

Jignesh Trivedi · Answer

hi try... if (! DBNull.Value.Equals(DS.Tables(0).Rows(0)(PREVFORMID))) Prev_FORM_ID = DS.Tables(0).Rows(0)(PREVFORMID) else Prev_FORM_ID = String.Empty; hope this will help you.