1)DROPDOWNLIST.SelectedItem.Value或者DROPDOWNLIST.SelectedItem.Text等等。
都可以取得 DROPDOWNLIST 中的值。
2)SqlCommand objCommand = new SqlCommand(strProcName,sqlConnection);
objCommand.CommandType = CommandType.StoredProcedure;
SqlParameter myParm = objCommand.Parameters.Add("@mdn",SqlDbType.VarChar,15);
myParm.Value = strMDN; SqlParameter myParm1= objCommand.Parameters.Add("@register",SqlDbType.VarChar,15);
myParm1.Direction = ParameterDirection.Output;
。。
objCommand.ExecuteNonQuery();这些都应该在 Framework SDK 中可以找到用法,假如想学好一点,建议多看看
都可以取得 DROPDOWNLIST 中的值。
2)SqlCommand objCommand = new SqlCommand(strProcName,sqlConnection);
objCommand.CommandType = CommandType.StoredProcedure;
SqlParameter myParm = objCommand.Parameters.Add("@mdn",SqlDbType.VarChar,15);
myParm.Value = strMDN; SqlParameter myParm1= objCommand.Parameters.Add("@register",SqlDbType.VarChar,15);
myParm1.Direction = ParameterDirection.Output;
。。
objCommand.ExecuteNonQuery();这些都应该在 Framework SDK 中可以找到用法,假如想学好一点,建议多看看
CREATE PROCEDURE sp_zhouxp_isExistedFromUserBasicInfo
(@mdn [nvarchar](15) ,
@register [int] output
AS
begin
select @register=RegisterStatus from UserBasicInfo where MDN=@mdn
end;
GO
CREATE PROCEDURE sp_zhouxp_isExistedFromUserBasicInfo
(@mdn [nvarchar](15) ,
@register [int] output)
AS
begin
select @register=RegisterStatus from UserBasicInfo where MDN=@mdn
end;
GO