• thanks grooshopper but i resolve my probleme here my code is now

    Dim

    sqlcon As New SqlClient.SqlConnection

    sqlcon.ConnectionString =

    "Data Source=WISEMAN\SQLEXPRESS;Initial Catalog=Productdetail;Integrated Security=True;Pooling=False;uid=uid;pwd=pwd "

    Dim cmd As New SqlClient.SqlCommand

    cmd.Connection = sqlcon

    cmd.CommandType = CommandType.StoredProcedure

    cmd.CommandText =

    "insertcustomer"

    cmd.Parameters.AddWithValue(

    "@detail", TextBox2.Text)

    sqlcon.Open()

    cmd.ExecuteScalar()

    sqlcon.Close()

     

    and now it work fine for my delete,update,and insert Procedure

     

    thanks you for the help