Re: Creating list of method execution time - C# Discussion Boards

First Prev Next

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

nilam11 wrote:
reply immediatly

Please request humbly.

Regards,
Arun Kumar.A

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

Sathesh Sakthivel17-Jun-07 3:47

Sathesh Sakthivel

17-Jun-07 3:47

nilam11 wrote:
reply immediatly

Please Don't put this. This is not good.

Please go with Soft and Humble Request.

Regards,

Satips. Rose | [Rose]

a small doubt ....

Software_Specialist17-Jun-07 2:07

Software_Specialist

17-Jun-07 2:07

Hi
Is it possible to create a database SQL application without using asp.net. Only C#.Net.
There is one project to create an application for a school with 8000 students. So have to keep record of all the students and stuff , n things like registeration etc etc...SO need a heavy database...So what do you guys suggest in this case...

Thanks

Re: Useless subject

Guffa17-Jun-07 2:48

Guffa

17-Jun-07 2:48

Try to write a subject line that says something about the thread.

Software_Specialist wrote:
Is it possible to create a database SQL application without using asp.net. Only C#.Net.

Yes, of course.

Software_Specialist wrote:
There is one project to create an application for a school with 8000 students. So have to keep record of all the students and stuff , n things like registeration etc etc...SO need a heavy database...So what do you guys suggest in this case...

If you are going to be running a single instance of the application, any database will be able to handle that amount of data, even an Access database.

If you are building something that are going to be used from several instances of the program, or is going to be incorporated into an intranet/extranet, or if you see any of this as a likely development in the future, you should use a more stable database solution, like MS SQL Server.

You don't have to forsee any future needs, though. MS SQL Express is fully compatible with a full grande MS SQL server, so it would be fairly easy to upgrade if needed. Any type of database can be imported to another, but there are some differences in connection, data types and sql queries.

-- modified at 9:28 Sunday 17th June, 2007

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

Re: Useless subject

Software_Specialist18-Jun-07 3:35

Software_Specialist

18-Jun-07 3:35

But i guess these kind of applications are better if done using ASP.Net as it could be worked via webpage(internet) or intranet(if want to use it locally with in campus).
Please correct me if am wrong.
If i am right then i should build this application using ASP.NET, C#.NET, ADO.NET, SQL server 2005

Thanks

Re: Useless subject

Guffa18-Jun-07 3:58

Guffa

18-Jun-07 3:58

It depends on what the application has to be able to do, really.

Most applications that work against a database doesn't really benefit much from being windows applications, as they are working against a central database anyway.

Web applications have some benefits over windows applications, though. All that you need to use it is a browser, you don't need any .NET framework or specific datbase drivers installed. You actually don't need the computer to run Windows at all.

Unless you have some special requirements in the application that needs it to be a windows application, you can very well make it a web application.

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

Logging of Upload file

reddyamar_uk17-Jun-07 1:41

reddyamar_uk

17-Jun-07 1:41

Hi,
I have written a script where user can upload a file into a pre-defined destination file. But I want to add couple features to this
1) I want to validate so that only preferred users can access this application.
2) Everytime a user uploads a file, a log table needs to be updated with the user name(may be windows login name), upload date& time, File name etc.
Can some one help me with the scripting part for this pls.

Thank You

rdlc Report

imran_Shaikh16-Jun-07 23:41

imran_Shaikh

16-Jun-07 23:41

how we used rdlc report throw code with Parameter / or How make a rdlc report With Runtime,

Thanks

Last Visit: 31-Dec-99 18:00 Last Update: 23-Jun-24 22:13

Refresh

ᐊ Prev 1...9137 9138 9139 914091419142 9143 9144 9145 9146 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.