|
Ok that works great  Thanks! 
There is no spoon.
|
|
|
|
|
Check out this article[^].
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines]
Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
I am looking for a hosting company to host ASP.net 2.o that support Dynamic Fonts and AJAX with no traffic tie ups. It will be great if someone can direct me ont this. Thanks in advance!
|
|
|
|
|
Hi All,
I have a datatable :
id name duration
01 001 00:10
02 002 00:20
03 003 00:10
As you can see, rows 0 and 2 have the same duration: 00:10
Now how can i make a algorimte to remove all those rows(except ONE of those rows) that has the same duration from my datatable ?
Thanx.
modified on Sunday, July 20, 2008 8:20 AM
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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......
|
|
|
|
|
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
|
|
|
|
|
Hi,
you don't really need ShellExecute and WinApi; the Process class and ProcessStartInfo.Verb offer
the required functionality.
|
|
|
|
|
thanks fyi
dhaim
programming is a hobby that make some money as side effect
|
|
|
|
|
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.. 
Anny one? =)
|
|
|
|
|
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
|
|
|
|
|
use System.Data.OleDb.ConnectionState.State (while using ACCESS data base or use accordingly).
|
|
|
|
|
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.
|
|
|
|
|
im not sure but, im looking for a sample piece for the statement..
Can some give me a sample?
|
|
|
|
|
...
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) {
System.Windows.Forms.MessageBox.Show(this, "Connection failed:\n\n" + exception.Message);
} finally {
this.Close();
}
Was this what you were looking for?
Mika
|
|
|
|
|
Thanks Mika! 
|
|
|
|
|
You're welcome.
|
|
|
|
|
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.
|
|
|
|
|
Try <> instead of !=
Mika
|
|
|
|
|
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.
|
|
|
|
|
use ServerMapPath
dhaim
program is hobby that make some money as side effect
|
|
|
|
|
Thank you. I will try
|
|
|
|
|
or use Request.ApplicationPath
dhaim
programming is a hobby that make some money as side effect
|
|
|
|
|
Sorry but my application is windows not web.
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
