Im using the Data Access Application Block in my application. I can't insert the information successfully into my sql database. No error message come out. Can anybody give me some opinion on this?


using (SqlConnection conn = new SqlConnection(dbConn) )
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
SqlParameter [] arParms = new SqlParameter[2];
arParms[0] = new SqlParameter("@Ic_No", SqlDbType.VarChar,20,"Customer_Ic_No");
arParms[0].Direction = ParameterDirection.Input;
arParms[0].Value = txtIC.Text;
arParms[1] = new SqlParameter("@Name", SqlDbType.Char, 25,"Customer_Name");
arParms[1].Direction = ParameterDirection.Input;
arParms[1].Value = txtName.Text;
sqllHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "usp_AddCustomerRecord", arParms);
trans.Commit();
}
}

I can't find a version of ExecuteNonQuery that has the parameters you've specified. What type is sqlHelper?

Other than that your code looks fine. Does the stored procedure work when you run it in Query Analyzer?

Kep.

Try removing the commandtype.
sqllHelper.ExecuteNonQuery(conn, "usp_AddCustomerRecord", arParms);


======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

Im using the Microsoft Data Access Application Blocks. That's why can use the sqllHelper.ExecuteNonQuery(conn, "usp_AddCustomerRecord", arParms); i have removed the "CommandType.StoredProcedure" in the executeNonQuery... but still no didn't work... I think i didn't connect it to the database... but everything is fine.... below is my sql statement. maybe you all have helped me to have a look.

use Northwind

CREATE PROCEDURE usp_AddCustomerRecord
    (
    @Ic_No varchar(20),
    @Name Char(25)
    ) AS

INSERT INTO CustomerData
    (
    Customer_Ic_No,
    Customer_Name
    )

VALUES
    (
    @Ic_No,
    @Name
    )

Thx guys.... i figured it out myself already.

sqllHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "usp_AddCustomerRecord",

The "conn" should be replaced with the "trans". :)
It works now... :)