newbie moving from vb.net to c# - Programmers Heaven

Howdy, Stranger!

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

Categories

newbie moving from vb.net to c#

Mini_MaggitMini_Maggit Posts: 28Member
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

  • IDKIDK Posts: 1,784Member
    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.