I need to convert a program that was written in Java to C# and I am trying figure out the meaning of the below, can any help?

            CallableStatement cs = myConn.prepareCall("{call matchHost(@pHost=?)}");
            cs.setString(1, Name + "[a-z][a-z]");
            ResultSet myHostsAlpha = cs.executeQuery();

while(myDouble.next){...code is here...}

What is a CallableStatement in C#

what is a setString in C#

what is a ResultSet in C#

Hi,

java doesn't know the concept of properties like .NET does so they split up a getter and setter of a property out as functions with get or set prefixes. So in your case setString(...) would become cs.String = ...; 

A resultset would be a DataSet in .NET.

Actually what they're doing here apparently is to create a (for sql) SqlCommand instance, set the parameter collection of it and fill up a dataset.

Grz, Kris.

Wow! Thanks.  The CallableStatement cs is a call the Storedprocedure matchHost so I did the call in a method like this:

private void Search6HostPlaces(string host)
    {
        host = lblHostname.Text;

        try
        {
            using (SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
            {
                SqlCommand cmd = new SqlCommand("matchHost", cn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@pHost", host);
            }
        }
        catch(SqlException e)
        {
            lblMsgErr.Visible = true;
            lblMsgErr.Text += "<br><b>Search6HostPlaces_Error</b>" + e.Message;
        }
        lblTest.Text = host;
    }

So would create a DataSet method at this point?

Hi,

you create an instance of a SqlDataAdapter and use its Fill method to fill up the dataset instance.

Grz, Kris.

So, I'm on the right course...correct?

Hi,

yes you are. I can also advise this article Using ADO.NET with SQL Server.

Grz, Kris.