|
Hi,
I have a DevExpress DatePicker component in my C# windows for application which will display a DateTime and I have a timestamp or datetime field in MySQL.
I want to use the date only from the datePicker and find it by date only in the MySQL regardless of the time.
Technology News @ www.JassimRahma.com
|
|
|
|
|
..delete the time-portion of the date? A date is a double, so truncating it should do the trick.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Please, ignore Eddies suggestion, and just use the Date part of the DateTime: MSDN[^]
It removes the time portion of a DateTime value, and returns just the date:
DateTime now = DateTime.Now;
DateTime today = now.Date;
Console.WriteLine("{0} : {1}", now, today);
Gives:
06/03/2013 15:45:49 : 06/03/2013 00:00:00
[edit]Spaced the output better - OriginalGriff[/edit]
If you get an email telling you that you can catch Swine Flu from tinned pork then just delete it. It's Spam.
|
|
|
|
|
Agreed 
|
|
|
|
|
Combined with OG's answer MySQL has a DATE function which selects only the date portion of a DateTime field, something like this:
SELECT tableid, field1, field2 FROM yourTable WHERE DATE(yourDateField) = @yourDateParameter;
That will let you filter the results by only the date portion;
Hope this helps
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
|
|
|
|
|
Jassim Rahma wrote: I have a DevExpress DatePicker component in my C# windows for application
Part 1.
Jassim Rahma wrote: and I have a timestamp or datetime field in MySQL.
Part 2.
A timestamp is not the same as a date. Now if the value was carefully manipulated correctly every time it was inserted into the database then you would have a timestamp, NOT a date, which had a fixed time part.
If and only if that is the case then you can get the date part from C# per the other suggestions and then construct the time part and then do an exact match. Probably. (A range is still probably safer.)
If however the time part varies in the database then you MUST use a range check. So if the user picks 2012-12-31 then you create two timestamp values with the following values
start = 2012-12-30 00:00:00
end = 2012-12-31 00:00:00
Then you do a database comparison like the following
where {column} > start and {column} <= end
|
|
|
|
|
CREATE PROCEDURE sp_userinformation
@UserName varchar(50),
@Password varchar(50),
@FirstName varchar(50),
@LastName varchar(50),
@Email varchar(50),
@PhoneNo varchar(50),
@Location varchar(50),
@Created_By varchar(50),
@ERROR VARCHAR(100) OUT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
---Checking Condition if User exists or not if user not exists returns different message if exists returns different message
IF NOT EXISTS(SELECT * FROM User_Information WHERE UserName=@UserName)
BEGIN
INSERT INTO User_Information
(
UserName,
[Password],
FirstName,
LastName,
Email,
PhoneNo,
Location,
Created_By
)
VALUES
(
@UserName,
@Password,
@FirstName,
@LastName,
@Email,
@PhoneNo,
@Location,
@Created_By
)
--If User Successfully Registerd I am returing this Message as Output Parameter
SET @ERROR=@UserName+' Registered Successfully'
END
ELSE
BEGIN
--If User already Exists i am returning this Message as Output Parameter
SET @ERROR=@UserName + ' Already Exists'
END
END
|
|
|
|
|
You should really ask this in the database forum. You don't need a semi-colon at the end of SET NOCOUNT ON.
|
|
|
|
|
yeah.. correct & thanks .
|
|
|
|
|
Not a problem. I'm glad you've got it working.
|
|
|
|
|
|
|
there is a exception when i create DirectoryEntry .
code:
DirectoryEntry parent = GetDirectoryEntryByDn(path);
<big><b></b> DirectoryEntry user = parent.Children.Add("CN=" + user_name, "user");</big>
try
{
string oGUID = string.Empty;
user.Properties["samAccountName"].Value = user_name;
user.Properties["telephoneNumber"].Value = "15014088110";
user.Properties["streetAddress"].Value = "HZ";
oGUID = user.Guid.ToString();
user.CommitChanges();
}
catch
{ }
user.Close();
parent.Close();
the program run the line :
DirectoryEntry user = parent.Children.Add("CN=" + user_name, "user")
,the excpetion happened:
the exception InteropServicesCOMException "The specified Directory object is not bound to a remote resource" (and Error code
property is -2147463159)
please help me !
|
|
|
|
|
Try using the capabilities of System.DirectoryServices.AccountManagement to do this. See this[^] message for some ideas.
|
|
|
|
|
Hello CP!
Alright, I thought this would be simple, but apparently I don't know what I am doing. I have a Rich Text Box that populates upon form load. There are fields that are meant to be updated by text boxes on this form. Here's a snip of the form_load:
private void Form1_Load(object sender, EventArgs e)
{
string cifTime = timeCIF.Text;
string chkCIF = "N";
emailBody.Text = "Example\nCIF = " + chkCIF + "\nTIME = " + timeCIF.Text;
}
So what happens here is the form opens and populates a rich text box with:
Example
CIF = N
TIME =
Now, what I need to have a button do is update just the items I have defined, in this case chkCIF (a check box) and timeCIF.Text (a textbox). I have a button that's called update, and here's what it looks like.
private void updateButton_Click(object sender, EventArgs e)
{
if (comboInst.Text == "Example")
{
if (checkCIF.Checked == true)
{
string theString = emailBody.Text;
theString.Remove(3, 2).Insert(3, "Y");
}
}
And there you have it. I just need to be able to update certain defined words from a string with a click of a button. Thanks in advance 
|
|
|
|
|
Goaty65109 wrote: update certain defined
Okay.... you are replacing/removing the text but then throwing the result away. You need to set your emailBody.Text back to the string that you have updated.
emailBody.Text = theString.Remove(3, 2).Insert(3, "Y");
|
|
|
|
|
Aha! I knew I was missing something so simple...
I am running into my next problem...
That removes items in position 3, over 2 spaces.
How do I tell it to do ROW 2, position 3, over 2 spaces?
And thank you so much for the speedy response.
|
|
|
|
|
Goaty65109 wrote: ROW 2
I don't know too much about it but I do not believe that the stock rich text box supports the concepts of rows.... A cheap easy way to do what you want would be to split your string (Split function) replace the text in the resulting array and then rejoining the array back into a string. Easier than is sounds.
Or you can replace your stock control with something like Line Numbers for RichText Control in C#[^]
|
|
|
|
|
Hey Phantom,
I understand what you're saying there and if a rich text box isn't the best way I think I can work backwards on what I want to do then.
How about writing the information to a text file, then calling it to the text box once it's updated in the text file?
Here is the "flow" of things:
Form loads and a .txt file is generated as a template.
User checks the box which makes the N turn into a Y in the text file.
User inputs the time into a text box.
User clicks the "Update Form" button which saves the text document and then pulls the entire document into the rich text box revealing the changes.
Does that sound like a better option? This just creates a new situation I have yet to attempt, but is on my "to learn" list, writing information to a specified position in a text file/reading from a text file.
Thank you for your response
|
|
|
|
|
No, please don't bring a text file into this. It will not make it any easier to replace your substrings and you will just be complicating matters.
See Richard's answer below, it seems like a much better solution.
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
Goaty65109 wrote: a text file
A text file would just add unnecessary complexity IMO. I would probably do this just as Richard suggested.
|
|
|
|
|
emailBody.Text = emailBody.Lines[1].Remove(3, 2).Insert(3, "Y");
|
|
|
|
|
Hi Rikki!
I tried this method and it appears that this will clear the emailBody and replaces it with just the first line, and replaces the third position with Y.
So this
Example
Blah = N
turns to this
ExYmple
I just want this if possible
Example
Blah = Y
Haha, sorry for my illiteracy, I am trying to be as specific as I can with the knowledge I have. :P
|
|
|
|
|
For example:
private void SomeForm_Load(object sender, EventArgs e)
{
string cifTime = timeCIF.Text;
string chkCIF = "N";
emailBody.Text = "Example\nCIF = " + chkCIF + "\nTIME = " + timeCIF.Text;
}
private void SomeBtn_Click(object sender, EventArgs e)
{
string[] sLines = emailBody.Lines;
sLines[1] = emailBody.Lines[1].Remove(6, 1).Insert(6, "Y");
emailBody.Lines = sLines;
}
|
|
|
|
|
Why not keep all the individual pieces of text as separate variables and then rebuild the RichTextBox[^] using its methods, whenever an item changes? This should make it much easier to add or remove specific items in the future.
Use the best guess
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
