C#

Re: get minimum date.

Nekshan25-Mar-07 23:37

Nekshan

25-Mar-07 23:37

yes my problem is solved.
datetime datatype stores data in mm/dd/yyyy format.
now its working.
thank you. Smile | :)

Re: get minimum date.

virendra patel25-Mar-07 23:42

virendra patel

25-Mar-07 23:42

which query u r using for fetch min date from database.

Declare a varible globally

selvakumar Panchatcharam25-Mar-07 20:57

selvakumar Panchatcharam

25-Mar-07 20:57

hi
in C#, how can i make a varible to access globally, through out my project.

Regards,
Selva.

Re: Declare a varible globally

rah_sin25-Mar-07 21:13

rah_sin

25-Mar-07 21:13

if u want to read the value of any variable through out the project then u can declare it in app.config file through key and value tag,and can read it any time using System.Configuration.ConfigurationSettings.AppSettings["key"].ToString();

rahul

Re: Declare a varible globally

CPallini25-Mar-07 21:45

CPallini

25-Mar-07 21:45

You can declare the variable (say myVar) as a static member of a class (say myClass) and then access it, wherever you need, simply using myClass.myVar.
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

constructing an sql connection with out sql support.

Keshav V. Kamat25-Mar-07 20:53

Keshav V. Kamat

25-Mar-07 20:53

hello people,

I have an sql connection like the following. it works perfectly fine. I am using sql server'05.

SqlConnection conn = new SqlConnection("Data Source=" + Environment.MachineName + "\\WINCC;Integrated Security=SSPI;Initial Catalog=Logger; Packet Size = 32766;");

However, i want to have a connection so that my application runs on any machine, that does not have the sql server.

thanks

Keshav Kamat Smile | :)

India

Re: constructing an sql connection with out sql support.

Corinna John25-Mar-07 22:39

Corinna John

25-Mar-07 22:39

Keshav V. Kamat wrote:
i want to have a connection so that my application runs on any machine

Activate TCP/IP and the "Server Browser Service" in the SQLServer's configuration dialog.
Locally, the SQLServer uses Named Pipes fpor comminucation with clients.
To talk to remote clients, it needs CP/IP.
To find the instance "WINCC" by name, the clients need the browsing service.

____________________________________
There is no proof for this sentence.

Re: constructing an sql connection with out sql support.

Keshav V. Kamat25-Mar-07 23:21

Keshav V. Kamat

25-Mar-07 23:21

Thanks.

But still, I want the connection to work when there is no SQL installed on a machine.
instance "WINCC" is fine. i could let an open file dialog or a simple text box do the job.

But I feel creating a database without any data source would be impossible.
thanks anyways.

Keshav Kamat Smile | :)

India

Re: constructing an sql connection with out sql support.

Corinna John26-Mar-07 1:38

Corinna John

26-Mar-07 1:38

SQLServer can run on any remote machine. The client application finds the server by servername\instancename in the connection string. Activate TCP/IP and Browser Service on the remote server and your clients will run fine.

____________________________________
There is no proof for this sentence.

Window problem [modified]

7125-Mar-07 20:37

25-Mar-07 20:37

Hi,all
I am creating a editor and main from is made as an MDI parent and i want to implement a Find Functionality..

if i opened the Find form and Minimize the main from the find also should be minimized ..

i want something like pls refer..

open notepad Type somethingclick Find and minimize the notepad....

the find form also will be minimized like...

the same thing

With Regards
prasad

Smile | :)

Re: Window problem

baerten25-Mar-07 21:25

baerten

25-Mar-07 21:25

Hi, i try to help you.

If Form2 should do the same like Form1, you should try to create the Form2 in Form1.

So you have a reference to the Form2. You create form2 for example at the constructor of form1.
MyForm1::MyForm1(void)
{
OtherForm = new MyForm2; ( OtherForm should be a class member, to have all the time an access)
}

then you derive the ShowDialog() Method. there in you call naturally the base-method and then the ShowDialog of the Form2 "OtherForm.ShowDialog"

In this way you proceed with all methods you need.
If ShowDialog is protected/private for Form2, you need to derive also ShowDialog from Form2 but
as public.

