C# Discussion Boards - CodeProject

deepak130-Mar-06 14:12

30-Mar-06 14:12

Hi
I am programming in c#.net. I want to insert i record into the SQL Server database. the datetime format in SQL server is mm/dd/yyyy where as in c# its dd/mm/yyyy. therefore when i try to insert dates where the day value is greater then 12 it gives out of range error.

Is there anyway we can change the format (dd/mm/yyyy to mm/dd/yyyy) of the datetime as we insert it into the sql server database.

Deepak Anish
Computer Programmer
Maxumise Fiji Ltd
Suva, Fiji

Re: datetime format in c# and asp.net

Guffa30-Mar-06 14:30

Guffa

30-Mar-06 14:30

Use parameterizes queries, then the date format is not a problem.

If you need to format the date as a string, I suggest that you use the ISO 8601 date format, e.g. yyyy-mm-dd. It's an unambigous date format, so the database can not misinterpret it.

---
b { font-weight: normal; }

Re: datetime format in c# and asp.net

V.30-Mar-06 20:17

30-Mar-06 20:17

I think you can pass the format via the ToString method.
If all else fails: see my
Article[^] Smile | :)

It's not the best according to readers, but it works Smile | :)

.

Coulda, woulda, shoulda doesn't matter if you don't.

how to enable doublebuffering in drawing shapes ?

hdv21230-Mar-06 12:14

hdv212

30-Mar-06 12:14

hi i draw a rectangle in picterebox and i want to rotate it around it's center and i want enable doublebuffering for prevent flicker and get highest quality
for my animation but it doesn't work

the ather problem is when i call g.Dispose(); in timer1_Tick event my app is crash .where does my problem and how to animate my rectangle with
doublebuffering and highest quality without flicker my animation ???
my code here :

Graphics g;
Pen m_pen;
Matrix mat;
int angle;
bool _doBuffer;

public Form1()
{
InitializeComponent();
this.SetStyle(ControlStyles.AllPaintingInWmPaint | ControlStyles.UserPaint | ControlStyles.DoubleBuffer ,true);
this.UpdateStyles();
m_pen = new Pen(Color.Violet,3);
bm = new Bitmap(src);
mat = new Matrix();
angle = 1;
_doBuffer = true;
}

private void button1_Click(object sender, System.EventArgs e)
{
g = pictureBox1.CreateGraphics();
g.DrawImage(bm,20,20,100,100);
timer1.Enabled = true;
timer1.Start();
Invalidate();
}
private Bitmap _backBuffer;
private void timer1_Tick(object sender, System.EventArgs e)
{
if(_backBuffer==null)
{
_backBuffer=new Bitmap(pictureBox1.ClientSize.Width,this.ClientSize.Height);
}
Graphics g=null;
if(_doBuffer)
g=Graphics.FromImage(_backBuffer);
else
g=pictureBox1.CreateGraphics();
g.Clear(Color.White);
g.SmoothingMode = SmoothingMode.AntiAlias;
p = new Point(70,70);
mat.RotateAt(angle,p);
g.Transform = mat;
g.DrawImage(bm,10,10,100,100);
//g.Dispose();
g.DrawImageUnscaled(_backBuffer,10,10,100,100);
Invalidate();
}

Re: how to enable doublebuffering in drawing shapes ?

leppie30-Mar-06 19:16

leppie

30-Mar-06 19:16

hdv212 wrote:
g = pictureBox1.CreateGraphics();

You approach is wrong. Only handle painting in the OnPaint event, you can however do the rest where you have them now.

xacc.ide-0.1.3.2

-- modified at 1:16 Friday 31st March, 2006

Get local time of a remote PC

bizdales30-Mar-06 11:55

bizdales

30-Mar-06 11:55

Hi,
Can someone show me how to put together a C# method to read the time of a remote PC, please. Thanks so much.

.NET Beginner

Re: Get local time of a remote PC

Joshua Quick30-Mar-06 14:30

Joshua Quick

30-Mar-06 14:30

An easy way to get a remote PC's current time would be to use the "NET TIME" console command. This will only work if your PC and the Remote PC are at least NT4. Also, this isn't the greatest method if you need to parse out the date time from the console output.

System.Diagnostics.Process proc = new System.Diagnostics.Process();<br />
proc.StartInfo.UseShellExecute = false;<br />
proc.StartInfo.CreateNoWindow = true;<br />
proc.StartInfo.RedirectStandardOutput = true;<br />
proc.StartInfo.FileName = "net";<br />
proc.StartInfo.Arguments = "time \\\\MyRemotePC";<br />
proc.Start();<br />
MessageBox.Show(proc.StandardOutput.ReadToEnd());<br />
proc.WaitForExit();<br />
proc.Dispose();

-- modified at 20:35 Thursday 30th March, 2006

Re: Get local time of a remote PC

bizdales31-Mar-06 6:04

bizdales

31-Mar-06 6:04

Hi Joshua,

Thanks for your help. I tried it and it worked. Is there a way to get the time with miliseconds also because I will also need the miliseconds?

.NET Beginner

Re: Get local time of a remote PC

Joshua Quick31-Mar-06 9:24

Joshua Quick

31-Mar-06 9:24

I'm sorry. I don't know how to get the milliseconds.

Re: Get local time of a remote PC

Joshua Quick31-Mar-06 9:29

Joshua Quick

31-Mar-06 9:29

If you're allowed to install your own app onto the remote PC, then you could use .NET Remoting (via TCP/IP) to get the date time in any format that you want. It would take a lot more doing on your part, but it would be the most powerful because you could provide all the info that your client app needs.

how to print a text?

abdelhameed8130-Mar-06 11:28

