Strongly Typed Dataset
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I am using Strongly Typed Dataset(.Xsd) to keep the values fetched from the database. And i am using three tyre architecture in my project. I am using this Typed dataset not only to fetch the records from database and also to store the new values into the database. I am getting a problem while i am trying to assign NULL for an integer field. if (txtExperience.Text.Trim() == "") row.Experience =(Int32)SqlInt32.Null; //row.SetExperienceNull; //DbNull.Value; else row.Experience = Convert.ToInt32(txtExperience.Text); I am getting the error below Data is Null. This method or property cannot be called on Null values in strong typed dataset I dont know how to pass the null value. Pls help me! Tnx in Advance.