comm.CommandText="update_user1_1";
comm.Connection=cn;
comm.CommandType=System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@xm_1",System.Data.SqlDbType.NVarChar,255,"xm");
comm.Parameters.Add("@passwd_4",System.Data.SqlDbType.NVarChar,255,"passwd");
comm.Parameters["@xm_1"].Value=xm.Text;
comm.Parameters["@passwd_4"].Value=passwd.Text;
comm.ExecuteNonQuery();
其中update_user1_1。
CREATE PROCEDURE [update_user1_1](@xm_1 [nvarchar],@passwd_4 [nvarchar](255))AS UPDATE [school].[dbo].[user1] SET [passwd] = @passwd_4 WHERE ( [xm] = @xm_1 )
GO
comm.Connection=cn;
comm.CommandType=System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@xm_1",System.Data.SqlDbType.NVarChar,255,"xm");
comm.Parameters.Add("@passwd_4",System.Data.SqlDbType.NVarChar,255,"passwd");
comm.Parameters["@xm_1"].Value=xm.Text;
comm.Parameters["@passwd_4"].Value=passwd.Text;
comm.ExecuteNonQuery();
其中update_user1_1。
CREATE PROCEDURE [update_user1_1](@xm_1 [nvarchar],@passwd_4 [nvarchar](255))AS UPDATE [school].[dbo].[user1] SET [passwd] = @passwd_4 WHERE ( [xm] = @xm_1 )
GO
@xm nvarchar(255),
@psd nvarchar(255))AS UPDATE user1
SET passwd = @psd WHERE xm = @xm
GO
OracleCommand com=new OracleCommand(str,con) ;
com.CommandType = CommandType.StoredProcedure;
OracleParameter param;
param = com.Parameters.Add("xm",OracleType.VarChar);
param.Value = xm.Text;
param = com.Parameters.Add("passwd",OracleType.DateTime);
param.Value = passwd.Text;
con.Open();
com.ExecuteNonQuery();
con.Close();