newbie moving from vb.net to c#

Hi guys,

I'm busy moving over to C# from VB.Net and there are a few syntax issues I have. I wonder if you could help?

For instance, in VB.Net to modify a database you would do this:

[code] With daCategory.DeleteCommand
.Parameters("@ID").Value = textbox1.text
.Connection.Open()
.Prepare()
.ExecuteNonQuery()
.Connection.Close()
End With[/code]

so I tried this in C#:

[code]daCategory.DeleteCommand.Parameters("@ID").Value = textbox1.text;
daCategory.DeleteCommand.Connection.Open();
daCategory.DeleteCommand.Prepare();
daCategory.DeleteCommand.ExecuteNonQuery();
daCategory.DeleteCommand.Connection.Close();[/code]

but the compiler has issues with the 'Parameters' keyword... What is the correct syntax for this type of command?

Oh, this is using stored procedures in a SQL Server database...

Thanks

Comments

  • Try to do this:

    : [code]daCategory.DeleteCommand.Parameters("@ID") = new type??(textbox1.text);
    : daCategory.DeleteCommand.Connection.Open();
    : daCategory.DeleteCommand.Prepare();
    : daCategory.DeleteCommand.ExecuteNonQuery();
    : daCategory.DeleteCommand.Connection.Close();[/code]

    I don't know anything about this but do like this and change the type to the right one and I think it should work better.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion