|
Can't you just dock the picture box in the panel, and let the picture box center the image?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
How to Link a specific word in a text box ??
background
in an Oxford Advanced Learner's Dictionary - 7th edition
you will found that if you searched for word in the discription area
some words are bold or colored a different colors and if you hover those word a popup message will appear with the short meaning of the word and if you click it it will change the search word into that clicked word
Soo please i Really want to know How to make it???????
is it possible in windows application or i must use web pages techniques?
|
|
|
|
|
|
I have a CLR UDF that I created a while back and I could debug it locally and remotely. However, I can no longer debug, or step into, it at all. In the output window in VS it says that the attachment succeeded, but, it never makes it to the break point in test.sql or any other break point. I have checked and rechecked the properties and all is in order. I know I haven't changed anything. I also followed a simple tutorial from the web (a couple of them) that don't do anything but return a string saying "hello", and the same problem occurs.
Funny thing to mention is that I was having the same problem yesterday, but it would work off and on. It worked three different times but doesn't seem to want to work at all now.
I have also deleted the binaries and redeployed and that doesn't seem to work either.
|
|
|
|
|
In my DataSet, I have a field called "ADMISSION_DATE" in the format of DateTime, which upon displaying in my Report showz up as, lets say, "08-29-08 12:00:00".
3rd Line displays the Date (08-30-08) as required but 4th line displays it as DateTime (08-29-08 12:00:00).
But I want only the date thing (i.e. 08-29-08). And in dataset I don't see any direct DATE conversion methods. Please help.
row["ADMISSION_DATE"] = DateTime.Parse(row["MM"].ToString() + "/" + row["DD"].ToString() + "/" + row["CC"].ToString() + row["YY"].ToString().ToString()) ;
DateTime newDT = new DateTime();
newDT = Convert.ToDateTime(row["ADMISSION_DATE"]).Date;
MessageBox.Show(newDT.ToShortDateString());
row["ADM_DATE"] = newDT.ToShortDateString();
Thanking you in anticipation.
|
|
|
|
|
Hi,
If your column ADMISSION_DATE is datetime, you cannot store only the date portion. Time is set to default if it's not specified. However when you get the datetime from the row, you can truncate it just as you have done.
Mika
|
|
|
|
|
A DateTime value always has a time component, even if it's zero. The Date property returns a DateTime value where the time component is set to zero, just as you do in line 2.
Verghese wrote: row["ADMISSION_DATE"] = DateTime.Parse(row["MM"].ToString() + "/" + row["DD"].ToString() + "/" + row["CC"].ToString() + row["YY"].ToString().ToString()) ;
If you already have the components of the date as numbers, don't format them into a string just to parse into a date. There is a perfectly good constructor for the DateTime structure that takes numbers:
row["ADMISSION_DATE"] = new DateTime((int)row["CC"] * 100 + (int)row["YY], (int)row["MM"], (int)row["DD"]);
Verghese wrote: 3rd Line displays the Date (08-30-08) as required but 4th line displays it as DateTime (08-29-08 12:00:00).
You are storing a string in the field, so if you display it as it is, it can't display in any other way than the way that you formatted it. The only chance that it would display with a time component, is if it's parsed into a DateTime value and the formatted into a string again using a different format.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Guffa, I understand that, storing a value as string cannot be displayed in any other formats unless until we parse it into some other formats.
But that's the reason why I'm parsing it into DateTime format. see the code one again......
row["ADMISSION_DATE"] = DateTime.Parse(row["MM"].ToString() + "/" + row["DD"].ToString() + "/" + row["CC"].ToString() + row["YY"].ToString().ToString()) ;
The row["MM"].ToString is a String, but I'm finally parsing it into DateTime. And after execution I could see that the "ADMISSION_DATE" field type in DataSet changes to DateTime. So from this its clear that it's getting stored as DateTime and the field type is also DateTime.
But the problem is to extract only the date thing, when I call the DataSet rows.
Hope I dindn't confused you.
|
|
|
|
|
Yes, you are storing a DateTime value in the field, and the value has a time component that is zero. Then you read the field, convert the DateTime value to a DateTime value, and use the Date property to get a DateTime value where the time component is zero from the DateTime value where the time component already is zero. Then you convert the value into a string using a format that does not even include the time component that is zero.
As the value that you finally store as a string in a field doesn't have any time information at all, the problem is not in the code that you have shown. As I said before, the only chance that this value is displayed with a time, is if it's once again parsed into a DateTime value and then formatted into a string with a different format.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Dates and times should always be stored as DateTime (when available). If they aren't, then you run into these kinds of problems.
Any formatting should be performed when the value is displayed (or written), not in the database.
And please use an ISO 8601-compliant format, e.g. YYYY-MM-DD
|
|
|
|
|
you said Reports
So if its just a question about displaying the data on the report ,
use string functions to eliminate the extra time .
Vikas Amin
My First Article on CP" Virtual Serail Port "[^]
|
|
|
|
|
Hi Vikas, if the task wud have been just to display the data on the report, thn it was easy.
See here's just the gist, my database table has dates splitted in 4 columns like DD, MM, CC, YY. Then using DataSet I'm concatenating these fields. And I'm concatenating it, bcoz I want to display the records within a particular date range. And for tht date comparison thing, it has to be in the date format and not string format.
And this comparison has to be done at the code level and not at the database level, since database doesnt have anything like a date field.
|
|
|
|
|
can you try
row["ADM_DATE"] = newDT.ToShortDateString().Remove(9)
Vikas Amin
My First Article on CP" Virtual Serial Port "[^]
modified on Thursday, July 24, 2008 5:33 PM
|
|
|
|
|
Vikas, whn i try this line
row["ADM_DATE"] = newDT.ToShortDateString().Remove(9)
it's throwing up this error:
"No overload for method 'Remove' takes '1' arguments"
|
|
|
|
|
|
Verghese wrote: database table has dates splitted in 4 columns like DD, MM, CC, YY
Which is a very poor design.
Verghese wrote: database doesnt have anything like a date field
What database doesn't have a DateTime type?
|
|
|
|
|
Dear........this is not my design, its the way how dates are always stored in AS400 Mainframe systems. I'm working on IBM iSeries Mainframe server. I have not much options on choosing the database.
Did I cleared your doubt???
|
|
|
|
|
Had you said that first, you would have gotten more sympathy.
|
|
|
|
|
dear friend, i didnt knew u were this caring...........but dont be in the assumption that it was way too funny...........
|
|
|
|
|
See example :
DateTime d = new DateTime(2008, 8, 29, 12, 0, 0);
Console.WriteLine(d.ToString("dd-MM-yy"));
|
|
|
|
|
Hi,
In crystal report I want to display data of a field of my DB in 5 columns of details view, (instead of 1).
How can I do this?
suppose I want to show names of customers, but they display in 5 columns, not they apper in one columns.
Best wishes
|
|
|
|
|
Hi,
You add a table from the toolbox to the report and define 5 columns.
Mika
|
|
|
|
|
OK - I have created a static class to add a "heartbeat" to an application (in a similar way to the way Trace and Debug classes work) thus:-
public static class Heartbeat
{
private static HeartbeatListenerCollection _listeners = new HeartbeatListenerCollection();
public static void Beat()
{
foreach (HeartbeatMonitorBase _listener in Listeners)
{
_listener.Beat();
}
}
static Heartbeat()
{
TimerCallback timerDelegate =
new TimerCallback(Heartbeat.Beat);
AutoResetEvent autoEvent = new AutoResetEvent(false);
System.Threading.Timer heartbeatTimer =
new System.Threading.Timer(timerDelegate, autoEvent, 0,1000);
}
public static HeartbeatListenerCollection Listeners
{
get { return Heartbeat._listeners; }
}
}
}
However this only gets started beating the first time the class is referred to. Does anybody have any thoughts as to how I could get this class to instantiate at startup?
|
|
|
|
|
I'd use the singleton pattern and create the heartbeat like this:
class Heartbeat
{
static readonly Heartbeat instance = new Heartbeat();
static Heartbeat()
{
}
Heartbeat()
{
}
public static Heartbeat Instance
{
get
{
return instance;
}
}
}
and init it:
Heartbeat h = Heartbeat.Instance;
anywhere in your startup code.
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
It's good - but to make things even trickier, I want to be able to instantiate the heartbeat for an application even if that application code doesn't have any reference at all to the class.
|
|
|
|