|
After running any type of query just fire following query to know
number of rows affected.
SELECT @@rowcount AS 'RowsChanged'
Hope this will help!
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
Fill a data adapter with a dataset. Then count the rows.
Some thing like:
int totalRow = Dataset.Tables[0].Rows.Count;
|
|
|
|
|
The reader does not have a count.
You could however use an ExecuteScalar to get the count.
int i = (int)cmd1.ExecuteScalar();
|
|
|
|
|
How exactly do you reckon this will return the row count?
What is cmd1.CommandText in this case?
|
|
|
|
|
I have finished building an desktop application that is similar to Yahoo Messenger.
It has a client side and a server side and it is built using System.Runtime.Remoting
and uses a Singleton model.
I have registered a channel on the client side and on the server side like this:
ChannelServices.RegisterChannel(channel,false);
...
MarshalByRefObject obj = (MarshalByRefObject)RemotingServices.Connect(typeof(IServer),
"http://"+hostIP+":8980/Server");
Global.server=obj as IServer;
(obj as RemotingClientProxy).Timeout=5000;
where hostIP an IP address of the server location.
Until now I have used only 127.0.0.1 (localhost) for the server , but when I change the value to
my IP address, I get the following error:
{"Unable to connect to the remote server"} System.Exception {System.Net.WebException}
with the message :
"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"
Does anyone knows how to solve this issue? Should I configure in some way the server(my computer) ?
Please help me .
Thanks in advance!
|
|
|
|
|
Your firewall is probably on. Open port 8980 for the interface on which you are trying to connect.
|
|
|
|
|
I have turned off my firewall and I don't get any error but now it doesn't connect at runtime with the server.
Do you have any other ideas I could try?
|
|
|
|
|
Not really
Is this your pc's IP address, or the IP address of your Internet router? If it's your router, you'll have to set up port forwarding on the router.
|
|
|
|
|
I think is the IP of the router ...
Could you give me an idea about how should set up this port ?
Thanks for your reply !
|
|
|
|
|
Your should read your routers documentation for that.
The general principle is that an incoming connection on your router's ip is forwarded to a pc on your network, so in your case you should forward port 8980 on the routers external interface to port 8980 on your pc (giving the ip address of the pc)
|
|
|
|
|
Hello,
I would execute this commande : ftp -s:c:\config.txt
whene i excute this command in cmd console, it work, but how i can excute it in c#, please help me to resolve this great problem, thank you verry mutch.
|
|
|
|
|
|
|
Hello,
I try for this:
<br />
try<br />
{<br />
<br />
<br />
System.Diagnostics.ProcessStartInfo psi =<br />
new System.Diagnostics.ProcessStartInfo(@"ftp -s:c:\config.ini");<br />
Process ggh = Process.Start(psi);<br />
ggh.WaitForExit();<br />
<br />
}<br />
catch (Exception ex)<br />
{ Console.Write(ex.ToString()); }<br />
<br />
i have an exception : {System.ComponentModel.Win32Exception: Le fichier spécifié est introuvable
à System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo)
à System.Diagnostics.Process.Start()
à System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
à FTP.Program.Main(String[] args) dans C:\Documents and Settings\Bureau\FTP\FTP\Program.cs:ligne 104}
Thank you verry mutch.
|
|
|
|
|
abbd wrote: @"ftp -s:c:\config.ini"
|
|
|
|
|
Hello,
When i put this command in cmd console, its work, the file config.ini conatins the parameters of connection to the ftp file, how i can excute this command in c#, thank you.
|
|
|
|
|
is it ftp.exe or config.ini that isn't found? try changing one or the other and compare results.
is the folder containing ftp.exe part of your PATH environment variable? why don't you use an absolute path here?
|
|
|
|
|
Thank you for your answer, i use command ftp of windows, it was not an exe, in console CMD, i succed to excute the same command, but in c# it don't work, help to resolve thise great problem, thank you verry mutch.
|
|
|
|
|
use C:\Windows\System32\ftp.exe in your Process statement, rather than just ftp .
It is a real exe, there is no built-in ftp command!
|
|
|
|
|
Is there a good source for documentation on COM libraries? Specifically, I am looking into Faxcomlib.dll, such as the possible values for QueueStatus (for example). Thank you!
Also, I have read this article and it was helpful as a start:
Faxing with XP and C#[^]
|
|
|
|
|
The vendor who wrote the library is the best you're going to get. If they dont' have any docs, then the quality of what's out there goes down dramatically to what people have figured out and speculate on how to use properly.
|
|
|
|
|
You might want to try and open this dll in the API Viewer (that came along when you installed Visual Studio 6).
|
|
|
|
|
You realize that the API Viewer looked at a huge, and incomplete, text file for it's data? All it does is provide a VB6 header for calling WIn32 functions. It provides no documentation on anything and doesn't even inspect actual .DLL's for anything.
|
|
|
|
|
I see what you mean - maybe then OLE Viewer could at least help the OP see the QueueStatus values(if it is an enum)?
modified on Friday, May 7, 2010 11:23 PM
|
|
|
|
|
The API Viewer will only list the values defined in the text file. It will not tell you what they are used for nor if you can combine them, and again, only for Win32 functions. It will do nothing for any library outside of Win32 nor anything added to Win32 after about 20 years ago.
|
|
|
|