Re: The DateTime Value Type - C# Discussion Boards

First Prev Next

Re: Export data to excel sheet

Jimmanuel18-Jun-07 3:48

Jimmanuel

18-Jun-07 3:48

Excel Automation : MSDN[^]

Javadoc for C#: XML Comments[^] or NDoc[^]

Re: Export data to excel sheet

HexaDeveloper21-Jun-07 2:17

HexaDeveloper

21-Jun-07 2:17

Hi,

thanx for ur help ur information make me make it successfully

thanx alot

Generator

Re: Export data to excel sheet

Jimmanuel21-Jun-07 2:23

Jimmanuel

21-Jun-07 2:23

glad to help Smile | :)

ComboBox change font on specific item..

akkram17-Jun-07 9:16

akkram

17-Jun-07 9:16

Hello. I have a combobox with a couple of items in it. Instead of having a label on the form that describes the content of the combobox id like to use the textproperty for this purpose. So far so fine. But now I want to change the textproperty of the combobox to italic but leave the rest of the items in the combobox as regular text. Anyone knows how I can do this.
As it is now when i change the combobox.Font.Italic prop all the items in the collection is set to italic.

//Thx

Re: ComboBox change font on specific item..

Dave Kreskowiak17-Jun-07 12:38

Dave Kreskowiak

17-Jun-07 12:38

It's all or nothing using the standard control.

If you wanted more control over the textbox and the list fonts, you'd have to create your own version that supports this, supplying the properties to be set for each side of the control and supplying all the rendering code to draw the textbox and the drop down list.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Connecting to FTP site

frqftgbdafr17-Jun-07 9:01

frqftgbdafr

17-Jun-07 9:01

I have a program that will connect to an FTP site with InternetConnect() if I use my Windows dialer.

If I try to connect to the FTP site using another dialer there is no connection to FTP site.

My Windows dialer has my user name and password for my ISP, but the other dialer does not, it just dials and connects.

I am confused, how can the other dialer connect without my ISP username and password? This is probably why I cannot connect to FTP site.

I can make a connection with the other dialer using HTTP settings and using a www.myspace.net address, but if I switch over to FTP settings and use ftp.myspace.net, no connection.

Please excuse me if I sound confused, I am, and I can't seem to get my brain wrapped around these concepts.

Thanks for any help.

The DateTime Value Type

Brendan Vogt17-Jun-07 8:24

Brendan Vogt

17-Jun-07 8:24

Hi,

Is it possible to assign a null to a DateTime value type? If not, what then?

Regards
ma se

Re: The DateTime Value Type

Guffa17-Jun-07 8:54

Guffa

17-Jun-07 8:54

ma se wrote:
Is it possible to assign a null to a DateTime value type?

No, it's not.

You can only assign null to a reference, and as DateTime is a value type, there is no reference.

ma se wrote:
If not, what then?

If you are using framework 2.x, you can use the nullable types:

DateTime? when;
if (something) {
   when = null;
} else {
   when = DateTime.UtcNow;
}
if (when.HasValue) {
   Console.WriteLine(when.Value.ToString("yyyy-MM-dd"));
} else {
   Console.WriteLine("No time specified.");
}

If you are using framework 1.x, you have to do something else to keep track of when there is a value or not, like using a bool variable along with the DateTime variable.

---
single minded; short sighted; long gone;

Re: The DateTime Value Type

Brendan Vogt17-Jun-07 9:03

Brendan Vogt

17-Jun-07 9:03

Thanks for the reply, but I struggle to see where you assigned it a nullable value?

Re: The DateTime Value Type

User 665817-Jun-07 9:11

User 6658

17-Jun-07 9:11

It's the question mark behind the type name.
See this for more information:

http://msdn2.microsoft.com/en-us/library/1t3y8s4s(VS.80).aspx

regards

modified 12-Sep-18 21:01pm.

Re: The DateTime Value Type

Luc Pattyn17-Jun-07 9:34

Luc Pattyn

17-Jun-07 9:34

You can solve this with a nullable type (since .NET 2.0)

or you might be able to set aside one value and let it represent the "has no value" situtation;
in case of DateTime it probably would be DateTime.MinValue

