|
Hi,
I wish to have the format of the date saved into my database as a short date format.
The MS Access DB field is configured for the datetime format.
Thanks,
Glen Harvy
|
|
|
|
|
You can't change the access database, or you don't want to ? How does this relate to the datetimepicker ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
The text and value fields are bound to the database and are being saved to the db in the long format ie including the time.
I just don't want the time portion saved in the database field.
-- modified at 9:21 Monday 5th February, 2007
I think this is the only way :-
this.dtpMailInDateRcd.Value = this.dtpMailInDateRcd.Value.Date;<br />
this.dtpMailInDate.Value = this.dtpMailInDate.Value.Date;<br />
this.dtpMailInRepliedDate.Value = this.dtpMailInRepliedDate.Value.Date;
before I save the data.
Glen Harvy
|
|
|
|
|
Hi,
I dont think even that might be a solution, since the value that you pass from your front-end is first parsed to the date format at the time of saving in the database. Hence, if the date format is "LONG" in your Access Database, then in that case, it will add time to the value passed from the front-end.
However, one solution could be that you change the format of the date (in the Design View) of the table to "mm/dd/yyyy" in the Format textBox in the General Tab and from the front -end you pass the value as
suggested by you in your previous thread.
this.dtpMailInDateRcd.Value = this.dtpMailInDateRcd.Value.Date;
This probably might help.
Thanking you in Advance
Regards
Pratik Shah
|
|
|
|
|
 HI guys
Please suggest me one good link for c# collections and to learn data structures in c# too.
Thanks alot
Bobby
|
|
|
|
|
|
HI all,i had a query regarding Exception Handling.consider there r 30 webpages,which doesnt consists any type of Exception Handling techniques or code.as it is maintenance and enhancement project,how can i trace the errors and how to make it follow coding standards.
pls help me.
Thanks in advance
Bobby
|
|
|
|
|
A good first step would be to write a base page class, which handles and logs unhandled exceptions, and make all pages derive from it. From there, you need to decide where exception handling is needed for specific cases, and add it.
Putting all code in try/catch(Exception) blocks is bad practice, you should add exception handling only for specific exceptions that you can anticipate and recover from.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
HI Graus
Thanks for ur fast reply.can u tell me some more detail how it handles and logs the exceptions.
pls spare me some little time
thanq
|
|
|
|
|
Any code I write, at the top level, will just catch it, write it out to a log file ( the exception and the stack trace ), and then show an error ( if it's winforms ) and gracefully exit. But, that's the last stop, the place where stuff I don't want to happen, gets recorded so I can have some lead on how to never let it happen again.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
try
{
// some code
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
VirtualVoid.NET
|
|
|
|
|
If user RegisterWindowMessage()in app A, than send this message, how to set hook to capture this message in app B?
|
|
|
|
|
A window can capture all messages it gets by overriding WndProc
for examples, just search "WndProc" on CodeProject.
Luc Pattyn
|
|
|
|
|
But in A app, there is no form, that means i can't override WndProc or DefWndProc,so what can i do?
thanks
|
|
|
|
|
This may be a good reason to give your app a window, possibly an invisible one !
Luc Pattyn
|
|
|
|
|
At the beginning, i want to use a invisible window,but i think it is a little uglily, so i passed this idea, At present most probably, this is a convenient and rapid way to solve the problem.
|
|
|
|
|
I am pretty sure it is the only way if you want to receive Windows Messages,
as was clear from your initial post. Many apps have a window just to be able to receive
such messages.
Luc Pattyn
|
|
|
|
|
OK, i will try!
thank you very much Luc!
|
|
|
|
|
Hello,
I am trying to render a graphical sort of output in a console application.The result is word wrapping on the console.So i want to enable horizontal scrolling for the console window.How do i do it?
rgds,
chax
chax
|
|
|
|
|
In the console you can set "BufferWidth", i.e. the size of the console buffer, to some other value than the default 80, and you will get horizontal scrolling.
Internet - the worlds biggest dictionary
|
|
|
|
|
hello all,
am making a project that has a datagridview that will be filed from a SQL DB,
1) there si a field in the DB that has a data in hexadecimal format, so how i can fill it after converting it to string.
2) what is the process of allowing the user to add, delete and update on the datagridview directly??
sorry for the ones who see that i ask an easy questions  but they are not easy 4 all of ones as u see :->
Thanks alot
Hamody
|
|
|
|
|
hi,
when u write the query to retrieve the data, convert the hexadecimal value to a string so that ur table will not have any column with hexadecimal values.
you can use edit, update, cancel and do the required manipulations on the datagrid, write the required logic in few methods and assign these methods accordingly to the datagrid events!!!
Gautham
|
|
|
|
|
thanks, but how i can convert from hexadecimal to string, io dont know the function to do this.
have u an example on add, delete, update on the datagridview
Thanks alot
Hamody
|
|
|
|
|
Hi,
int.Parse(myString, NumberStyles.AllowHexSpecifier);
will do it; I find the style name confusing, it means read-as-hex but does not
allow the 0x specifier !
Luc Pattyn
|
|
|
|
|
i tried it as:
string hhhh;
hhhh=int.Parse("ffff", NumberStyles.AllowHexSpecifier).ToString();
MessageBox.Show(hhhh);
use using System.Globalization; as name space
but it hasnt convert the hex to string
what can i do ???
Thanks alot
Hamody
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
