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

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

javascript - How to get MySQL query result returned using $.ajax -

I'm trying to update is a JavaScript, when you hover over an image, a devi Floats near your mouse, this information is stored in an .js file as an array, for example. text [0] = ["image 1", "data1"] text [1] = ["image2", "data2"] In the past, if the array change / add / delete the data it will need to upload a new copy .js file, if the data was attached / deleted, then the new image needs a change in .dwt file Which can update each file using the .dwt file as the main template, which can result in 20+ pages They are uploaded I thought that I can automate this record by using the database and using the database if they are active and use only mysql queries which are active, such a black app The database can be added and disabled, thus eliminating the need for every soft upload of the file. To do this, I had planned to store the information in the database and create the above array based on the results, by researching how to us...
Read more

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