[02/03] Stuck in C# code

[jnaneswari]

Hi,
i am very new to C#.

Actually i have written these lines of code in class file.But it is giving error.-- near dataset word --Expected Class,enum,structure,delegate, interface,why , what may be the problem, same lines of code in vb.net is working fine.

using System;
using System.Data;
using System.Data.SqlClient;

public static DataSet returndataset(string connectionstring, string str)
{
SqlConnection con = new SqlConnection(connectionstring);
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds;
}

Kindly help me to solve this problem.And suggest some links to study C#.

Thanks in advance

[jmcilhinney]

Perhaps the C# forum would be a more appropriate place for this thread. I suggest that you PM a mod and ask them to move it.

The reason for your error is that you must declare a type before you can declare a member. You've declared a method, which cannot exist on its own. It must be within a type declaration. That's why you're told that it is expecting one of those list of things, all of which are types.

[RobDog888]

Moved

[mendhak]

same lines of code in vb.net is working fine.

I doubt it.

To add a class to your project, right click your project, add new, and choose class. It will come 'pre-coded' like a skeleton. In the closet.