public static void ExecuteGetButtonBrowse(BindingDataEventArgs e, string storedProcedureName) { using (var conn = new SqlConnection(BaseAppConfig.ConnectionString)) { var cmd = new SqlCommand(storedProcedureName, conn) { CommandType = CommandType.StoredProcedure }; if (BaseAppConfig.CommandTimeout != null) { cmd.CommandTimeout = BaseAppConfig.CommandTimeout.Value; } cmd.Parameters.Add("@objectName", SqlDbType.NVarChar).Value = e.DatabaseObjectName; cmd.Parameters.Add("@paramInt", SqlDbType.Int).Value = e.ParamInt; cmd.Parameters.Add("@paramString", SqlDbType.NVarChar).Value = e.ParamString; cmd.Parameters.Add("@paramGuid", SqlDbType.UniqueIdentifier).Value = e.ParamGuid; cmd.Parameters.Add("@paramDateTime", SqlDbType.DateTime).Value = e.ParamDateTime; conn.Open(); var obj = cmd.ExecuteScalar(); if (obj != null) { e.Text = obj.ToString(); } } }
public static void ExecuteGetButtonBrowse(BindingDataEventArgs e) { ExecuteGetButtonBrowse(e, "dbo.SP_GetButtonBrowse"); }