if statement (MySQL Connection == true) .. - C# Discussion Boards

Re: Remove a certain row from the Datatable

20-Jul-08 2:47

Hi,

perhaps the easiest way is to sort your datatable by duration using Select method and then iterate the results and delete the duplicate durations.

Hope this helps,

Mika

Guffa20-Jul-08 3:38

Guffa

20-Jul-08 3:38

Group by duration and use min(id) to get one of the records to keep, and use having to get the ones where count(*) > 1. Now join this result in a delete on the table, and specify the ones where id is different and duration is the same.

Despite everything, the person most likely to be fooling you next is yourself.

printing a page

SWAPNIL MISHRA20-Jul-08 0:50

SWAPNIL MISHRA

20-Jul-08 0:50

I have made a project in which i have generated a report with the help of data in the database. Now I need to print the report but I don't know how to include and print a *.doc extension file through the project.Please help me......

Re: printing a page

Mbah Dhaim20-Jul-08 3:13

20-Jul-08 3:13

1. save your report from database in temporary file and give extension .doc i.e: c:\temp\abcd.doc
2. call ShellExecute with parameter 'print' instead of 'open' (please read documentation about calling winapi method)

requirement : ms word

hope it helps

dhaim
programming is a hobby that make some money as side effect Smile | :)

Re: printing a page

Luc Pattyn20-Jul-08 3:53

Luc Pattyn

20-Jul-08 3:53

Hi,

you don't really need ShellExecute and WinApi; the Process class and ProcessStartInfo.Verb offer
the required functionality.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Re: printing a page

Mbah Dhaim20-Jul-08 5:40

if statement (MySQL Connection == true) ..

20-Jul-08 5:40

thanks fyi

dhaim
programming is a hobby that make some money as side effect Smile | :)

njitram20-Jul-08 0:27

njitram

20-Jul-08 0:27

Heyho SeeSharp PPL,

I have a question, for status connection:

        private void button2_Click(object sender, EventArgs e)<br />
        {<br />
            string MyConString = "SERVER=" + WheRe + ";DATABASE=" + dB + ";UID=" + aCC + ";PASSWORD=" + Pw + ";";<br />
            MySqlConnection connection = new MySqlConnection(MyConString);<br />
<br />
            if (connection.State == ConnectionState.Closed)<br />
            {<br />
                string code = "Connection failed!";<br />
            }<br />
            else<br />
            {<br />
                string code = "Connection successful!";<br />
            }<br />
<br />
<br />
            System.Windows.Forms.MessageBox.Show(this, code);<br />
            connection.Close();<br />
            this.Close();<br />
        }

How can i make the if statement to work it does show me anny errors.. and it doesnt work like i want it todo.. Frown | :(

Anny one? =)

Wendelius20-Jul-08 0:42

20-Jul-08 0:42

Hi,

Can't see any call to Open method so the connection will not be established. Try adding it before investigating connection state.

Also keep in mind that a connection has several possible states.

Mika

SWAPNIL MISHRA20-Jul-08 0:53

SWAPNIL MISHRA

20-Jul-08 0:53

use System.Data.OleDb.ConnectionState.State (while using ACCESS data base or use accordingly).

Guffa20-Jul-08 1:10

Guffa

20-Jul-08 1:10

When you open the connection, it will throw an exception if the connection fails.

Despite everything, the person most likely to be fooling you next is yourself.

njitram20-Jul-08 7:49

njitram

20-Jul-08 7:49

im not sure but, im looking for a sample piece for the statement..
Can some give me a sample?

Wendelius20-Jul-08 9:26

20-Jul-08 9:26

...
MySqlConnection connection = new MySqlConnection(MyConString);

try {
   connection.Open();
   System.Windows.Forms.MessageBox.Show(this, "Connection state is now " + connection.State);
   connection.Close();
} catch (System.Exception exception) { // or preferrably derived class for MySql exception instead of System.Exception
   System.Windows.Forms.MessageBox.Show(this, "Connection failed:\n\n" + exception.Message);
} finally {
   this.Close();
}

Was this what you were looking for?

Mika

njitram20-Jul-08 10:28

njitram

20-Jul-08 10:28

Thanks Mika! Smile | :)

Wendelius20-Jul-08 10:40

Re: Datatable select methode

20-Jul-08 10:40

You're welcome. Smile | :)

Datatable select methode

NewToAspDotNet20-Jul-08 0:18

NewToAspDotNet

20-Jul-08 0:18

Hi All,
Im using a string to select some rows from my datatable:
string expression;
expression = "Act = '001' ";
DataRow[] foundRowsq;
foundRowsq = dtPar.Select(expression);

Now how can i the not equal token in my expression? when i doe this im getting a error:
expression = "Act != '001' ";

So what should i use instead of != ?

Thanx.

Wendelius20-Jul-08 0:35

C# - How can I read website local path in IIS?

20-Jul-08 0:35

Try <> instead of !=

Mika

punkymt119-Jul-08 22:37

punkymt1

19-Jul-08 22:37

Hi, I am developing a windows application that reads info from IIS such as names of websites hosted and so on. I need to read the physical local directory of the website to know where it is situated on the hard drive. I can see it in the properties window under home directory tab but I cannot read it using code. E.g. Default Website -> C:\inetpub\wwwroot

Thank you.

Mbah Dhaim19-Jul-08 22:42

19-Jul-08 22:42

use ServerMapPath

dhaim
program is hobby that make some money as side effect Smile | :)

punkymt119-Jul-08 22:53

punkymt1

19-Jul-08 22:53

Thank you. I will try Smile | :)

Mbah Dhaim20-Jul-08 9:45

20-Jul-08 9:45

or use Request.ApplicationPath

dhaim
programming is a hobby that make some money as side effect Smile | :)