int [,,] myArray = new int [,,] {{1,2,3}};

[Ahmad Mahmoud candseeme]

Hi i been awak for two nights i can't see anything infront of me BUT i must complete this int [,,] myArray = new int [,,] {{1,2,3}}; it gives me the error Incorrectly structured array initializer WHY -------------------------- If you found my answer to your question useful; then vote for me. ------------------------ Ahmad Shaban

[Stefan Troschuetz]

What exactly are you trying to do with this line of code?

---

www.troschuetz.de

[Ahmad Mahmoud candseeme]

Hi Stefan Troschütz Thank you i found the error object [,,] myArray; myArray = new object [,,] { { {"@EngCode"},{SqlDbType.Int},{TxtCode.Text} } }; --------------------------------- I Have a stroed procedure that take 13 parameter CREATE PROCEDURE dbo.CreateUser ( @EngCode int, @EngFName nvarchar(20), @EngMName nvarchar(20), @EngGName nvarchar(20), @EngLName nvarchar(20), @EngNotes nvarchar(500) , @EngineeerTypeID int, @UserName nvarchar(10), @EngMail nvarchar(50), @EngCellNo int, @EngHNo int, @UserPassword nvarchar(12), @UserNotes nvarchar(500) ) I call this proc from my C# sO SqlParameter POne = new SqlParameter(); POne.ParameterName = "@ParaName"; POne.Value = MyText.Text; POne.SqlDbType = SqlDbType.NVarChar; MyCommand.Parameters.Add ( Pone ); i will repeat this operation 13 time But if i had a Multidimensional array myArray = new object [,,] { { {"@EngCode"},{SqlDbType.Int},{TxtCode.Text} } }; and have a foreach to loop; it would be then a better idea -------------------------- If you found my answer to your question useful; then vote for me. ------------------------ Ahmad Shaban

[Guffa]

You can write those five lines of code in a single line: MyCommand.Parameters.Add(new SqlParameter("@ParaName", SqlDbType.NVarChar)).Value = MyText.Text; Notice that the Add method returns a reference to the parameter, so that you can set the value property. --- b { font-weight: normal; }

[Ahmad Mahmoud candseeme]

Hi Thank you very much But we should put it that way MyCommand.Parameters.Add(new SqlParameter("@ParaName", SqlDbType.NVarChar).Value = MyText.Text ); Thank You again -------------------------- If you found my answer to your question useful; then vote for me. ------------------------ Ahmad Shaban

[Guffa]

No, that doesn't work. The value of the operation or assigning the string to the Value property, is the string. The result is that you will be throwing the SqlParameter object away and adding the string to the parameter collection instead. Use the method that I showed, or this even shorter one: MyCommand.Parameters.Add("@ParaName", SqlDbType.NVarChar).Value = MyText.Text; --- b { font-weight: normal; }