Smile | :)

Luc Pattyn

[My Articles] [Forum Guidelines]

Re: The DateTime Value Type

PIEBALDconsult17-Jun-07 14:45

PIEBALDconsult

17-Jun-07 14:45

Yeah, that's what I do.

Creating list of method execution time

AndrusM17-Jun-07 5:10

AndrusM

17-Jun-07 5:10

Winforms .net 2 application is running a bit slow.

How to find which methods take most of the time?

I'm using Visual C# 2005 Express Edition.
I havent found any way to create list of executed method calls ordered by execution time.

There a a lot of PostgreSQL database calls to show report.
I think some database calls take too lot time in summary.

Andrus

Re: Creating list of method execution time

Guffa17-Jun-07 7:05

Guffa

17-Jun-07 7:05

I would say that it's most likely that the performance problems are in the sql queries, at least without seeing any of the code.

The SqlConnection object can collect statistics about all queries made with it. Check if the connection object that you are using has something similar.

---
single minded; short sighted; long gone;

Re: Creating list of method execution time

AndrusM18-Jun-07 3:07

AndrusM

18-Jun-07 3:07

I checked NpgsqlConnection object documentation.
I does not contain any method for statistics collection.

Andrus

Re: Creating list of method execution time

User 665817-Jun-07 7:34

User 6658

17-Jun-07 7:34

I use this tool to find bottlenecks in my application, it's a really powerful profiler.

regards

modified 12-Sep-18 21:01pm.

How can I search for a record without using Primary key

Jon Stroh17-Jun-07 4:39

Jon Stroh

17-Jun-07 4:39

I would like to know how to search for a certain record by a value in a non keyed column, then being able to update that record to the values in another table. Here is what I have used in the past to locate a record by a primary key, is there a way to do the same with out a keyed column as a search value.Do I need to set the primary key temporarily to the new column I need to search?

DataSet1.HorseJoinTableDataTable dth = new DataSet1.HorseJoinTableDataTable();

DataSet1TableAdapters.HorseJoinTableTableAdapter tah = new FBWinMobileSync.DataSet1TableAdapters.HorseJoinTableTableAdapter();

dataSet1.EnforceConstraints = false;

tah.FillByMod(dth);

fB7MobileDBDataSet.EnforceConstraints = false;

foreach (DataSet1.HorseJoinTableRow dr in dth.Rows)

try

