SFTP using FtpWebRequest class? - C# Discussion Boards

Re: Change datagridview scrollbar color

9-Nov-06 6:49

Mertli Ozgur Nevres wrote:
Is there any way to change a DataGridView's scrollbar color?

I would bet there is but why o why would you do that? The User is supposed to control the colors. WTF | :WTF:

led mike

Mertli Ozgur Nevres9-Nov-06 22:05

Mertli Ozgur Nevres

9-Nov-06 22:05

If i had a chance, i would never, never give that kind of innesential flexibilities to the user. But i am just a developer in a company. So i am developing a program and its backcolor is black. Because a stupid client wants it black. Mad | :mad:

I changed the DataGridView's backcolor to black, but the scrollbars are still gray, and it looks very ugly. Client does not want this, so i am trying to change their color to black, but i didn't find a way yet, and i don't know even it is possible or not. Confused | :confused:

ozgur.nevres

Re: Change datagridview scrollbar color

Mertli Ozgur Nevres9-Nov-06 23:47

Mertli Ozgur Nevres

9-Nov-06 23:47

It's ok
i found a great article here: http://www.codeproject.com/cs/miscctrl/customscrollbar.asp
And i solved the problem by the help of this great article.

Many thanks to Greg Ellis... Beer | [beer]

ozgur.nevres

SFTP using FtpWebRequest class?

Jason Weibel9-Nov-06 6:09

9-Nov-06 6:09

I am attempting to read an SFTP directory using the FtpWebRequest class, but am getting the error 'Unable to connect to the remote server'. Here is my code:

Private Sub List(ByVal listUrl As String, ByVal username As String, ByVal password As String)<br />
 Dim reader As StreamReader = Nothing<br />
 Dim listRequest As FtpWebRequest = WebRequest.Create(New System.Uri(listUrl))<br />
<br />
 System.Net.ServicePointManager.CertificatePolicy = New TrustAllCertificatePolicy<br />
 listRequest.Method = WebRequestMethods.Ftp.ListDirectoryDetails<br />
 listRequest.KeepAlive = True<br />
 listRequest.EnableSsl = True<br />
 listRequest.Credentials = New NetworkCredential(username, password)<br />
<br />
 Dim listResponse As FtpWebResponse = listRequest.GetResponse()<br />
 reader = New StreamReader(listResponse.GetResponseStream())<br />
End Sub<br />
<br />
Public Class TrustAllCertificatePolicy<br />
 Implements System.Net.ICertificatePolicy<br />
  Public Function CheckValidationResult(ByVal srvPoint As System.Net.ServicePoint, _<br />
            ByVal certificate As System.Security.Cryptography.X509Certificates.X509Certificate, _<br />
            ByVal request As System.Net.WebRequest, ByVal certificateProblem As Integer) As Boolean Implements System.Net.ICertificatePolicy.CheckValidationResult<br />
<br />
 Return True<br />
 End Function<br />
End Class<br />

I appreciate any advice you can provide into what I'm missing. Thank you,

led mike9-Nov-06 6:48

9-Nov-06 6:48

Jason, you posted a VB.NET question in the C# forum. Smile | :)

led mike

Jason Weibel9-Nov-06 7:09

9-Nov-06 7:09

Vb.net and c# are the same thing, more people visit this forum so I figure there is a better chance of getting an answer here.

led mike9-Nov-06 7:39

9-Nov-06 7:39

Jason Weibel wrote:
Vb.net and c# are the same thing

led mike

Jason Weibel9-Nov-06 7:52

9-Nov-06 7:52

Here is the C# version - I'm really not interested in getting into a C# is better then vb debate. I just want get this working so I can move on to the next item on my to do list.

private void List(string listUrl, string username, string password) <br />
{ <br />
 StreamReader reader = null; <br />
 FtpWebRequest listRequest = WebRequest.Create(new System.Uri(listUrl)); <br />
 System.Net.ServicePointManager.CertificatePolicy = new TrustAllCertificatePolicy(); <br />
 listRequest.Method = WebRequestMethods.Ftp.ListDirectoryDetails; <br />
 listRequest.KeepAlive = true; <br />
 listRequest.EnableSsl = true; <br />
 listRequest.Credentials = new NetworkCredential(username, password); <br />
 FtpWebResponse listResponse = listRequest.GetResponse(); <br />
 reader = new StreamReader(listResponse.GetResponseStream()); <br />
}<br />
 <br />
public class TrustAllCertificatePolicy : System.Net.ICertificatePolicy <br />
{ <br />
 public bool CheckValidationResult(System.Net.ServicePoint srvPoint, System.Security.Cryptography.X509Certificates.X509Certificate certificate, System.Net.WebRequest request, int certificateProblem) <br />
 { <br />
   return true; <br />
 } <br />
}

