|
am using this code inside insert method
Insert into table (startdate) values (DateTime.ParseExact(Startdate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture))
i have textbox and want to insert null value
|
|
|
|
|
There are a couple of things here:
1) Text boxes don't contain NULL values - they can contain empty strings, but that is a very different thing.
2) ParseExact will fail if the string doesn't match - which means you must either use a try...catch block, or better use TryParseExact instead, reporting a problem to the user instead of trying to pass anything to the DB.
3) What you show won't work: even if it did what you think, it would pass the string version to SQL via concatenation, and that really should be avoided as it makes SQL convert the string back to a DateTime and that can introduce errors.
So verify the TB at the start of the method, and pass DateTime or NULL like this:
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("INSERT INTO myTable (startDate) VALUES (@SD)", con))
{
object o;
if (string.IsNullOrWhitespace(Startdate.text)) o = DbNull.Value;
else o = valueConvertedToDateTimeEarilerWhenYouValidatedIt;
cmd.Parameters.AddWithValue("@SD", o);
cmd.ExecuteNonQuery();
}
}
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I have 8000 records i want put server side pagination and search
|
|
|
|
|
|
|
Hi Ann - welcome to the site!
Unfortunately, "teach me some of your knowledge" isn't really something we can do in a little text box - we have no idea what you do or don't know and understand, and the last thing we want to do is send you off in a direction that your course isn't taking yet. And I'm sure you are already aware that there isn't "one way to do it" but pretty much as many different ways as there are developers to try it!
So you need to be rather more specific about exactly what you are trying to do, what you have tried, what happened when you tried, where you are stuck, and what help you need! I know, I know - that sounds like a lot, but we can't see your screen, access your HDD, or read your mind: we only get exactly what you type to work with. And when you post the computer equivalent of phoning the garage, saying "it broke" and ending the call we get nothing to really work with!
So think about what you are having difficulty with and try explaining in good detail - the better your questions, the better our answers!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
|
Thanks; is the beer in the post?
|
|
|
|
|
how can I implement the cd funtion?
|
|
|
|
|
If you're using the FtpWebRequest class, you have to "fake" it by adding the directory to the URL:
Changing to the root directory with FtpWebRequest – Mariya Atanasova's Blog[^]
If you're using something else, then you'll need to tell us what you're using, as the answer will likely be different for each FTP client library.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I want to make a windows notifyicon program that automatically returns answers to a question that i copied in c# winforms. How can i make that?
|
|
|
|
|
What have you tried?
Where are you stuck?
What help do you need?
This is not a good question: we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Teun van den Broek wrote: How can i make that?
By writing a lot of code. I'm not really sure what kind of answer you are looking for.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
If you have to ask, "How do I write an entire program?", you've got a much bigger problem with your skill set. You need to break the application down into smaller and smaller solvable chunks.
You said you have to display a notify icon. OK, so do you know how to display a notify icon on the Task Bar?
Do you know how to interact with the notify icon when someone clicks on it?
Know how to handle a dialog and text box?
No? You've got a lot of research to do.
|
|
|
|
|
Can any one help me find differences between 2 XML files?
I have tried the XMLDiff but the problem is that i want the differences which are in the vxd.out file(Generated as a intermediate file and later gets deleted) to be with Node names instead of numbers.
The node names are not fixed it keeps changing (based on check box it gets added or removed(Eg)). The output of xmlDiff seems to be ok (since find some issues in it - "can live with it") need numbers converted to names where name can be fetched from on of the file when reloaded after the vxd.out file. I can trace down the numbers but the issue is cant convert to names.
The XML file size talking about is 60mb file may grow.
IF ANY OTHER WAY OF COMPARISON WHICH WORKS IS THERE WOULD ALSO BE FINE. i WANT ONLY THE DIFFERENCES IN SEPARATE FILE.
Thank for your help in advance.
|
|
|
|
|
Personally I use Beyond Compare[^] - you can get a 30 day trial to work out if it's good enough for what you need.
|
|
|
|
|
Thank you for the response.
Yes, but most of the time its like if the 1 element or 1 node is moved to 10th element of the node it does not help much. More over they only want the changes to see in separate document. Like added node name, modified node name, deleted node name etc...
|
|
|
|
|
Rather than looking for a cute way to do it in xml why not read the data into a structure and then manipulate it there.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Reading it as a DOM tree and recursively finding the complement of each set of child nodes maybe? Since I think it's implied that the order of elements isn't significant.
|
|
|
|
|
What has this question got to do with C#?
This space for rent
|
|
|
|
|
I want a code in c# for comparing 2 xml files that's the reason for posting in this area.
Since its a code is required in c# it has been posted here... any clarifications required?
|
|
|
|
|
First, you didn't ask for any code (C# or otherwise), you just posted a request to compare files. Second, what code do you currently have? Are you using XLINQ or XMLDocument manipulation?
This space for rent
|
|
|
|
|
I am using XMLDocument as of now. Not much aware of LINQ. The problem with XMLDocument or XDoc we can have a look at the immediate child and immediate parent on reaching the specific node.
Looking for code in c# for comparing the XML.
Problems faced with input file:
* dont have the pattern/Schema of the xml aslo how it would look finally if all options enabled.
* node names are not fixed (eg: 10 checkbox exist when xml file generated, only selected 2 items in check box so xml generated only with those 2. Later on add 2 more checkbox enabled where in new xml will have 4 out of 10 check box. When compare we can check for only old check boxes which have the node names. for the new ones we will come to know node names and we need to alter code for the 2 new selection)
* Some cases node has not attribute but has child's.
* Some other time nodes have same name but no attribute and has child and would be in same position as the other.
* I had used diffpatch from microsoft to get differences but intermediate output is in node numbers want to convert it to numbers. (If any other solution for comparing and get differences only in different file is most welcome)
|
|
|
|
|
Any updates on the query?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Beer | [beer]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/beer.gif)
