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
: [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.