ORA-00947: not enough values

ORA-00947:	not enough values
Cause:	This error occurs when a SQL statement requires two sets of values equal in number, but the second set contains fewer items than the first set. This can occur in a WHERE or HAVING clause in which a nested SELECT returns too few columns as in: WHERE (A,B) IN (SELECT C FROM ...) Another common cause of this error is an INSERT statement in which the VALUES or SELECT clause does not contain enough values needed for the INSERT, as in INSERT INTO EMP(EMPNO,ENAME) VALUES('JONES')
Action:	Check the number of items in each set and change the SQL statement to make them equal.

Download And Upload A File Using C#

The System.Net namespace contain most of the .NET base class that deal with networking from perspective of the client. The System.Net namespace is generally concerned with Higher-level operations for example download and upload files and making requests using the HTTP and other protocols.

The WebClient Class

If you want to do is carry out a fairly simple operation such as requesting a file from a particular URL, Then you will probably find easiest .NET class to use is System.Net.WebClient. This class is extremely high-level class Designed to perform basic operations with only one or two commands

Downloading Fiels:

There are two ways of downloading a file from a web site using WebClient, depending on whether we want to save the file, or process the contents of the directly within your application. If we simply want to save the file then we should call the DownloadFile() method takes two parameters, The URL from where we want to retrieve the file, and the file name ( or path) that we want to save the file to.

WebClient Client = new WebClient (); Client.DownloadFile("http://www.csharpfriends.com/Members/index.aspx", " index.aspx");

More commonly, your application will want to process the data retrieved from the web site. In order to do this, you use the OpenRead () method, Which returns a stream reference. You can then simply retrieve the data from the stream.

WebClient Client = new WebClient (); Stream strm = Client.OpenRead ("http://www.csharpfriends.com/Members/index.aspx");

The following code will demonstrate the WebClient.OpenRead () method.

In this case we will simply display the contents of the downloaded data in list box.

We create the project as standard Windows C# application, and a list box called listbox1, in which we will display the contents of the downloaded file. We make the following changes to the constructor of the main form.

public form1() { InitializeComponent(); System.Net.WebClient Client = new WebClient(); Stream strm = Client.OpenRead("http://www.csharpfriends.com"); StreamReader sr = new StreamReader(strm); string line; do { line = sr.ReadLine(); listbox1.Items.Add(line); } while (line !=null); strm.Close(); }

Updating Files

The webClient class also features UploadFile() and UploadData() methods. The diffrence between them is that UploadFile() uploads a specified file given the file name, While UploadData() uploads binary data, which is supplied as an array of bytes:

WebClient Client = new WebClient(); Client.UploadFile("http://www.csharpfriends.com/Members/index.aspx", "c:\wesiteFiles\newfile.aspx"); byte [] image; //code to initialise image so it contains all the binary data for some jpg file client.UploadData("http://www.csharpfriends.com/Members/images/logocc.jpg", image);

In this way we can download and upload a file through c# project Try to upload files to yours web sites and download files