Set SQL DateTime to Empty/Nothing in vb.net -


मेरे पास SQL ​​( दिनांकटाइम डेटाटाइप के) में एक दिनांक कॉलम है । किसी विशेष परिदृश्य के लिए, मुझे अपने ब्राउज़र में इसे रिक्त रूप में दिखाना होगा। मैंने कोशिश की 

  मंद DOB के रूप में नल योग्य (तिथि की तिथि) = दिनांक। अब मंद आंकड़े स्ट्रिंग के रूप में = DOB.Value.ToString ("डी") DOB = कुछ भी नहीं   
 लेकिन यह मुझे  डेटटाइम एक उचित प्रारूप में नहीं था कहने में त्रुटि देता है । 
 
 यहाँ क्या गलत है?

आप निम्न में से किसी एक को भी आज़मा सकते हैं: 

  मंद आंकड़े के रूप में स्ट्रिंग = IF ( DOB कुछ नहीं है, "", DOB.Value.ToString ("d"))

या 

  डायरेक्टिंग के रूप में स्ट्रिंग = "" यदि नहीं है तो डीबी कुछ नहीं है तो डीएटीस्टिंग = डीओबी.वैल। टॉस्ट्रिंग ("डी") समापन यदि

Comments

Post a Comment

Popular posts from this blog

javascript - How to use the code plugin with popcornjs -

I'm making my first move with popcornes and I'm trying to use it, but to make sure Not to do this I gave an example, and found the video to play, but I can not use the plugin index.html: & lt; Script src = "bower_components / popcornjs / popcorn.js" & gt; & Lt; / Script & gt; & Lt; Script src = "bower_components / popcornjs / wrappers / common / popcorn.mediaElementProto.js" & gt; & Lt; / Script & gt; & Lt; Script src = "bower_components / popcornjs / wrappers / youtube / popcorn.HTMLYouTubeVideoElement.js" & gt; & Lt; / Script & gt; & Lt; Script src = "bower_components / popcornjs / plugins / code / popcorn.code.js" & gt; & Lt; / Script & gt; Media.js $ scope.player = popcorn.HTMLYouTubeVideoElement ("#media-player"); $ Scope.player src = "http://www.youtube.com/watch?v=DaN2Y2-wNSs"; // The following lines failed // $ scope.player.c...
Read more

python - rpy2 import is not working -

When I try to import rpy2, I get an error. Here is the code and error & gt; & Gt; & Gt; Import Traceback (Most Recent Call Final): File "C: \ PF \ WinPython-64bit-3.3.3.3 \ python-3.3.3.amd64 \ lib \ site-packages \ IPython \ core \ interactiveshell.py", line 2828 In the file, "ipython-input-148-c258a0f70d44" gt; Row 1, & lt; modules & gt; Import pandas.rpy.common file in runcode ajl (code_obj, self.user_global_ns, self.user_ns) file " C: \ PF \ WinPython-64bit-3.3.3.3 \ python-3.3.3.amd64 \ lib \ site-packages \ pandas \ rpy \ common.py ", line 14, in & lt; modules & gt; Rpy2.robjects .packages Import Import Import Import: A module name 'rpy2' What could be the problem? I Python Version 3.3.3 and PANDAS Version 0.13.1 Edit Tried to install rpy2 separately I get an error using python setup.py install which is not the module popen3 in OS . Running the site of Christophe Gohalke properly insta...
Read more

Python, converting png to gif using ImageMagick -

I am using Python 2.7.6, I had a problem converting some PNG files into GIF (an animation To create) os.system ("Convert-dated 1-Digiage background + page" + str (output_dir) + "/*.png -loop 0" + str (output_dir) + "/ Animation GIF") This was the error on which I have Parametre non welde - 1 Enough to go Without error, this is only an estimate, but ... If there is an empty space or quote in output_dir or other special characters, to avoid or quote you Nothing is doing, so your command line will look something like this: Convert - Day 1-digest background + page ~ / My image / *. Png -loop 0 ~ / My Photos / Animation.gif There may be a completely valid argument for sending ~ / my for input, and Pictures / *. PNG is to solve a full bank Additional relative path that converts is ready to deal with additional inputs, but then you have to ~ / My , which is not valid because it has something similar to the input, and some additio...
Read more