{ How can I accomplish this below on a non keyed column search

FB7MobileDBDataSet.HorseRow newMobileHorse = this.fB7MobileDBDataSet.Horse.FindByCODEHorseName(dr.CODE, dr.HORSENAME);

newMobileHorse.CODE = dr.CODE;

newMobileHorse.Stable = dr.STABLE;

newMobileHorse.HorseName = dr.HORSENAME;

newMobileHorse.Active = dr.ACTIVE;

newMobileHorse.AngleLF = dr.ANGLELF;

newMobileHorse.AngleLH = dr.ANGLELH;

newMobileHorse.AngleRF = dr.ANGLERF;

newMobileHorse.AngleRH = dr.ANGLERH;

dataSet1.EnforceConstraints = false;

//if(dr.DUEDATE.ToString().Trim()=="")

if (dr.IsNull("DUEDATE"))

dr.DUEDATE = DateTime.Today;

newMobileHorse.DueDate = dr.DUEDATE;

if (dr.IsNull("LASTCOST"))

dr.LASTCOST = "0";

double D = Convert.ToDouble(dr.LASTCOST);

newMobileHorse.LastCost = D; //Convert.ToDouble(dr.LASTCOST);

newMobileHorse.Totals = 3;

//Equals no change to record

if (dr.IsNull("LASTDATE"))

dr.LASTDATE = DateTime.Today;

newMobileHorse.LastDate = dr.LASTDATE;

newMobileHorse.LengthLF = dr.LENGTHLF;

newMobileHorse.LengthLH = dr.LENGTHLH;

newMobileHorse.LengthRF = dr.LENGTHRF;

newMobileHorse.LengthRH = dr.LENGTHRH;

newMobileHorse.MainWork = dr.MAINWORK;

newMobileHorse.NickName = dr.NICKNAME;

newMobileHorse.SizeLF = dr.SIZELF;

newMobileHorse.SizeLH = dr.SIZELH;

newMobileHorse.SizeRF = dr.SIZERF;

newMobileHorse.SizeRH = dr.SIZERH;

newMobileHorse.Weeks = Convert.ToInt16(dr.WEEKS);

newMobileHorse.Delete = dr.DELETE;

newMobileHorse.LengthList = dr.LENGTHLIST;

newMobileHorse.NeedsNewFr = dr.NEEDS_NEW_FR;

newMobileHorse.NeedsNewHd = dr.NEEDS_NEW_HD;

newMobileHorse.StartAngleLF = dr.START_ANGLE_LF;

newMobileHorse.StartAngleLH = dr.START_ANGLE_LH;

newMobileHorse.StartAngleRF = dr.START_ANGLE_RF;

newMobileHorse.StartAngleRH = dr.START_ANGLE_RH;

newMobileHorse.StartLengthLF = dr.START_LENGHT_LF;

newMobileHorse.StartLengthLH = dr.START_LENGTH_LH;

newMobileHorse.StartLengthRF = dr.START_LENGHT_RF;

newMobileHorse.StartLengthRH = dr.START_LENGTH_RH;

newMobileHorse.Front = dr.FRONT;

newMobileHorse.Hind = dr.HIND;

--------------------------------------------------------------------------------
Jon Stroh

Thanks Jon Stroh

Re: How can I search for a record without using Primary key

WillemM17-Jun-07 8:15

WillemM

17-Jun-07 8:15

DataSet ds = new DataSet();
DataTable table = new DataTable();

ds.Tables.Add(table);

DataRow rows[] = table.Find("MyField = 'Hello World');

That should do the trick.

WM.

What about weapons of mass-construction?
"What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson
My blog

Re: How can I search for a record without using Primary key

Jon Stroh18-Jun-07 2:35

Jon Stroh

18-Jun-07 2:35

Thank You very much, I sure wish I could learn how to search vs2005's help file. Even after you gave me this code I can't find any help on .Find for tables. Thanks for your reply though with out it I would be dead in the water Smile | :)

Jon Stroh

Custom User Control and Repeater

Expert Coming17-Jun-07 4:34

Expert Coming

17-Jun-07 4:34

I am using a Repeater to make a menu off a SiteMap. I also made a custom user control that is a cool looking button. The button's events work fine and the properties work fine as long as I am not in a repeater control. If I use the repeater control I get a NullReferenceException because as far as I can see all my properties are null on postback.

How can I get all my properties to save?

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: Custom User Control and Repeater

Expert Coming17-Jun-07 16:58

Expert Coming

17-Jun-07 16:58

Found the solution. I had to go add ViewState objects to my custom control to get it to have ViewState properties, I assumed it would do it itself, I don't know why I made that assumption.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Hiding a form in Vista

Mr Jen Withers17-Jun-07 3:37

Mr Jen Withers

17-Jun-07 3:37

Iam currently in the middle of writing a screen grabbing app in c#. One of the requirements for the application is that the form or window of my application doesnt appear in the grabed images. Under XP this was easy as I just set the form to not appear in the task manager in the form properties in visual studio and when it was minimised you couldnt see it at all.
The same nearly applies to vista, I cant see the window when minimised and it doesnt appear on the taskbar. However when it is minimised I seem to get a floating tab of the window in the main desktop.
I dont know if this can be disabled with a vista control panel setting or there is some other way of doing it with code but I cant seem to find it either way. Can anyone possibley help with this.

Much appreciated Mike

datagridview - VB.net 2005 ,sql server 2005

nilam1117-Jun-07 2:36

nilam11

17-Jun-07 2:36

How can i get the content of selected row on the double click event of datagridview for 2005?

reply immediatly
thanks

Re: datagridview - VB.net 2005 ,sql server 2005

Arun.Immanuel17-Jun-07 2:45

Arun.Immanuel

17-Jun-07 2:45