I hope i could help you a little bit.

Good luck Smile | :)

Re: Window problem

7125-Mar-07 21:46

25-Mar-07 21:46

hi,friend
i will clear it u

I am creating a editor and main from is made as an MDI parent and i want to implement a Find Functionality..

if i opened the Find form and Minimize the main from the find also should be minimized ..

i want something like pls refer..

open notepad Type somethingclick Find and minimize the notepad....

the same thing

With Regatds
prasad

Re: Window problem

stancrm25-Mar-07 21:32

stancrm

25-Mar-07 21:32

1. Use Show(), not ShowDialog()
2. Use event SizeChanged in Form1.

private void Form1_SizeChanged(object sender, EventArgs e)
{
  this.form2.WindowState = this.WindowState;
}

Re: Window problem

7125-Mar-07 21:47

25-Mar-07 21:47

Re: Window problem

baerten25-Mar-07 22:07

baerten

25-Mar-07 22:07

yepp,

i came to the same solution.

But there is still the problem, that the "FindWindow" disappears behind the MainForm, if the
MainForm gets the focus.

But i never made things like this in C# before Big Grin | :-D

How do you get the file name.

Muammar©25-Mar-07 20:26

Muammar©

25-Mar-07 20:26

Hi everyone,
Can anyone please tell me how do you get only the file name out of openFileDialog1.FileName, cuz I keep getting the path along with the file name.

Many thanks Rose | [Rose]

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: How do you get the file name.

Leslie Sanford25-Mar-07 20:40

Leslie Sanford

25-Mar-07 20:40

<br />
string fileName = Path.GetFileName(openFileDialog1.FileName);<br />

Re: How do you get the file name.

Muammar©25-Mar-07 20:46

Muammar©

25-Mar-07 20:46

Path

what's this??

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: How do you get the file name.

Martin#25-Mar-07 21:10

Martin#

25-Mar-07 21:10

Hello,

Look at the System.IO namespace.
There you will find the path class, with a lot of fancy methods.

All the best,

Martin

Re: How do you get the file name.

Muammar©

25-Mar-07 21:16

Martin# wrote:
... a lot of fancy methods.

Thank you Martin, you're the fancy one Smile | :)

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: How do you get the file name.

Keshav V. Kamat25-Mar-07 20:50

Keshav V. Kamat

25-Mar-07 20:50

i hope this helps. this open file dialog is for xml files only. use the file extensions accordingly.

OpenFileDialog ofn = new OpenFileDialog();
ofn.Filter = "XML Files (*.xml)|*.xml";
 ofn.Title = "Type File";
if (ofn.ShowDialog() == DialogResult.Ok)
{
         // do work here.
}

then u can get the file name as

ofn.FileName

Keshav Kamat Smile | :)

India

Re: How do you get the file name.

Muammar©

25-Mar-07 21:12

Keshav V. Kamat wrote:
i hope this helps

Sorry, but not at all Frown | :(

I'm well familiar with the OpenFileDialog, my question was how to get only the file name and FileName property is giving me the full path.. thanks anyways buddy.

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

wat is the equlent of Server.MapPath in Windows Appliction

pashitech25-Mar-07 19:44

pashitech

25-Mar-07 19:44

hi all,
i am working in windows form, i couldn't reach to the destination file when in use(""..\\..\file name");
which method should i use to reach to a perticular dirctory of my machine,
i know in web i used to use server.mappath...but here i don't know,
bye byes

prashanth

Re: wat is the equlent of Server.MapPath in Windows Appliction

rah_sin25-Mar-07 20:08

rah_sin

25-Mar-07 20:08

if u want to know the application path of ur program then u can use
Application.StartupPath;

rahul

Re: wat is the equlent of Server.MapPath in Windows Appliction

Harini N K25-Mar-07 20:15

Harini N K

25-Mar-07 20:15

Hi
You can get using Application instead of Server. Try this

Application.StartupPath.ToString(); -> this will give the current application path.

There are some properties for the class Application like:

- ExecutablePath
- LocalUserAppDataPath

Hope this helps you.

Harini

General News Suggestion Question Bug Answer Joke Praise Rant Admin

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