newbie moving from vb.net to c#

Mini_Maggit

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

IDK

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.