abdelhameed81

30-Mar-06 11:28

as a part of my project i hv to design a text editor i want to know how to make the normal options like cut , copy and paste
and above all how to print the document and see it in the print preview

thank u

abdelhameed81

Re: how to print a text?

Ravi Bhavnani30-Mar-06 12:53

Ravi Bhavnani

30-Mar-06 12:53

This[^] should help you get started.

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

App.config in Class Library

Stefano Alini30-Mar-06 10:42

Stefano Alini

30-Mar-06 10:42

Hi everybody,

I have a solution with 2 projects: a ASP.NET Project and a class library.I added App.config file to the class library but I can't access it.The class library uses the Web.config of the Web project. Does anyone know how to solve this problem?Thanks!!!

Stefano

Re: App.config in Class Library

LongRange.Shooter30-Mar-06 15:08

LongRange.Shooter

30-Mar-06 15:08

anything that you want in an App.config file in the webserver must be added in the web.config OR you have to manually read/access it.

app.config

i_martin_r30-Mar-06 10:08

i_martin_r

30-Mar-06 10:08

Hi,

I have an application that changes some properties of app.config file in some cases. But if you want your changes have effects, you have to restart the application. Is there any way my changes have effects without restarting?

Thanks.!!

Re: app.config

darkelv30-Mar-06 16:04

darkelv

30-Mar-06 16:04

I never need to restart the app, I just read the settings from the config again.

Are you referring to web app?

-- modified at 22:12 Thursday 30th March, 2006

Re: app.config

AB777130-Mar-06 17:05

AB7771

30-Mar-06 17:05

Even i am facing the same problem in a desktop application created in C#

If you have any solution please
send it to me too..

Thanks,
Pramod

Re: app.config

darkelv30-Mar-06 19:47

darkelv

30-Mar-06 19:47

Not really a 'solution', I always read the keys from file when I need them, so I always get the latest values from the config.

Maybe you can tell us in more specific why you need to restart the application when you have made changes to the config file.

Re: app.config

AB777130-Mar-06 21:57

AB7771

30-Mar-06 21:57

I have added the connection string for the database in the
app.config file when the application starts for the first time.

But when i add and later try to access the connection string from
the file it returns null, i debugged the whole application,
The file is modified but the object through which i read the file does not
displays the newly added value.

How have u done it?
can u tell me the procedure to do that.
I want to add a connection string value to the app.config file
when the application is started.
and then read this value later in the application without restarting it.

Thanks,
Pramod

Re: app.config

darkelv30-Mar-06 23:05

darkelv

30-Mar-06 23:05

As I wanted to change the key values in my apps during execution and reload the key values as needed, I use a custom class to read and write to the config file.

You can do a search on CP, there are a few of these custom classes, and see which one is more suitable for your needs.

Re: app.config

i_martin_r30-Mar-06 22:54

i_martin_r

30-Mar-06 22:54

I'm referring to a desktop application.

I can't modify a dll even though its AppDomain has been unloaded

kayhustle30-Mar-06 9:42

kayhustle

30-Mar-06 9:42

I needed to access an assembly, which I did by loading it into another AppDomain.
Next, I unload the AppDomain. Now when I try to open up that dll for writing it tells me that the file is being used by another process. I thought that the file got unloaded once the AppDomain was unloaded. That is the only reason I loaded the dll into another AppDomain, so that I could unload it and allow it to be overwritten afterward.

Here is my code. The dll is in the directory that the main executable is running in. This is the only way I got the domain to load the assembly. Once the domain loads the assembly a FileStream cannot be opened for writing on that file. It makes no sense because I unload the domain Unsure | :~

AppDomainSetup aps = new AppDomainSetup();<br />
           <br />
            aps.ApplicationBase=@"myapplocation";<br />
              AppDomain domain = AppDomain.CreateDomain("My New Domain",null,aps);<br />
            string apploc = @"myexecuting assembly location";<br />
            domain.ExecuteAssembly(apploc);<br />
           <br />
            Assembly ass = domain.Load("AdCenter");<br />
           <br />
            AppDomain.Unload(domain);<br />
           <br />
//The following call throws an exception saying that the file is in use by another process<br />
           FileStream fs = new FileStream("AdCenter.dll", FileMode.Open, FileAccess.ReadWrite);

Thanks

-- modified at 15:59 Thursday 30th March, 2006

Re: I can't modify a dll even though its AppDomain has been unloaded

Ed.Poore30-Mar-06 11:09

Ed.Poore

30-Mar-06 11:09

I don't think that there's any guarantee that the domain has been unloaded because the GC could still retain a reference to it.

Or then again maybe I'm confusing it with something else, although it's still worth checking up on.

Ed

Re: I can't modify a dll even though its AppDomain has been unloaded

leppie30-Mar-06 19:12

leppie

30-Mar-06 19:12

Check the VS.NET output window, when the 'apploc' assembly loads. What is happening most likely that one of the Types in AdCenter.dll is crossing the domain boundry and effectively locking it. If that is the case, you will have to be a bit more clever how you execute the additional appdomain, it will depend on what your code does, so I cant help you with that.

xacc.ide-0.1.3.2

Re: I can't modify a dll even though its AppDomain has been unloaded

Daniel Grunwald31-Mar-06 1:25

Daniel Grunwald

31-Mar-06 1:25

AppDomain.Load will load the assembly BOTH in the target domain AND current domain. AppDomain.Load is for calls through COM from unmanaged code only.
Use AppDomain.CreateInstanceAndUnwrap to create an instance of a MarshalByRef class in your main assembly in the target domain. That class then can use Assembly.Load to load additional assemblies that should be active only in the target AppDomain.

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