C#Net2008 Stored Procedures

[Lennie]

Hi Csharp Good Guys

I am encountering another interesting problem using C#.
I am writing coding to pass parameters to SQL SERVER Stored Procedure to updata the TABLE but instead it generated 3 error messages on compilation.

The main error seems to be caused by this coding statement which add value to the parameters that generate ERROR 1 of the 3 error messages:

sqlCmd.Parameters <---- cause ERROR 1
-------------------------------------
Here are the 3 error messages:
Error 1 Non-invocable member 'System.Data.SqlClient.SqlCommand.Parameters' cannot be used like a method.
Error 2 Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)
Error 3 Operator '==' cannot be applied to operands of type 'string' and 'System.DBNull'
-------------------------------------------------

Here are the coding:

private void FUpdateCreateRecOrders() 
 
       {
           sqlconn = new SqlConnection(connstr);
           sqlcmd = new SqlCommand();
           sqlcmd.Connection = sqlconn;

            // CALL STORE PROCEDURE
            sqlcmd.CommandText = "SPMaintTestOrdersTBL";
            sqlcmd.CommandType = CommandType.StoredProcedure;
         
             //create  input parameter direction and define SQL SERVER DataType
             sqlcmd.Parameters.Add("@OrderID", SqlDbType.Int, 4).Direction = ParameterDirection.Input;                
             sqlcmd.Parameters.Add("@OrderDate",SqlDbType.DateTime,8).Direction = ParameterDirection.Input;
             sqlcmd.Parameters.Add("@ShipVa",SqlDbType.Int,4).Direction = ParameterDirection.Input;
             sqlcmd.Parameters.Add("@Freight",SqlDbType.Money,8).Direction = ParameterDirection.Input;
                 
             //parameter values                  
             sqlcmd.Parameters ("@OrderID").Value= Convert.ToInt32(intPOrderID);                   
             sqlcmd.Parameters ("@OrderDate").Value = this.txtOrderDate.TextLength == 0? String.Empty: DateTime.Parse(this.txtOrderDate.Text);
             sqlcmd.Parameters  ("@ShipVia").Value = cboTransport.Text == System.DBNull.Value ? string.Empty: this.cboTransport.SelectedValue;
             sqlcmd.Parameters  ("@Freight").value = txtFreight.TextLength ==0? 0.00: (Double) txtFreight.Text;  
                 
       }

[Lennie]

Hi Csharp NewBies

I would like to share with you the coding which is working now. Here is the brief description of the coding function.

The textbox controls data are being retrieve and used as parameters to update the SQL SREVER table using STORED PROCEDURES within the SQL SERVER. The transfer of parameters are based on SQLCMD.PARAMETERS.ADD function.

private void FUpdateCreateRecOrders()

{
sqlconn = new SqlConnection(connstr);
sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlconn;

// CALL STORE PROCEDURE
sqlcmd.CommandText = "SPMaintOrdersTBL";
sqlcmd.CommandType = CommandType.StoredProcedure;

//create input parameter direction and define SQL SERVER DataType
sqlcmd.Parameters.Add("@OrderID", SqlDbType.Int, 4).Direction = ParameterDirection.Input;
sqlcmd.Parameters.Add("@CustID", SqlDbType.nchart, 4).Direction = ParameterDirection.Input;
sqlcmd.Parameters.Add("@OrderDate",SqlDbType.DateTime,8).Direction = ParameterDirection.Input;
sqlcmd.Parameters.Add("@ShipVa",SqlDbType.Int,4).Direction = ParameterDirection.Input;
sqlcmd.Parameters.Add("@Freight",SqlDbType.Money,8).Direction = ParameterDirection.Input;

//parameter values

sqlcmd.Parameters ["@OrderID"].Value= Convert.ToInt32(intPOrderID);
sqlcmd.Parameters ["@CustID"].Value= Convert.string(txtCustID.text);
sqlcmd.Parameters ["@OrderDate"].Value = this.txtOrderDate.TextLength == 0? String.Empty: DateTime.Parse(this.txtOrderDate.Text);
sqlcmd.Parameters ["@ShipVia"].Value = cboTransport.Text == System.DBNull.Value ? string.Empty: this.cboTransport.SelectedValue;
sqlcmd.Parameters ["@Freight"].value = txtFreight.TextLength ==0? 0.00: (Double) txtFreight.Text;

}

Here is the Stored Procedure:
Create Procedure SPMainOrdersTBL
@OrderID int,
@CustID nchar(5),
@OrderDate datatime,
@ShipVia int,
@Freight money,
as
begin
Update Orders
set CustomerID = @CustID,
OrderDate = @OrderDate,
ShipVia = @shipVia,
Freight = @Freight

Where OrderID = @OrderID
end
Go