使用linq的storeprocedure的空值问题 [英] null value problem with storeprocedure using linq

问题描述

我已经创建了一个存储过程并使用taht存储过程将数据插入表中.但是当int或datetime文本值为null时，会产生问题.我该如何处理呢?

代码在下面

hi ,

i have created a store procedure and used taht store procedure to insert data to table.But it create problem when the int or datetime text value is null.How do i handle it?

the code is in below

 DATAClassesDataContext db = new DATAClassesDataContext();

 int result = db.insertagent(txtagent.Text, txtfather.Text, Convert.ToDateTime(txtdob.Text), txtaddress.Value, Convert.ToInt32(txtpin.Text),
  Convert.ToInt32(txtage.Text), txtphoneno.Text, txtbankname.Text,
Convert.ToInt32(txtaccountno.Text), txtbankaddress.Value, txtpancardno.Text, txtnominee.Text, rbtrelationship.Text, Convert.ToInt32(txtNomineeage.Text), txtIntroducernamet.Text, Convert.ToInt32(txtIntroducercode.Text),
                                       txtrank.Text, Convert.ToInt32(txtissuerank.Text), Convert.ToInt32(txtcustomerid .Text), txtpalnbname.Text,
                                      Convert.ToInt32(txtplanbcode.Text), txtteama.Text, txtteamb.Text, txtepinno.Text, txtserialno.Text, Convert.ToDateTime(txtfromdate.Text),
                                       txtemail.Text);

在此先感谢!!!!!!!!!!

Thanks in Advance!!!!!!!!!!

推荐答案

检查它们.或编写返回int或null以及DateTime或null的通用方法，并使用这些方法代替Convert方法.

Check them. Or write generic methods which return either an int or a null, and a DateTime or a null and use those instead of Convert methods.

这篇关于使用linq的storeprocedure的空值问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！