led mike9-Nov-06 8:53

9-Nov-06 8:53

Jason Weibel wrote:
I am attempting to read an SFTP directory using the FtpWebRequest class

Are you sure the Server is running?

led mike

Jason Weibel9-Nov-06 10:52

9-Nov-06 10:52

The server is running and I have no problem connecting with WS-FTP. I'm starting to wonder if FtpWebRequest works for SFTP. I have been reading some blogs and others are having the same problem but no one has a solution. Here are some links:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=346870&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=532122&SiteID=1
At this point I'm going to look into other ways to get this resolved.

led mike9-Nov-06 11:07

C# Express returning on }

9-Nov-06 11:07

Yes this entry from that blog holds the key

Actually, .NET 2.0 does not currently support implicit SSL, only explicit.  We will consider adding this for a future release.

led mike

Killer_XYZ9-Nov-06 6:05

Killer_XYZ

9-Nov-06 6:05

Visual c# express on Win XP x64

I wrote this part of the code:

<br />
for (int i = 1; i < 11; i++)<br />
{<br />
  for (int j = 1; j < 11; j++)<br />
  {<br />
    dataGridView1[i, j].Value = "0";<br />
  }<br />
}<br />

and the program seem to be returning form the method on the first } it encounters.
Debugging also shows that it starts doing the first for the goes to the 2nd one and when the 2nd one is finished it just drops out of the method.

but as for:

<br />
private int test()<br />
{<br />
  int g;<br />
  for (int i = 0; i < 9; i++)<br />
  {<br />
    g = 88;<br />
  }<br />
  g = 99;<br />
  return g;<br />
}<br />

99 is returned.

Any ideas what might be wrong?

Long live open source - Free source.

Re: C# Express returning on }

Guffa9-Nov-06 7:53

Guffa

9-Nov-06 7:53

The only reason that I could imagine for dropping out of a loop like that would be if the dataGridView1 did not contain 11 x 11 items so that you get an IndexOutOfRangeException exception, and that you have a try...catch somewhere that it will skip to.

Are the indices really one based, not zero based?

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

Re: C# Express returning on }

Killer_XYZ9-Nov-06 8:03

Killer_XYZ

9-Nov-06 8:03

Thank you.
It was that I did not generate enough rows.

But it seems strange to me that the program did continue just normally as I don't have any Try/Catch statements.
It was in : private void Form1_Load(object sender, EventArgs e); If that may be the reason.

Thank you for the help Smile | :)

Long live open source - Free source.

Re: C# Express returning on }

Guffa9-Nov-06 14:12

Guffa

9-Nov-06 14:12

Killer_XYZ wrote:
But it seems strange to me that the program did continue just normally as I don't have any Try/Catch statements.

It can't continue just normally, as there was an exception. If you don't catch it anywhere it will just bubble up to the application level, where IIS will log it and create an error page for the user.

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

how select adata from sql by c#

jemi jets9-Nov-06 5:41

jemi jets

9-Nov-06 5:41

was up all..any way after i have mad aconnection between c# and sql ..i wrote the code below to select frist name ,depratment no of the employess from my data base (company)..its run..but there was logic error D'Oh! | :doh:

!!
the code:
private void button4_Click(object sender, System.EventArgs e)
{
sqlcon.Open();
sqlcom.CommandText="select fname,dno from emp where ssn="+txt.Text+"";
SqlDataReader x = sqlcom.ExecuteReader ();
if(x.Read())
{
txtfname.Text=x.GetString(1);
txtdno.Text=x.GetDecimal(3).ToString();
}
else
{
MessageBox.Show("NOT FOUND");
}
sqlcon.Close();

}
note: the fname int ist sec columns and the dno in the 4th cloumn.>>>waiting...

ed^nrgc9-Nov-06 6:43

ed^nrgc

9-Nov-06 6:43

jemi jets wrote:
note: the fname int ist sec columns and the dno in the 4th cloumn.>>>waiting...

Need typing lessons?

What exactly is the error.

jemi jets9-Nov-06 9:37

jemi jets

9-Nov-06 9:37

thanks for ur help..i have fixed my error..and about the typing lessons stuff..iam working on it man..cheers up Smile | :)

ed^nrgc9-Nov-06 6:45

ed^nrgc

9-Nov-06 6:45

jemi jets wrote:
note: the fname int ist sec columns and the dno in the 4th cloumn.>>>waiting...

Need typing lessons? Confused | :confused:

What exactly is the error?